this post was submitted on 23 Aug 2023
70 points (100.0% liked)
Programming
13368 readers
2 users here now
All things programming and coding related. Subcommunity of Technology.
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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