Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

There are two ways to convert a CSV file to an Excel file (XLS)

 

OPTION 1

  • Open the CSV file

    Select column A

    Click on the Data tab

    Click on Convert

  • In the pop-up window that will appear, select Delimited and then click on Next.

  • In the next window, select Tab and Comma, click Next.

  • In the last window make sure that the column data format is checked at Standard and that the destination is indeed your column A.

    Click on Finish.

  • Your Excel file will be ready and your data will be displayed in individual columns.

OPTION 2

 

  • Download the CSV file and save it

    Open a new Excel sheet

    Click on the Data tab

    Click on From Text File/CSV

  • Select the saved CSV file

    Click on Import

A window will appear, make sure the following information is selected:

File origin: select 65001: Unicode (UTF-8)

Delimiter: select comma

Click on Load

  • Your Excel file will be ready, your data will be displayed in individual columns and in a table format.

  • No labels