/
Convert a CSV file to an XLS file 1 (EXCEL)

Convert a CSV file to an XLS file 1 (EXCEL)

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.

 

Related content

Convert a CSV file to an XLS file (EXCEL)
Convert a CSV file to an XLS file (EXCEL)
More like this
Convertir un fichier CSV vers un fichier XLS (EXCEL)
Convertir un fichier CSV vers un fichier XLS (EXCEL)
More like this
Importer vos équipes hors Québec
Importer vos équipes hors Québec
More like this
Reports - Travel Permit
Reports - Travel Permit
More like this
Reports
More like this
Reports - Users
Reports - Users
More like this