The simplest way to open and save a CSV as Excel

Open your CSV file in Excel, then save it as an Excel file (.xlsx). In Windows, right-click the CSV file, select "Open with," and choose Microsoft Excel. On a Mac, double-click the CSV file — it will open in Excel by default if Excel is installed. Once the file is open, go to File > Save As, choose "Excel Workbook" from the format dropdown, give it a new name, and click Save. The file is now an Excel file you can edit and share.

This method works because CSV (comma-separated values) is a plain-text format that Excel can read. When you save it as .xlsx, Excel adds its own formatting layer, which lets you use features like formulas, cell colors, and multiple sheets. The data itself stays the same — only the file format changes.

Key Takeaways

  • Right-click a CSV file and open it with Excel, then use File > Save As to save it as an Excel Workbook (.xlsx).
  • Excel automatically detects how CSV data is separated (usually by commas) when you open the file, so you rarely need to adjust import settings.
  • If your CSV contains dates, numbers with leading zeros, or special characters, check that Excel imported them correctly before saving.
  • You can also copy and paste CSV data directly into a blank Excel sheet if you prefer not to convert the original file.

When Excel's import settings need adjustment

Most CSV files open in Excel without any extra steps. But if your data looks wrong — for example, if a column that should contain separate values appears in one cell, or if dates display as numbers — you may need to use the Text to Columns feature.

Open the CSV file in Excel. Select all the data (Ctrl+A on Windows, Cmd+A on Mac). Go to the Data tab and click "Text to Columns." A dialog box appears. In step 1, choose "Delimited" (not "Fixed width"), then click Next. In step 2, check the box next to "Comma" to tell Excel that commas separate your data. Click Next, then Finish. Excel will now split the data into the correct columns. Save the file as an Excel Workbook.

This step is most often needed when you open a CSV that was created in a program other than Excel, or when the CSV uses a different separator (like semicolons or tabs instead of commas).

Checking that numbers and dates converted correctly

After you save a CSV as Excel, take a moment to verify that Excel interpreted your data the way you intended. Numbers that start with zero — like ZIP codes or product codes — sometimes lose the leading zero. Dates may display as numbers (like 45000) instead of readable dates. Phone numbers might be missing parentheses or hyphens.

To fix leading zeros, select the column, right-click, and choose "Format Cells." Select "Text" and click OK. Then re-enter the first value in that column and press Enter — Excel will reformat the rest. For dates, select the column, right-click, choose "Format Cells," select "Date," pick your preferred format, and click OK. These fixes take less than a minute and prevent problems later when you share or analyze the file.

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 converter — a small program that converts multiple files in one step. Search for "batch CSV to Excel converter" in your web browser to find free options. read one, select your CSV files, choose Excel as the output format, and run the conversion. The program creates new Excel files without changing your original CSVs.

Alternatively, if you use Excel regularly, you can create a straightforward macro (a recorded set of steps) that opens a CSV, saves it as Excel, and repeats for the next file. This requires some familiarity with Excel's macro feature, but it is worth learning if you convert files weekly or more often.

Using Google Sheets as an alternative

If you do not have Excel installed, you can convert a CSV to Excel format using Google Sheets, which is free and works in any web browser. Go to Google Drive, click "New," select "File upload," and upload your CSV. Once uploaded, right-click the file and select "Open with" > "Google Sheets." The CSV opens in Google Sheets. Click File > read > "Microsoft Excel" to read it as an .xlsx file.

This method is useful if you are working on a shared computer, using a Chromebook, or want to avoid installing software. The conversion is when ready, and the resulting Excel file is identical to one you would create in Excel itself.

Keeping the CSV and creating a separate Excel copy

If you need both the original CSV and an Excel version — for example, because another program relies on the CSV format — do not overwrite the CSV. Instead, open it in Excel, go to File > Save As, choose a new filename, select "Excel Workbook" as the format, and save. You now have two files: the original CSV and a new Excel file. Both contain the same data but in different formats.

This approach is common in workflows where one team member needs the CSV for a database or automated process, while another person needs the Excel file for analysis or reporting. Keeping both versions prevents confusion and lets each person work in the format that suits their task.

Frequently Asked Questions

Will converting a CSV to Excel change my data?

No. The data itself stays the same — only the file format changes. Excel adds formatting features like colors and formulas, but the original values remain unchanged. The only exception is if Excel misinterprets a column (like reading a ZIP code as a number and dropping the leading zero), which you can fix by formatting that column as text before saving.

Can I convert an Excel file back to CSV?

Yes. Open the Excel file, go to File > Save As, choose "CSV (Comma delimited)" from the format dropdown, and click Save. Excel will ask whether you want to keep the file in Excel format or save it as CSV — choose CSV. The file is now a CSV again.

What if my CSV file has special characters or non-English text?

Excel usually handles these correctly, but if characters appear garbled after opening, the CSV may use a different character encoding. Open the CSV in Notepad, go to File > Save As, and check the encoding dropdown at the bottom — it should say UTF-8. If it says something else, change it to UTF-8 and save. Then open the file in Excel again.

Do I need to use Text to Columns every time I open a CSV?

No. Once you save the CSV as an Excel file (.xlsx), it stays in Excel format. Text to Columns is only needed if the data does not import correctly the first time, or if you are working with a CSV that uses an unusual separator.