No. A CSV file holds one flat table, so it cannot preserve multiple Excel worksheets in a single file. To export a workbook with several sheets, save each worksheet as a separate CSV, or combine the data into one worksheet before exporting; use an Excel workbook file if you need multiple tabs in one file.
Why a CSV Cannot Contain Multiple Sheets
CSV stands for comma-separated values. It is a plain-text format for rows and columns of data, not a workbook format. A typical CSV file has one sequence of records, with each line representing a row and separators dividing values into columns. It has no built-in structure for naming worksheets, storing tabs, or keeping separate tables as sheets.
An Excel workbook, by contrast, can contain multiple worksheets along with formatting, formulas, charts, and other workbook features. When you save an Excel workbook as CSV, Excel converts the active worksheet to a text file. It does not combine all of the workbook’s sheets automatically, and the CSV cannot retain the workbook’s tabs.
This is a format limitation, not a missing Excel setting. Changing the file extension from .xlsx to .csv will not create a multi-sheet CSV. It can instead produce a file that is mislabeled or difficult to open correctly.
Export One Worksheet as a CSV in Excel
In Excel for Microsoft 365 on Windows, export the sheet you want by making it active and saving a copy in CSV format. For a Unicode-friendly option, choose CSV UTF-8 (Comma delimited) (*.csv) when it is available.
- Open the workbook and click the tab of the worksheet you want to export. Check that it is the active sheet; merely selecting a different cell does not change which sheet is active.
- Choose File > Save As > Browse.
- Choose a folder and enter a new filename so you do not overwrite the original workbook.
- In the file type list, select CSV UTF-8 (Comma delimited) (*.csv), or another CSV option if that is the required format.
- Click Save. If Excel warns that the selected format does not support multiple sheets or workbook features, confirm that you want to continue with the CSV copy.
- Repeat these steps for each other worksheet, using a different filename for each export.
For example, a workbook with sheets named January, February, and March could produce January.csv, February.csv, and March.csv. Keep the original .xlsx file if you need to retain all three tabs, formulas, or formatting. Excel for Mac also offers CSV formats through its Save As process, though the labels and available choices can vary by release. Excel for the web has different download options; if you need predictable per-sheet exports, download the workbook and use the desktop app.
Export Several Sheets as Separate CSV Files
Excel’s regular Save As workflow exports the active sheet, so there is no standard Save As choice that writes every worksheet to its own CSV in one operation. For a small workbook, repeat the export process for each tab. Before starting, decide on a consistent naming pattern and make a destination folder so the files stay together.
For a large workbook or a recurring task, automation can reduce repetitive steps. A VBA macro or a script can loop through worksheets and save each one as a separate CSV. That automation still creates multiple files; it does not make a single CSV with tabs. If you use a macro, test it on a copy first, check that filenames will not overwrite existing files, and confirm the output encoding and delimiter meet the recipient’s requirements. Macros can make changes that Ctrl+Z cannot undo.
Another practical option is to save a separate copy of the workbook for each sheet, remove the other sheets from each copy, and then save each copy as CSV. This is slower than a macro, but it gives you a visible opportunity to check the sheet and filename before export. Do not delete sheets from your only copy of the original workbook.
How to Put Multiple Sheets into One CSV
If the goal is one CSV file containing the data from several worksheets, first combine the data into a single worksheet. This works best when the sheets have the same column structure. For example, if each monthly sheet has the columns Date, Product, and Units, copy the rows from each month beneath the same header row in a new sheet, then export that combined sheet.
Keep one header row at the top rather than repeating the headers between every batch of records. If readers need to know where a record came from, add a column such as SourceSheet and fill it with the original sheet name before combining the rows. That preserves useful context in a format that has no worksheet tabs.
If the sheets have different columns or represent different kinds of information, forcing them into one table may make the data confusing or misleading. You may need to create a consistent column layout, leave appropriate blank fields, or keep separate CSV files instead. For larger or recurring consolidations, Excel’s data tools or a purpose-built script may help, but review the resulting table before exporting. CSV will store only the one consolidated table you created.
What CSV Export Keeps—and What It Loses
A CSV is designed to transfer tabular data, not to reproduce an Excel workbook. It does not preserve worksheet names, multiple tabs, cell colors, fonts, borders, column widths, charts, images, or most other workbook features. It also does not store Excel formulas as working formulas in the way an .xlsx workbook does. A formula cell is generally exported as its calculated result, so make sure the workbook has up-to-date calculation results before creating a file for someone else.
Formatting can affect how values appear in the exported text. Dates, decimal values, and large numbers deserve particular attention because Excel’s display settings and regional conventions can influence the representation. A CSV also cannot reliably preserve the intended data type for every recipient’s software. For example, a value that looks like an account code may be interpreted as a number when opened, and leading zeros may disappear if the value was stored as a number in the first place.
After exporting, open the CSV in a text editor or import it into a fresh worksheet to check the actual contents. This is especially useful when the file will be uploaded to another system. Keep the original workbook as the editable source and treat the CSV as a data-only delivery copy.
Commas, Regional Settings, and UTF-8
Despite the name, CSV files do not always use a comma in every country or software setup. Regional settings can affect which character Excel uses as the list separator when saving a delimited text file. Some systems use semicolons, for example. The filename may still end in .csv even when the separator is not a comma, which can surprise a recipient who expects comma-separated columns.
CSV data can also contain commas, quotation marks, or line breaks inside a cell. Exporting software handles these with text delimiters and escaping rules, but a simple import process may interpret them differently if the delimiter or text qualifier is guessed incorrectly. When the recipient reports that everything appears in one column, or that some rows are split unexpectedly, check the delimiter and import settings before assuming the data itself is missing.
CSV UTF-8 is usually a sensible choice when a file contains accented characters or text from multiple writing systems. UTF-8 is a text encoding; it does not add sheet support or preserve formatting. If compatibility with a particular database or older application matters, ask the recipient which encoding and delimiter it expects. In Excel for Microsoft 365 on Windows, Data > From Text/CSV lets you import a text file and review its delimiter and preview rather than relying only on double-clicking the file.
CSV or XLSX: Which Format Should You Choose?
Choose CSV when the recipient needs a simple table for importing into another program, processing as text, or exchanging data in a broadly supported format. It is also useful when you want a lightweight, data-only export. Because it contains one table, it can be easier to process automatically than a workbook with many tabs, provided the receiving system agrees on the column layout, delimiter, and encoding.
Choose .xlsx when the recipient needs multiple worksheets, formulas, formatting, charts, or an editable Excel file. An Excel workbook is the right choice for preserving a multi-sheet project. If the receiving system requests one CSV per worksheet, provide a set of clearly named CSV files, and include the .xlsx workbook too when the recipient needs the complete, editable version.
Do not use a CSV as a substitute for a workbook archive. A CSV may be appropriate for transferring rows and columns, but it is not a complete backup of the spreadsheet. Keep a copy of the original workbook whenever you may need to revise formulas, inspect other sheets, or reproduce the export later.
Common Export Problems and Checks
- The wrong sheet was exported: Return to the workbook, click the intended sheet tab, and export again. Excel saves the active worksheet, not necessarily the sheet you last edited.
- Only one sheet appears in the file: That is expected for CSV. Export each worksheet separately or combine the data into one sheet first.
- Excel displays a format warning: The warning reflects features CSV cannot retain. Continue only if you are creating a data-only copy, and keep the workbook version if its other features matter.
- Values appear in one column: Check whether the file uses commas, semicolons, or another delimiter. Import it with the correct delimiter rather than assuming the extension identifies it.
- Leading zeros or dates change: CSV does not reliably carry Excel’s cell type rules to the next program. Inspect how critical identifiers and dates are stored, and ask the recipient how the file will be imported.
- Characters look garbled: Try exporting as CSV UTF-8 and confirm that the receiving application reads the file as UTF-8.
Frequently Asked Questions
Can I save all Excel sheets into one CSV file?
No. CSV has no worksheet structure. Combine the data into one worksheet and export that sheet, or export each worksheet as its own CSV file.
Does Excel export only the active sheet to CSV?
Yes. In the usual desktop Save As workflow, Excel writes the active worksheet to the CSV. Check the selected sheet tab before saving.
How do I export every sheet as a separate CSV?
Save each worksheet separately by activating its tab and using File > Save As to choose a CSV format. For many sheets, a carefully checked macro or script can automate the same separate-file process.
Will a CSV keep my formulas and formatting?
No. CSV is plain text for a single table. It does not keep workbook formatting, charts, or multiple sheets, and formula cells are generally represented by their calculated results rather than functioning Excel formulas.
Should I use CSV or XLSX for multiple worksheets?
Use XLSX when the tabs and workbook features need to remain intact. Use CSV when a recipient needs a single plain-text table; use multiple CSV files if they request one file per sheet.
Related
- State Heat Map in Excel: Create, Format, and Troubleshoot
- Stop Flash Fill in Excel: Turn Off Automatic Filling
- Supply Chain Management Excel Solver: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Power Query Union Tables: How to Append QueriesTo union tables in Power Query, use Append Queries: it stacks the rows from one query beneath the…
- How to Delete a Page in Word Online Without Losing TextTo delete a page in Word Online, select the text or formatting mark creating it, then press Backspace…
- Analysis Tab in Excel: Where It Is and What It DoesExcel does not have one permanent ribbon tab simply called “Analysis.” If you mean the PivotTable Analyze tab,…
- Google Sheets Microsoft Version: What Is the Equivalent?The Microsoft equivalent of Google Sheets is Microsoft Excel. Excel is Microsoft’s spreadsheet app for creating, calculating, organizing,…
- Lock a Column in Google Sheets: Freeze or Protect ItTo keep a column visible while you scroll in Google Sheets, freeze it with View > Freeze. To…
- Hide Columns in Excel Temporarily: Steps to Show Them AgainTo temporarily hide columns in Excel for Microsoft 365 on Windows, select the column headers, then choose Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.