Microsoft Excel · Sharing, output and safety · Beginner
File Formats & Compatibility in Microsoft Excel
Export CSV or another workbook format and verify losses in Excel with a complete practice example, expected results and recovery checks.
Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards
Quick answer: Keep an XLSX master for an ordinary editable workbook and save a separate exchange copy. A CSV preserves a single sheet’s flat data, not formulas, multiple worksheets or formatting; successfully opening it does not prove the workbook survived conversion.
Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.
Build a conversion test
Use a new Excel workbook with a sheet named Orders. Enter the following at A1:C3:
| Item | Quantity | Total |
|---|---|---|
| Notebook | 2 | =B2*4.5 |
| Pen | 3 | =B3*1.25 |
The expected formula results are 9 and 3.75. Format C2:C3 as currency and make A1:C1 bold. Add a second sheet named Readme with “Keep the XLSX master” in A1. Save the workbook as format-master.xlsx in a location you control. This is a deliberately small test of formulas, formatting and multiple sheets, not a claim that all possible workbook features convert reliably.
Save an exchange copy
- Return to the Orders worksheet so it is active.
- Choose File → Save As. Choose a separate filename,
orders-exchange.csv, not the master filename. - In Save as type, select the CSV format required by the recipient. Review any warning about unsupported features or the active sheet before confirming.
- Keep the XLSX master. Do not treat the CSV as its backup.
- Reopen the CSV separately and inspect its content. Check the actual delimiter and encoding required by the receiving system instead of assuming every CSV consumer interprets the file identically.
Only the active sheet is saved to CSV. The exchange data should contain the Item, Quantity and Total fields and the two records, with results representing 9 and 3.75. Currency symbols and decimal punctuation can be locale-dependent; agree what the receiving system accepts. The formulas are not retained as working formulas, the bold header is not retained, and Readme is not a second CSV sheet.
Prove the difference by changing one input
In the reopened XLSX master, change Notebook’s quantity from 2 to 4. Its formula result becomes 18. In the separately reopened CSV, changing Quantity from 2 to 4 does not recreate the original multiplication formula: its saved Total is a value, so it stays at the exported result unless you explicitly change it. This is the decisive distinction between a workbook and a snapshot of data.
Save the altered XLSX master with Notebook quantity 4, close it and reopen it. Verify both worksheets, formulas and formats, with Notebook Total still 18. If you accidentally replaced the only editable original, the CSV cannot reconstruct its lost formulas or second sheet. Recover from your saved master or an available backup instead of inventing the missing workbook logic.
Choose other formats deliberately
XLSX cannot store VBA macro code. For a workbook that legitimately contains VBA, use a macro-enabled format such as XLSM; changing the filename extension alone does not convert the file. XLS is the older workbook format and has compatibility constraints. ODS is a spreadsheet interchange format but still requires feature checks. PDF is fixed-layout output for reading, not a substitute for an editable calculation model.
For a complex exchange, list what must survive before conversion: validation, charts, conditional formatting, named ranges, links and comments as well as values. Test the receiving application before retiring the source. If your specific problem is interpreting imported dates, use the existing Excel 2013 date-import tutorial and note its older Windows interface scope rather than borrowing those menu labels for this walkthrough.
Official references
Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.