The simplest way to export all tabs at once

When you export an Excel workbook with multiple tabs, you're saving the entire file — all sheets together — in a format your computer or another program can read. The easiest method is to use File > Save As and choose your format. Excel keeps all tabs in the same file by default, so you don't need to export them separately unless you have a specific reason to do so.

If you're using Excel on Windows or Mac, open your workbook, go to File in the top left, then click Save As. Choose where you want to save the file, give it a name, and select a format from the dropdown menu labeled Save as type (Windows) or File Format (Mac). Click Save, and your entire workbook with all tabs exports as a single file.

Key Takeaways

  • Excel workbooks automatically keep all tabs together when you save or export, so you usually don't need to do anything special to preserve multiple sheets.
  • Use File > Save As to choose a different format like PDF, CSV, or an older Excel version, and all tabs will be included in the export.
  • If you need only one tab as a separate file, right-click the sheet tab at the bottom and select Move or Copy, then choose Create a copy in a new workbook.
  • PDF export preserves formatting and all sheets but creates a read-only file; CSV export flattens your workbook to a single sheet of text data.
  • When exporting to older Excel formats like .xls, check that your formulas and formatting are compatible, since older versions don't support all modern features.

Exporting to PDF with all sheets included

PDF is the most common export format when you want to share a workbook that people shouldn't edit. When you export to PDF, Excel includes all your tabs as separate pages in a single PDF file, preserving colors, fonts, and layout exactly as they appear on screen.

Go to File > Save As, then select PDF from the format dropdown. Before you click Save, look for an Options button (Windows) or check the PDF dropdown at the bottom of the dialog (Mac). Make sure Entire Workbook or All Sheets is selected — if you see Active Sheet selected instead, change it. Then save the file. Each sheet becomes a separate page in the PDF, in the same order they appear in your workbook.

Exporting individual tabs as separate files

Sometimes you need one tab as its own file instead of keeping everything together. The fastest way is to create a copy of that sheet in a new workbook, then save it separately.

Right-click the sheet tab at the bottom of your screen (the one labeled with the sheet name). Click Move or Copy. In the dialog that opens, select Create a copy, then choose (new book) from the list. Click OK. Excel opens a new workbook with just that one sheet. Now go to File > Save As and save it with whatever name and format you need. The original workbook stays unchanged with all its tabs intact.

If you have many sheets and need to export several of them separately, repeat this process for each one. It takes longer than exporting the whole workbook at once, but it's the clearest way to ensure each file contains exactly what you want.

Choosing between Excel formats when exporting

Excel offers several file formats, and the one you choose affects what features survive the export. The modern standard is .xlsx (Excel Workbook), which supports all current Excel features including formulas, charts, and conditional formatting. If someone asks you to send an Excel file and doesn't specify a format, .xlsx is the safest choice.

Older versions of Excel use .xls format. If you're sending a file to someone using Excel 2003 or earlier, or if they specifically request .xls, use File > Save As and select Excel 97-2003 Workbook. Be aware that some features won't translate — newer formulas, sparklines, and certain formatting may be lost or converted to simpler versions.

.csv (Comma-Separated Values) is a text format that flattens your workbook into a single sheet of plain data. When you export to CSV, Excel saves only the active sheet, not all tabs. Use CSV only when you need to import data into another program that doesn't read Excel files, and understand that you'll lose all formatting, formulas, and multiple sheets in the process.

Exporting to CSV when you have multiple tabs

CSV export works differently from other formats because it can only save one sheet at a time. If you try to export a multi-tab workbook to CSV, Excel will ask you which sheet you want to save, or it will save only the active sheet by default.

If you need all your data as CSV files, you'll need to export each sheet separately. Click on the first sheet tab, go to File > Save As, select CSV (Comma delimited), and save it with a name like "Sheet1.csv". Then repeat for each remaining sheet, clicking its tab first and giving it a unique filename. This creates separate CSV files for each sheet, which you can then import into databases, data analysis tools, or other programs.

Exporting through OneDrive or cloud storage

If your workbook is stored in OneDrive or SharePoint, you can export it directly from the web version of Excel without downloading it first. Open the file in Excel Online, click File, then look for Download or Download a Copy. Choose your format and the file downloads to your computer with all tabs included.

This method is useful if you're working on a shared file and want to create a personal copy to export, or if you're on a computer where Excel isn't installed. The export process is the same as the desktop version — all sheets come along unless you specifically choose to export only the active sheet.

Troubleshooting common export problems

If your exported file is missing sheets, check that you didn't accidentally select Active Sheet Only or a similar option in the export dialog. Go back to File > Save As, look for any options or buttons related to sheet selection, and make sure Entire Workbook or All Sheets is chosen.

If formatting looks wrong after export — colors are missing, columns are too narrow, or text is cut off — the issue usually depends on your format choice. PDF preserves formatting most reliably. Excel formats (.xlsx and .xls) preserve formatting unless you're using very new features in an old version. CSV strips all formatting by design, so if you need to keep it, use Excel format instead.

If you're exporting to an older Excel format and formulas show as errors or display as text instead of calculating, the formula may use a function that didn't exist in that version. Check your formulas before exporting, or stick with .xlsx if your recipient's software supports it.

Frequently Asked Questions

Do all sheets export automatically when I save my workbook?

Yes. When you save an Excel file in any Excel format (.xlsx, .xls, or others), all sheets are saved together in that single file. You don't need to do anything special — the tabs stay together by default.

Can I export just one sheet as a PDF without the others?

Yes. Before you export to PDF, click the sheet tab you want to export. Then go to File > Save As > PDF, and in the options dialog, select Active Sheet instead of Entire Workbook. Only that sheet will become a PDF page.

What happens to my formulas when I export to CSV?

CSV saves only the values that formulas calculate, not the formulas themselves. If you export a sheet with formulas to CSV, the resulting file will contain the numbers or text the formulas produced, but the formulas are gone. Use Excel format if you need to keep formulas.

Why does my exported PDF have blank pages?

This usually happens when a sheet is very wide or tall and Excel is trying to fit it onto standard paper size. Check the sheet's print settings: go to Page Layout (or Layout on Mac), look for Print Area or Page Setup, and adjust the scaling or margins. Then export to PDF again.

Can I export an Excel file from my phone or tablet?

Yes, if you're using Excel on iPhone, iPad, or Android. Open the file, tap the menu icon (three dots or lines), select Share or Export, and choose your format. The process is similar to desktop Excel, though the exact steps vary slightly by device and app version.