How to Save Only One Excel Sheet as CSV

How to save only one Excel sheet as CSV

To save only one Excel sheet as CSV, click that sheet's tab, then go to File > Save As and choose CSV (Comma delimited). Excel always saves just the active sheet to a CSV, so the other tabs are left out without any extra steps.

That is the whole method. What catches people out is what happens next: the window you are working in has quietly become the CSV file. Read the last section before you carry on editing.

TL;DR: Key takeaways

• Click the sheet's tab first. Excel saves only the active sheet to CSV.
• Two warnings appear. Click OK, then Yes.
• After saving, the open window is the CSV. Go back to your original file to keep working.
• CSV keeps values only. Formatting and formulas are not saved.
• For every sheet as its own CSV, use a macro instead of repeating this.

Save the sheet

1. Click the tab of the sheet you want.
2. Go to File > Save As and pick a folder.
3. Set Save as type to CSV (Comma delimited).
4. Click Save.

Two prompts follow, and both are expected. Microsoft describes them: the first reminds you "that only the current worksheet will be saved to the new file," so click OK if the active sheet is the one you want. The second warns that the sheet may contain features a text format cannot hold. Click Yes to save the data.

That first prompt is the answer to a common question. A workbook with several sheets cannot be stored as one CSV, because the format has no concept of tabs.

What the CSV keeps and loses

A CSV is plain text: one row per line, values separated by commas. Microsoft's format reference is blunt that "if you save a workbook in any text format, all formatting is lost."

In practice that means the file keeps the values you can see, and drops colours, fonts, column widths, formulas (only their results are saved), and every other sheet. That is usually exactly what the system receiving the file wants.

If your data includes accented letters or non-Latin characters, newer versions of Excel also offer CSV UTF-8 (Comma delimited) in the Save as type list. Choose it so those characters survive the trip.

Save part of a sheet instead

If you only need some columns or rows, copy them into a new workbook first:

1. Select the range and press Ctrl + C.
2. Press Ctrl + N for a new workbook and paste.
3. Save that workbook as CSV.

The original sheet is untouched, and the CSV holds only what you copied.

The step everyone misses: you are now in the CSV

Save As switches the open window to the file you just created. You started in Report.xlsx and you are now looking at Report.csv, even though the other tabs may still be visible.

Carry on editing and pressing Ctrl + S, and those edits go into the CSV, where formatting and other sheets cannot be kept. Your original .xlsx is safe and unchanged, but it does not have the edits.

The habit that avoids this: save the CSV, close that window, and reopen your original workbook to continue.

Every sheet, not just one

Repeating Save As for each tab gets tedious beyond two or three sheets. Our free Export Each Sheet to CSV macro writes every sheet to its own CSV file in one run, and exporting each sheet to a separate CSV walks through it. If the recipients need full Excel files rather than CSVs, see saving each sheet as a separate file.

Frequently asked questions

Can I save just one sheet of an Excel workbook as a CSV?

Yes, and it is the default. Click the sheet's tab and use File > Save As with CSV as the file type. Excel saves only the active sheet and confirms this in a dialog box before writing the file.

What happens when you save a workbook with multiple sheets as CSV?

Only the active sheet is saved. Excel shows a prompt saying just the current worksheet will go into the file. The other sheets are not included, because the CSV format has no way to store more than one sheet.

Why did my other sheets disappear after saving as CSV?

They did not disappear from your original file. Save As switched the open window to the new CSV, which can only hold one sheet. Close it and reopen your original workbook, where every sheet is still intact.

Why does my CSV use semicolons instead of commas?

The separator follows your regional settings. In regions where the comma is the decimal separator, Excel uses a semicolon between values. Microsoft documents how to change it, either for Excel alone or across Windows.

Does saving as CSV keep formulas?

No. A CSV stores the result each formula displays, not the formula itself. If you need the formulas, keep the original .xlsx, and use the CSV only to hand data to another system.

What to do next

For a single sheet, click its tab and Save As CSV, then go back to your original workbook. When the job involves many tabs, run Export Each Sheet to CSV once instead of repeating the steps. Importing a CSV back into Excel has its own pitfalls, covered in the complete guide to CSV imports.