Skip to main content

How to choose the separator when opening a CSV file in Excel?

When you open a CSV file in Excel, you can choose the separator used in the file to correctly parse the data into columns. Here's how you can do it:

1. Open Excel: Launch Microsoft Excel on your computer.

2. Open a New Workbook or Worksheet:

  • If you want to open the CSV data in a new workbook, just open Excel.

  • If you want to open the CSV data in an existing workbook, open that workbook.

3. Import Data:

  • Click on the "Data" tab in the Excel ribbon.
    ​

  • Look for the "Get Data" or "Get & Transform Data" section, which might vary slightly depending on your version of Excel.
    ​

  • Click on "Get Data" or a similar option. In older versions of Excel, you might find "From Text" or "From Text/CSV."

4. Choose the CSV File:

  • A file dialog will open. Navigate to the location of the CSV file you want to open and select it.

5. Choose the Delimiter:

  • In the "Text Import Wizard" or similar dialog, you'll see an option to choose the delimiter used in your CSV file.
    ​

  • Common options include "Comma," "Semicolon," "Tab," or you can choose "Other" and specify a custom delimiter.

6. Preview and Adjust Settings:

  • Excel will show you a preview of how the data will be separated based on your chosen delimiter.
    ​

  • You can also adjust other settings like data type detection and text qualifiers at this stage.

7. Finish Importing:

  • Once you're satisfied with the settings, click the "Finish" or "Load" button, depending on your version of Excel.
    ​

  • This will import the CSV data into your Excel workbook.

8. Review and Save:

  • After the data is imported, it will be displayed in your Excel worksheet.
    ​

  • Review the data to ensure it's properly formatted.
    ​

  • If needed, you can further adjust column widths, data types, and other formatting.

9. Save Your Workbook:

  • If you made changes to the imported data or want to keep the data in the Excel format, make sure to save your workbook.
    ​

Remember that the exact steps and options might vary slightly depending on the version of Microsoft Excel you're using. This guide provides a general overview of the process.

Did this answer your question?