The simplest way to open a CSV file in Excel

Open Excel first, then use File > Open instead of double-clicking the CSV file from your computer. This gives Excel a chance to ask how you want the data split into columns before it guesses wrong. Double-clicking a CSV file often opens it in Notepad or another program, or Excel imports it with all the data crammed into a single column.

When you click File > Open in Excel, navigate to your CSV file and select it. Excel will show you a preview window before you commit. Look at the preview — if your data is already split into separate columns the way you want it, click Import or Open. If everything is bunched together in one column, you need the Text Import Wizard, which appears automatically on the next screen.

The Text Import Wizard is where most people get confused, but it is just asking one real question: what character separates your columns? For most CSV files, the answer is a comma. Make sure Comma is checked in the Delimiters section, look at the preview at the bottom to confirm your columns are now separate, and click Finish.

Key Takeaways

  • Open Excel first, then use File > Open to select your CSV file, rather than double-clicking the file itself.
  • The Text Import Wizard asks what character separates your columns — for CSV files, check the Comma box and look at the preview to confirm the split is correct.
  • If your CSV uses semicolons or tabs instead of commas, uncheck Comma and check the delimiter that matches your file.
  • After import, save the file as an Excel workbook (.xlsx) if you want to keep it in Excel format and add formulas or formatting.

When the Text Import Wizard does not appear

If you double-clicked the CSV file and it opened in Excel with all the data in column A, you can still fix it. Select all the data in column A by clicking the column header, then go to Data > Text to Columns. This opens the same wizard that should have appeared during import.

Choose your delimiter (usually Comma), check the preview, and click Finish. Excel will split the data across columns. If you have formulas or other work in columns to the right, Excel will warn you that it will overwrite them — in that case, insert new columns first or copy this data to a blank area of the sheet.

Saving your CSV file as an Excel workbook

Once your CSV is open and the columns are correct, you can save it as an Excel file (.xlsx) so you can add formulas, formatting, and multiple sheets. Go to File > Save As, choose a location, and change the file type dropdown from "CSV" to Excel Workbook (.xlsx). Give it a new name if you want to keep the original CSV unchanged.

Be aware that saving as .xlsx means the file is no longer a CSV. If you need to send this data to another program or person who expects a CSV, you will need to save it as CSV again — go to File > Save As, change the type back to CSV (Comma delimited), and click Save. Excel will ask if you want to keep the current format; click No to save as CSV.

Fixing common import problems

If your data has commas inside the values — for example, a company name like "Smith, Jones & Associates" — those commas can split the data wrong. Look at the preview in the Text Import Wizard. If you see a company name split across two columns, your CSV file probably uses a different delimiter. Check if there is a semicolon or tab between your actual columns, and select that delimiter instead.

If some columns show numbers that look like dates (like 1/2/3), Excel may have auto-formatted them. After import, right-click those columns and choose Format Cells. Select Text from the Category list and click OK. This prevents Excel from changing how the data looks. You may need to re-enter the data in those cells for the text format to take effect.

If your CSV has a header row (column names at the top), the Text Import Wizard has a field at the bottom that says "Header row number" — it usually defaults to 1, which is correct. Leave it alone unless your headers are on a different row.

Opening a CSV file on Mac

On a Mac, the process is nearly identical. Open Excel, click File > Open, and select your CSV file. The Text Import Wizard appears the same way. Check Comma in the Delimiters section, verify the preview looks right, and click Finish.

If you double-clicked the CSV and it opened in Numbers (Apple's spreadsheet program) instead of Excel, you can still open it in Excel the same way — just make sure you are opening Excel itself first, not clicking the file. If you want CSV files to always open in Excel by default, right-click the CSV file, select Open With, choose Excel, and click Change All.

When to keep a file as CSV instead of converting to Excel

CSV files are simpler and smaller than Excel files, and they work across almost every program and operating system. If you are sharing data with someone who uses a different spreadsheet program, or if the file is very large, keeping it as CSV makes sense. You can still open it in Excel to view and edit it — just remember that if you save it as .xlsx, the other person may not be able to open it in their program.

If you are building a spreadsheet with formulas, multiple sheets, or complex formatting, convert it to .xlsx. CSV files do not support formulas, multiple sheets, or most formatting, so those features will be lost if you save back to CSV. Think of CSV as a format for moving raw data between programs, and .xlsx as a format for building something with that data.

Frequently Asked Questions

Why does my CSV file open in Notepad instead of Excel?

Your computer is set to open CSV files with Notepad by default. Right-click the CSV file, select Open With, choose Excel, and click Change All to make Excel the default. After that, double-clicking will open it in Excel. On Mac, right-click, select Open With, choose Excel, and click Change All.

Can I edit a CSV file in Excel and save it back as CSV?

Yes. Make your changes in Excel, then go to File > Save As, change the file type to CSV (Comma delimited), and click Save. Excel will warn you that some features may be lost — that is normal. Click Save again to confirm. The file will be saved as CSV with your edits.

What if my CSV file uses semicolons or tabs instead of commas?

In the Text Import Wizard, uncheck Comma and check Semicolon or Tab instead, depending on what separates your columns. Look at the preview to confirm the split is correct before clicking Finish. Some European CSV files use semicolons as the standard delimiter.

Will I lose data if I convert a CSV to an Excel file?

No. Converting from CSV to .xlsx keeps all your data intact. The only difference is that .xlsx can store formulas, multiple sheets, and formatting, while CSV cannot. If you add formulas or formatting in Excel and then save back to CSV, those additions will be lost.

How do I open a CSV file that is very large?

Large CSV files can slow down Excel. Open Excel first, go to File > Open, and select your file. If Excel becomes unresponsive, you may need to use a different tool — some text editors and database programs handle large CSV files faster. For most files under 100,000 rows, Excel works fine.