Excel CSV Save Keeps Only One Sheet — Here's Why and the Fix

PublishedToolExcel Sheet Splitter

Contents
  1. Why the sheets seem to disappear
  2. How to keep every sheet as CSV
  3. Where people get stuck
  4. The takeaway
  5. Frequently asked questions

You've probably saved a multi-sheet Excel file as CSV and watched a few sheets vanish completely. The file isn't corrupted, and you didn't delete anything by accident. CSV as a format simply has no concept of a "sheet" in the first place.

Summary ① CSV is a plain text format that holds a single table, so the idea of multiple sheets doesn't exist in it. ② When you save an Excel file with multiple sheets as CSV, only the sheet currently open on screen (the active sheet) is saved; the other sheets aren't in the resulting file. ③ The original Excel file itself is untouched, so you can either switch the active sheet and save again for each sheet, or use a tool to do it all at once.

Why the sheets seem to disappear

CSV is pure text: rows of values separated by commas. There's no tab (sheet) concept in the file structure at all, so there's no way to divide multiple sheets across a single CSV file.

That's why when you save a multi-sheet Excel file with "Save As → CSV," Excel exports only the sheet currently on screen (the active sheet) and leaves the rest out of the result. Excel does show a warning that "The selected file format does not support workbooks that contain multiple sheets," but it's easy to miss if you just click OK and move on.

For example, if a file has three sheets — "Q1 Sales," "Q2 Sales," and "Q3 Sales" — and "Q1 Sales" is open on screen, the saved CSV contains only the contents of Q1 Sales. Q2 Sales and Q3 Sales are still visible in the Excel tabs, but they don't exist inside the CSV file you just created.

The important thing here is that the original Excel file isn't damaged at all. Only the newly created CSV file looks like it's missing something. Open the original xlsx file and every sheet is still there.

How to keep every sheet as CSV

You can do this without any tool. Click each sheet tab to make it the active sheet, then run "Save As → CSV UTF-8" each time and give each file a different name. If you don't rename it, you'll overwrite the CSV you made before.

With two or three sheets, this isn't much of a hassle. The problem starts when you have many sheets. You have to repeat switching the active sheet, saving, and checking the file name as many times as there are sheets, and if you skip even one, that sheet quietly never makes it to CSV.

Check it with our tool. When multiple sheets make that repetition a chore, upload a single file and our tool creates one CSV (or individual Excel) file per sheet all at once.

Excel Sheet Splitter

Free · No sign-up · Runs in your browser only (nothing uploaded to a server)

Where people get stuck

SituationWhat actually happens
Saving a multi-sheet file as CSV (Save As)Only the active sheet is saved; the other sheets aren't included in the resulting file
It feels like the sheets are goneThe original xlsx file is intact. What's missing is only in the CSV file you just created
Several sheets have the same nameNumbers (_2, _3) are added to the end of the download file names to tell them apart
Korean text in the split CSV filesA UTF-8 BOM is added automatically, so Korean text doesn't break when you open the file in Excel

The takeaway

Here's the core of it. CSV is a plain text format with no concept of sheets, so saving a multi-sheet file as-is leaves you with only the active sheet. Your original file is unchanged, so no data is actually gone — but to keep the other sheets as CSV, you have to repeat the save process for each sheet.

With one or two sheets, doing it by hand is fine. As the sheet count grows, the repetition gets tedious and it's easy to miss one, so from that point on, handling it all at once is safer.

Excel Sheet Splitter

Free · No sign-up · Runs in your browser only (nothing uploaded to a server)

Frequently asked questions

How do I know which sheet will be saved when I save as CSV?

The sheet that's selected on screen at the moment you save — the tab at the bottom of Excel that's shaded or pressed — is the active sheet. Click the sheet you want before saving to make it the active sheet.

Does saving sheets as CSV change the original Excel file too?

No. Creating a CSV with "Save As" makes one more new file. It has no effect on the sheet structure or contents of the original xlsx file.

If I split into Excel (.xlsx) format, are the sheet names kept exactly?

Mostly, yes. But if a name contains a backslash, slash, question mark, asterisk, square brackets, or colon, or exceeds 31 characters, it's cleaned up automatically to match Excel's sheet naming rules. CSV has no concept of sheets, so those rules don't apply — only characters the file system can't use are cleaned up in the download file names.

Is my file sent to a server?

No. Uploaded files are read and split only inside your browser and are never sent to a server.

This article was adapted from our Korean original. Read the Korean original

Related articles

  1. Excel to JSON Date Shows as a Number: Serial Date FormulaExcel dates turn into numbers like 46037 when you convert to JSON. Here's what the serial number is, the formula that gives you the real date, and how to prevent it.
  2. Merge Excel and CSV Files: Why Columns Shift and How to Avoid ItMerging Excel and CSV files can push values into the wrong columns. Here's why it happens, what to check before you merge, and how sheet names get renamed.
  3. Excel Table to Markdown: Fix Broken Pasted TablesCopied a table from Excel or Google Sheets and it pasted as plain lines? See how Markdown tables work and how to convert yours in seconds.
  4. Gantt Chart vs Calendar: Duration as Bars, Not DotsLearn how a Gantt chart shows duration as bar length, how overlaps and progress fit on one timeline, and how to draw the bars by hand.
  5. HTML Table to Markdown: Why the First Column DisappearsWhen you convert an HTML table to Markdown, the first cell can vanish or shift. Here's the th/td cause and how to check the source before you paste.
  6. Why HTML to Markdown Conversion Drops Tables and ColorsMerged table cells, text color, and inline styles have no Markdown syntax. Here's why conversion drops them, and what to check after you convert.

Related tools