What a CSV file is and why you'd import it

A CSV file (comma-separated values) is a plain-text document where data sits in rows and columns, separated by commas. It looks like a spreadsheet but isn't one — it's just text. Excel can't read it as a spreadsheet unless you import it, which tells Excel where the column breaks are and formats the data into cells.

You'll encounter CSV files when you export data from a website, read a report from your bank, or receive a contact list from someone else. The file has a .csv extension instead of .xlsx (Excel's native format). Importing converts that text into an actual Excel spreadsheet you can sort, filter, and edit.

Key Takeaways

  • CSV files are plain text with data separated by commas; Excel needs to import them to display the data in cells instead of as text.
  • The simplest method is to open the CSV file directly in Excel, which usually formats it correctly without extra steps.
  • If data lands in a single column instead of spreading across columns, use the Text to Columns feature to split it at the commas.
  • Save the imported file as .xlsx if you want to keep it in Excel format and preserve any formatting or formulas you add.

Opening a CSV file directly in Excel

The fastest way to import a CSV file is to open it the same way you'd open any Excel file. In Excel, go to File > Open, navigate to your CSV file, select it, and click Open. Excel recognizes the .csv extension and imports the data automatically, placing each comma-separated value into its own cell across the columns.

This method works for most CSV files without any additional steps. The data appears formatted and ready to use. If your CSV file has headers (column names in the first row), Excel preserves them as the first row of your spreadsheet.

Using Text to Columns when data doesn't split correctly

Sometimes a CSV file opens with all the data crammed into a single column instead of spreading across multiple columns. This happens when Excel doesn't recognize the comma as a separator. To fix it, select the column containing all the data, then go to the Data tab and click Text to Columns.

A dialog box appears. Choose Delimited (not Fixed Width), then click Next. On the second screen, check the Comma box under Delimiters and uncheck any others. Click Next again, and the preview shows how your data will split. Click Finish, and Excel redistributes the data across the correct columns.

This feature works on any column of text, not just CSV imports. It's useful whenever you need to split text at a specific character.

Handling special characters and formatting issues

CSV files sometimes contain special characters — quotation marks, line breaks, or symbols from other languages — that can cause formatting problems during import. Excel usually handles these correctly, but occasionally a cell displays the raw character code instead of the symbol itself.

If this happens, check the original CSV file in a text editor (like Notepad) to see what the data actually contains. Some CSV files use a different character encoding (the system that tells computers how to display text). If you're importing a file created on a Mac or in another country, the encoding might differ from your system's default. Most modern versions of Excel handle this automatically, but if you see garbled text, try opening the file in Notepad, saving it as UTF-8 encoding, and then importing it again.

Converting and saving your imported data

Once your CSV data is in Excel, it still exists as a CSV file on your computer — the import doesn't change the original file. If you make changes in Excel and want to keep them, you need to save the file in Excel format. Go to File > Save As, choose Excel Workbook (.xlsx) from the file type dropdown, give it a name, and click Save.

Saving as .xlsx preserves any formulas, formatting, or additional data you've added. If you save it back as CSV, Excel strips out formatting and formulas, keeping only the raw data. Use CSV format only if you need to share the data with a program that doesn't read Excel files.

Importing multiple CSV files at once

If you have several CSV files to import, you can open them all in separate Excel windows and copy data between them. Open the first CSV file, then open a second one — Excel creates a new window for each. You can then switch between windows and copy columns or rows from one file to another using standard copy-and-paste.

For larger projects where you're combining many files, consider opening each CSV file, copying all its data, and pasting it into a single master spreadsheet. Add a column to identify which file each row came from if you need to track the source later.

Common reasons CSV imports fail or look wrong

The most common issue is data landing in the wrong columns, which happens when the CSV file uses a different delimiter (semicolon or tab instead of comma). Check the original file in Notepad to see what separates the columns. If it's not a comma, use Text to Columns and select the correct delimiter instead.

Another issue is dates appearing as numbers like 44562 instead of a readable date. This happens because Excel stores dates as numbers internally. Select the column, right-click, choose Format Cells, select Date from the Category list, and pick your preferred date format. The numbers convert to readable dates when ready.

If a column of numbers displays as text (left-aligned instead of right-aligned), select the column, go to Data > Text to Columns, click Next twice without changing anything, and click Finish. This forces Excel to recognize the values as numbers.

Frequently Asked Questions

Can I import a CSV file that's already open in another program?

Close the file in the other program first. If the file is open elsewhere, Excel may not be able to read it or may open a read-only copy. Once you close it in the original program, you can import it into Excel without issues.

What's the difference between importing a CSV and just opening it?

There's no practical difference — opening a CSV file in Excel is the import process. Excel recognizes the .csv extension and automatically converts the comma-separated text into cells. No separate import tool is needed.

Will importing a CSV file change the original file?

No. Importing opens a copy of the file in Excel. The original CSV file on your computer stays unchanged. Any edits you make only affect the version open in Excel unless you explicitly save it back to the original location.

How do I import a CSV file that uses semicolons instead of commas?

Open the CSV file in Excel, select all the data, go to Data > Text to Columns, choose Delimited, and check the Semicolon box instead of Comma. Click Finish, and Excel will split the data at the semicolons.

Can I automate importing multiple CSV files into one spreadsheet?

Excel doesn't have a built-in automation tool for this, but you can use Power Query (in newer versions) to combine multiple files. Go to Data > Get Data > From File > From Folder, select the folder containing your CSV files, and Power Query will combine them into a single table.