Hacker News new | ask | show | jobs
by c4mpute 983 days ago
The LibreOffice CSV import is configurable. The Excel one isn't.

You can do things in PowerQuery, but that is far from obvious and still buggy. Not to mention all the woes after import, like date/time auto-interpretation and autocorrections that cannot be switched off.

I stand by what I said. Excel imports are a huge mess.

3 comments

Would you like me to send you some online tutorials on how to import CSVs into excel? Because at this point it's just crazy. Are you using excel 2009? Do you not know about the "Data" tab in the ribbon? There's a whole dialog to complete with several options when you import a CSV file.
Cut it with the attitude. This is not the place for it.
Who are you?
Are you evaluating import or open? Open does stuff to the data right away, import lets you push buttons first:

https://www.fcc.gov/general/opening-csv-file-excel

Powerquery oh god never again!