Convert a CSV file to an XLS file (EXCEL)

Owned by Melanie Bujold
Last updated: Jul 29, 2024 by Annick Chiasson
2 min read

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.