Every sheet in one pass
All worksheets are read and written together, so a workbook with twelve monthly tabs is twelve CSV files from a single click.
Split an Excel workbook by sheet
Turn every worksheet in an XLSX workbook into its own CSV file, packed in one ZIP. The workbook is read on your device and is never uploaded.
Drop your XLSX file here or click to choose a file XLSX file · processed on this device
XLSX
Working locally…
Preparing the browser worker.
✓
Your file is ready
Separate a workbook into files without sending it away
A workbook that has grown one tab per month, per region or per client is awkward to hand on. The person on the other end wants one table, an import tool takes one CSV at a time, or a script reads flat files. This page splits the workbook so each worksheet becomes its own CSV, and packs them in one ZIP.
Choose the workbook and the delimiter. Comma is the usual choice. Use semicolon when the receiving program expects it, which is common where the comma is the decimal mark, and tab when the values themselves contain commas. Each file is written as UTF-8 with CRLF line endings, so accented letters and non-Latin scripts survive.
What each file holds
The first row of a worksheet becomes the header row of its CSV. A blank header cell is written as column_1, column_2 and so on by its position, so no column ends up without a name. Merged cells are filled across the range they cover, dates are written as dates, and a percentage is written as a percentage. A cell that starts with a character a spreadsheet could read as a formula is quoted so it opens as text.
Formulas are not carried across. A CSV has no place to keep one, so each cell holds the last value the workbook stored.
Names and limits
Files are named after their sheets. Characters a filename cannot hold, such as a slash or a colon, become an underscore, and two sheets that would share a name get a number in brackets. A worksheet with more than a million rows is refused with its name in the message, the same limit the single-sheet tool applies.
When to use the single-sheet tool instead
If you only need one worksheet, Excel to CSV lists the sheets with their row counts and gives you one file. This tool is for the case where you want them all. To go the other way and stitch CSV files together, use Merge CSV.
Nothing leaves the device
The workbook is read in your browser and the ZIP is built by a local worker. There is no account, no queue on a server and no copy kept anywhere else. Closing the tab discards the working copy.
Split a workbook in three steps
- 1
Choose an XLSX workbook
- 2
Pick the CSV delimiter
- 3
Download one ZIP holding a CSV for each worksheet
Everything you need
Same reader as Excel to CSV
Merged cells, dates and percentages are read the same way as in the single-sheet tool, so the two give the same text for the same sheet.
Empty sheets named
A sheet with nothing in it is left out and listed on the result screen, so a missing file is never a surprise.
Nothing is uploaded, and you can verify it
Processing runs on this device. Open the browser’s Network panel while the tool works and you will see no file upload request to FileGizmo. Temporary previews use local browser URLs, and closing or resetting the page releases them instead of leaving a server copy behind.
No limits, no watermarks
Use the tool without a daily task counter, account wall, output watermark, or artificial upload cap. FileGizmo does not meter a transfer it never receives. Available memory, processor speed, browser canvas limits, and the file format itself set the practical limit.
Works on any device, and offline after first load
Use a current browser on desktop, Android, iPhone, or iPad without installing an app. Once this tool and its required assets load, the cached workflow works without a connection. Large jobs are usually more comfortable on a desktop with additional memory.
Frequently asked questions
What do I get?
A ZIP with one CSV file for every worksheet that holds data. Each file is named after its sheet, with characters that filenames cannot hold replaced by an underscore.
Why is one of my sheets missing?
A worksheet with no cells is left out, because a CSV of nothing is not a useful file. The result screen names every sheet that was left out.
Are formulas kept?
No. A CSV holds values, so each formula cell is written as the value Excel last stored for it. The formulas themselves stay in the workbook.
Is the workbook uploaded?
No. FileGizmo reads the workbook and writes the ZIP in a worker on your device. Neither the workbook nor the CSV files are sent anywhere.
Can I export just one sheet?
Yes. Use Excel to CSV, which lets you pick a single worksheet and download its CSV alone.