Warning: Some posts on this platform may contain adult material intended for mature audiences only. Viewer discretion is advised. By clicking ‘Continue’, you confirm that you are 18 years or older and consent to viewing explicit content.
Excel can’t import a CSV file reliably though - and neither can any other spreadsheet software I’ve ever tested. They have problems with dates, numeric values, etc.
The only reliable way to work with CSV is in a programming language of your choice or a plain text editor.
I’ve never had any issue and have used CSV for years from hundreds of sources. I prefer the “what you see is what you get” and not Excel’s “helpful” guessing at dates.
Excel can’t even get it’s own shit right when it’s in XLSX:
Or you know, use a non-proprietary format like CSV and analyze your data in any language you damn well please.
Excel can’t import a CSV file reliably though - and neither can any other spreadsheet software I’ve ever tested. They have problems with dates, numeric values, etc.
The only reliable way to work with CSV is in a programming language of your choice or a plain text editor.
I’ve never had any issue and have used CSV for years from hundreds of sources. I prefer the “what you see is what you get” and not Excel’s “helpful” guessing at dates.
Excel can’t even get it’s own shit right when it’s in XLSX:
https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates