How to Open a CSV file in Excel?

CSV (Comma-Separated Values) files are commonly used to store data like contact lists, subscriber exports, or reports. While Microsoft Excel can open CSV files by default, it often displays the data incorrectly — especially when your computer's regional settings use a different separator (e.g., semicolon instead of comma).

This guide shows you the correct way to open and view your CSV files in Excel without converting or damaging your data.

Option 1: Open CSV in Excel Using the Data Import Wizard

(This is the recommended method to ensure correct formatting.)

1. Open Microsoft Excel (start with a blank workbook).
2. Click the Data tab in the top menu.
3. Choose From Text/CSV (this may be called “Get External Data” on older versions).
4. Browse and select your CSV file, then click Import.

5. In the import preview window:

   • Make sure File Origin is correct (e.g., “65001: Unicode (UTF-8)”).
   • Set Delimiter to Comma (or Semicolon, depending on your file).
   • Review the data preview — it should now appear neatly in columns.
6. Click Load to open the file as a table in Excel.

Option 2: Open CSV File Directly (Quick & Simple)

(Use this method if your CSV uses commas and Excel is set up for comma delimiters.)

1. Locate your CSV file on your desktop or file explorer.
2. Right-click the file and choose Open With > Excel.

3. The file opens, but:

   • If the columns look scrambled (e.g., all data in column A), you’ll need to use Option 1 instead.

Option 3: Use Text to Columns (Fix After Opening)

(Use this if your CSV opened into a single column.)

1. Open the CSV file in Excel (even if the data appears incorrect).
2. Select Column A (where all the text is crammed).
3. Go to the Data tab and click Text to Columns.
4. Choose Delimited, then click Next.
5. Tick Comma as the delimiter (and untick other options), then click Finish.
6. Your data should now appear properly spread across columns.

Extra Tips

• Always backup your CSV before making changes.
• If you export CSVs from platforms like BulkMail, make sure they are UTF-8 encoded.
• For non-English Excel users (e.g., Afrikaans or European languages), check your regional settings to confirm your default delimiter.