File Format & Compatibility

Why Excel for Mac Loses Worksheets When Saving as CSV & How to Fix It

Steven Parker Oct 23, 2026 868 views

Question details

The user needs to understand why a multi-sheet workbook loses all additional tabs, formulas, and formatting when saved as a CSV file on Mac.

Why Excel for Mac Loses Worksheets When Saving as CSV

Product: Excel for Mac
Device & OS: Mac
Scenario: Saving a multi-sheet spreadsheet workbook to a new file format for export or sharing.
Observed behavior: Only the currently active worksheet is saved into the CSV file, while all other worksheets, charts, formatting, and formulas are permanently discarded without being included in the final file.

Before you start

Before attempting to change your file format, ensure you have a saved copy of your original workbook as a standard Excel file (.xlsx) so you do not accidentally overwrite and lose any existing data, formatting, or formulas.

Solution 1Recommended

Save the Workbook as an XLSX or XLSB File

The best way to keep all worksheets, formulas, and formatting intact is to save your file in a native Excel format rather than a plain text format.

CSV (Comma Separated Values) is a plain text format designed to hold simple tabular data. Because of this inherent limitation, a CSV file can only store one worksheet at a time and completely strips away all formatting, charts, and formulas.

To preserve the full functionality and structure of your workbook, you must use a format designed for spreadsheets.

Open the Save As dialog

Click on 'File' in the top Apple menu bar and select 'Save As' from the dropdown menu.

Select a compatible format

Click the 'File Format' dropdown menu and choose 'Excel Workbook (.xlsx)' or 'Excel Binary Workbook (.xlsb)'.

Save the file

Enter your desired file name, choose a destination folder on your Mac, and click 'Save'.

Save the Workbook as an XLSX or XLSB File

Warning Prompt: If Excel warns you that 'Some features in your workbook might be lost if you save it as CSV', always click 'Cancel' or 'No' and select an Excel format instead to protect your data.

Solution 2

Export Worksheets as Individual CSV Files

If you strictly need the CSV format for importing data into another system, you must save each worksheet as its own separate file.

Manage Multi-sheet Spreadsheets Easily

Keep Your Worksheets Intact with WPS Spreadsheet

WPS Office provides a highly compatible and user-friendly spreadsheet tool for Mac. You can effortlessly manage multiple sheets and save your workbooks in standard formats like XLSX to ensure no data, formatting, or charts are ever lost.

1. Open your file in WPS Office: Launch WPS Office on your Mac and open your existing spreadsheet containing multiple worksheets.
2. Access the Save menu: Click on 'File' in the top menu and select 'Save As' to open the format options.
3. Choose an Excel-compatible format: From the File Type dropdown, select 'Microsoft Excel Workbook (*.xlsx)' to ensure full feature retention.
4. Save your work: Click 'Save' to securely store your document with all tabs, formulas, and formatting perfectly preserved.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Preserves all worksheets, complex formulas, and charts seamlessly when saved correctly.Free and lightweight alternative to heavy traditional spreadsheet software.Familiar tabbed interface makes managing multiple sheets highly intuitive.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my file only show one sheet after saving as CSV?

CSV files are plain text files designed to store simple tabular data separated by commas. This structural limitation means they do not support multiple tabs. When you save to CSV, Excel only exports the currently active worksheet.

How can I convert a multi-sheet Excel file to CSV format?

Because a single CSV file cannot contain multiple sheets, you must export them individually. Select your first sheet, go to File > Save As, choose CSV, and then repeat this exact process for every other sheet in your workbook.

Will I lose my formulas if I save an Excel file as a CSV?

Yes. Since CSV is strictly a plain text format, any formulas you have created will be converted to their final calculated text values. The underlying mathematical equations will be permanently lost once the file is closed.

Is there a text format that supports multiple worksheets?

No standard plain text format (such as CSV or TXT) supports multiple worksheets or complex formatting. To keep multiple sheets in a single file, you must use a dedicated spreadsheet format like XLSX, XLSB, or ODS.

Document & File Issues