Method for CSV import in Excel 2013 is illogical
Make a new spreadsheet from CSV data:
File -> Open or File -> Import
Instead have to do File -> New Workbook
Data -> Import
Two ppl took 20mins + google to find out how to import CSV data... UI failure
When importation of a file CSV with unicode UTF-8. The file generated in excel give number with a space for thousand. How can i convert the number 1 000 to 1000 in the excel file. The number lower than 1000 appear on the right of the colonn wheras number greater than 1 000 appear on the left of the colonn.
Corey Becker commented
They redesigned the Data tab in 2016. You can just click "New Query" and then select CSV. Should be easier than the way you were doing it before. Ideally, you're only doing this once and setting it to update automatically.