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:
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programming@beehaw.org
All things programming and coding related. Subcommunity of Technology.
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