My wife didn’t understand why I got so excited reading this article.

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

Create a post

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.

  • 1 user online
  • 1 user / day
  • 1 user / week
  • 7 users / month
  • 88 users / 6 months
  • 1 subscriber
  • 303 Posts
  • 2.15K Comments
  • Modlog