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.
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.