Short answer
Open a copied workbook. Choose the sheets you need. Export them as separate CSV files or place those files in one ZIP, then check the result.
When to use this method
Use this method when another system needs one CSV per worksheet, with an optional ZIP to keep those files together.
Spreadsheet export behaviorHow worksheets, CSV options and saved formula results are handled.
- How it works
- Each selected worksheet becomes its own CSV using the chosen delimiter and encoding. A ZIP packages those files but does not combine their rows.
- Important limit
- The app exports the last formula result saved inside the workbook. This stored result is called a cached value. If no stored result exists, the field is empty and the app shows a warning.
What you need before exporting workbook sheets
XLSX is a workbook that can contain several worksheets, formulas and formatting. CSV is plain row-and-column text and holds one table per file. Exporting every worksheet therefore creates several CSV files, which can be placed in one ZIP for easier transfer. Charts, cell styling, formulas and workbook behavior do not become CSV features.
Export workbook sheets deliberately
Inspect sheet names
Identify the worksheets the receiving system actually needs.
You should see: every worksheet name from the workbook.
Choose sheets and packaging
Export selected or all sheets as separate CSV files, or collect them in one ZIP.
You should see: one planned CSV for every selected worksheet.
Set delimiter and encoding
A delimiter is the character that separates columns, such as a comma or semicolon. Encoding tells the receiving app how to read letters and symbols. Choose settings that the app importing the CSV supports.
You should see: the chosen delimiter and text encoding in the export settings.
Verify data types
Create the files and open one in the receiving application.
You should see: the expected rows, dates, numbers and non-English text.
If columns, symbols or formula results look wrong
Open the CSV with the delimiter and character encoding chosen during export. Compare a few dates, decimals, leading zeros and non-English characters with the workbook. The app does not calculate formulas: it exports the last result saved in the workbook when one exists and leaves the field empty with a warning when it does not.
CSV export mistakes
- Treating a ZIP of separate CSV files as one merged table
- Choosing a delimiter the receiver interprets incorrectly
- Skipping date, number and encoding checks
Workbook checkpoint
- The expected sheets were exported.
- In a plain-text editor, each CSV has the intended delimiter, encoding and header row.
- In the receiving tool, row counts, dates, decimal values, leading zeros and non-English text match the workbook.
- Formula results are the workbook's last saved values because export does not recalculate them; review any warning about a missing saved result.
Just Converter
Export selected or all workbook sheets as separate CSV files or one ZIP without uploading the workbook.