ODS to XLSX — the ledger: what crosses, what is dropped, what is changed
A client asks for Excel and the file you have is OpenDocument. Only cells travel between the two families, and the honest way to describe the trip is a ledger: some things cross unchanged, some are dropped, and some arrive altered. A page that promised fidelity would be selling you a workbook that looks wrong when opened.
Cell formatting, colours, column widths and merged ranges are dropped; only stored values survive.
Processed on your device. Files aren’t sent anywhere.
The ledger: crosses, dropped, changed
Three outcomes, kept separate because they need different follow-up work.
Think of the output as a values handoff. The receiving person can inspect the rows in Excel, but that does not establish that the original workbook model has been reproduced. Keep the editable OpenDocument source if calculations or presentation still need maintenance. Compare representative labels, totals and dates against that source before using the rebuilt workbook as someone else's starting point.
| In the ODS file | Outcome | In the workbook |
|---|---|---|
| Cell value | changed | the displayed text |
| Date cell | changed | the displayed date text |
| Formula | changed | the cached value, formula text gone |
| Cell styles | dropped | default presentation |
| Conditional formatting | dropped | no rule survives |
| Macros | dropped | nothing is executed or carried |
| Column widths | dropped | default widths |
| Sheet names | crosses | cleaned and shortened to what the format allows |
Conditional formatting and formulas
Conditional formatting is the item people notice: a budget sheet that turned a cell red when the total went over the limit arrives as plain numbers with no warning. Formulas are the item people do not notice: the cached value is copied, so a stale cache exports as a stale value and nothing is recalculated.
Dates and number formats
A date cell leaves as the text the document displayed. Number formats — thousands separators, currency symbols, fixed decimals — are display instructions and have no counterpart in the output, so a formatted 1,250.00 arrives as characters.
- Dates: displayed text, not a recalculated calendar value.
- Numbers: characters, not numeric cells.
- Currency symbols: part of the text, so totals need cleanup before summing.
- Merged ranges: not reconstructed.
Sheet names that survive the trip
Sheet mode decides how many sheets the workbook has: First sheet writes one, All sheets writes every sheet in document order. Names are kept where allowed; characters a spreadsheet cannot use in a sheet name are replaced, and names longer than the format limit are shortened.
Checking before you send it
Compare the two files before the client opens the new one.
- Convert the .ods file and download the workbook.
- Open both files side by side.
- Compare values, not appearance.
- Check the sheet count against your sheet-mode choice.
- Re-add any conditional formatting the client relied on.