top | item 37824122

(no title)

c4mpute | 2 years 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.

discuss

order

uxp8u61q|2 years ago

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.

ellyagg|2 years ago

Cut it with the attitude. This is not the place for it.

Seanambers|2 years ago

Powerquery oh god never again!