Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the “Get & Transform” tools. The “Get & Transform” tools offer a lot of options and are very powerful. Unfortunately, they are quite complicated to use. Here is what you should now.
Tag: csv
How to Import CSV Files to Excel
There are two ways to import data from CSV files to Excel. Open a CSV file by double-clicking on it or use the import function. The import function has an advantage: You can define the details of the import, for instance, set the meaning of thousand separators.