The simplest way to open a CSV in Excel

Open Excel, go to File > Open, and select your CSV file. Excel will read the comma-separated values and place each value into its own cell automatically. Once the file is open, save it as an Excel file by going to File > Save As, choosing your location, typing a new filename, and selecting Excel Workbook (.xlsx) from the file type dropdown. Click Save.

This method works for most CSV files. However, if your CSV contains special characters, dates in unusual formats, or numbers that should stay as text (like ZIP codes or account numbers), Excel may misinterpret them during the import. The next section covers how to handle those cases.

Key Takeaways

  • The fastest method is opening the CSV file directly in Excel and saving it as .xlsx format using File > Save As.
  • If Excel misaligns your data or changes how numbers and dates appear, use the Text Import Wizard by opening a blank workbook and using Data > Get External Data > From Text.
  • CSV files use commas as separators, but some regions use semicolons or tabs instead — the import wizard lets you specify which one your file uses.
  • After converting, check that ZIP codes, phone numbers, and leading zeros did not disappear or change format.

Using the Text Import Wizard for problem files

If your CSV file has data that Excel is placing in the wrong columns or reformatting unexpectedly, use the Text Import Wizard for more control. Open a blank Excel workbook, go to the Data tab, click Get External Data (or From Text in older versions), and select your CSV file.

The wizard opens in three steps. In Step 1, choose the delimiter — this is the character that separates your data. Most CSV files use commas, but some use semicolons, tabs, or pipes. Select the one that matches your file, and the preview at the bottom will show how your data will split into columns. In Step 2, you can adjust the column widths if needed. In Step 3, you can set the data type for each column — this is where you tell Excel to treat a column as text (to preserve leading zeros in ZIP codes) or as a date in a specific format. Click Finish, choose where to place the data in your workbook, and then save the file as .xlsx.

Handling ZIP codes, phone numbers, and leading zeros

Excel treats numbers as numbers by default, which means it strips leading zeros. A ZIP code like 01234 becomes 1234. A phone number formatted as 0123456789 loses the leading zero. To prevent this, use the Text Import Wizard and set those columns to Text format before importing.

If you have already converted the file and the zeros are gone, you can fix it by opening the original CSV file again using the Text Import Wizard, setting the affected columns to Text format, and re-saving. Alternatively, in the Excel file itself, select the column, right-click, choose Format Cells, select Text, and then re-enter the values — but this is slower if you have many rows.

Converting multiple CSV files at once

If you have many CSV files to convert, opening and saving each one individually takes time. A faster approach is to use a batch conversion tool or a straightforward script, but for most people, the quickest manual method is to open all your CSV files in Excel at once. Open Excel, go to File > Open, hold Ctrl (or Cmd on Mac) and click each CSV file you want to convert, then click Open. Each file opens in its own tab or window.

Then go through each tab, check that the data looks correct, and save each one as .xlsx using File > Save As. You can also use the Find & Replace feature to rename them all at once if they follow a pattern — for example, changing all filenames from "data_january.csv" to "data_january.xlsx" — but you must still save each file individually.

Why your CSV might not convert cleanly

CSV files are plain text, so they do not store formatting like colors, bold text, or merged cells. When you convert a CSV to Excel, you get only the raw data in a grid. If your original CSV was exported from a program that added extra spaces, line breaks within cells, or special characters, Excel may display those exactly as they appear in the text file.

Some CSV files also use a different character encoding — for example, UTF-8 or Latin-1 — which can cause special characters like accented letters or symbols to display incorrectly. If this happens, open the file using the Text Import Wizard and look for an encoding option (usually near the bottom of Step 1). Try a different encoding and check the preview to see if the characters display correctly.

Saving as Excel without losing data

When you save a CSV as .xlsx, Excel may warn you that some features will be lost. This is normal — it is just telling you that the CSV format does not support Excel-specific features like formulas, charts, or cell formatting. If your CSV contains only data (no formulas or formatting), you can safely click Yes or Continue.

If you want to keep a copy of the original CSV file as well, use Save As instead of Save, give the file a new name, and select .xlsx format. Your original CSV file remains unchanged. This is useful if other programs or people depend on the CSV version.

Frequently Asked Questions

Can I convert a CSV to Excel without opening it in Excel?

Yes. You can rename the file extension from .csv to .xlsx, but this only changes the label — the file is still plain text inside. The safer method is to use an online converter or a spreadsheet program like Google Sheets, which can open the CSV and let you read it as an Excel file. However, the direct method of opening it in Excel and saving it is usually fastest and most reliable.

What if my CSV file uses semicolons instead of commas?

Use the Text Import Wizard. In Step 1, uncheck Comma and check Semicolon instead. The preview will show your data splitting into the correct columns. This is common in European countries where the comma is used as a decimal separator.

Will formulas in my CSV convert to Excel formulas?

No. CSV files store only text and numbers, not formulas. If your CSV contains a cell with the text "=SUM(A1:A10)", it will import as plain text, not as a working formula. You must recreate formulas in Excel after converting the file.

How do I know if the conversion worked correctly?

Open the converted Excel file and scroll through it to check that data is in the right columns, numbers have not changed (especially ZIP codes and phone numbers), and dates display as expected. Compare a few rows to the original CSV file if you are unsure. If something looks wrong, go back to the original CSV and use the Text Import Wizard to re-import with different settings.

Can I convert an Excel file back to CSV?

Yes. Open the Excel file, go to File > Save As, select CSV (Comma delimited) from the file type dropdown, and click Save. Excel will warn you that some features may be lost — this is expected, since CSV does not support formatting or multiple sheets. Only the active sheet will be saved.