By using Excel's text import wizard, you can ensure data in *.csv is correctly imported into Excel.

1.  Download and save your *.csv file to your chosen location.

2. Open Excel with a blank or existing workbook open.

3. Select 'Data' on the ribbon, and then 'From Text'. (If the menu options are greyed out this could be because you do not have a workbook open).

4. Browse for the *.csv file you want to open, and click 'Import'.

5. In the Text import wizard, ensure the 'Delimited' option is selected. For File origin, ensure "Unicode (UTF-8)" is selected. This is to ensure all types of characters are correctly imported. Click Next.

6. In the delimiters section, tick 'Comma'. The text qualifier box should show the double-quote symbol. Click Next.

7. Click on "Advanced..." and ensure the decimal separator is a dot and the thousands separator is a comma. This is to ensure numbers are imported correctly. Click OK and then Finish

8. It may ask you 'Where do you want to put the data?'. It will allow you to click into any cell on the blank worksheet to determine where the data should go. Click 'OK' to proceed.

9. The data should now appear in the spreadsheet. Where column headings are included these will appear in the top row.

Did this answer your question?