A useful tip to know, for those times when Excel is refusing to properly load a .CSV file. Open the file in Notepad++ and just add…


sep=;


…right at the start of the file. Save and exit. This command then forces Excel to open its separated data-import wizard, on import. In the three-step Wizard, set to Delimited and Commas…