In the ODS vs XLSX choice for converted statements, XLSX is the safer default to send: Excel, Google Sheets, Numbers and LibreOffice all open it. ODS, LibreOffice's default open format, is fine for your own files. Some Excel features, such as table styles and certain pivot options, do not survive a save to ODS.
What are the ODS and XLSX file formats?
ODS and XLSX are both spreadsheet files made of XML documents packed inside a zip archive. ODS is the OpenDocument Spreadsheet format, an open standard and the default in LibreOffice Calc. XLSX is the Office Open XML workbook, the default save format in Microsoft Excel. Both hold sheets, formulas, number formats and charts.
The difference that matters in daily use is not the internal structure. It is which app wrote the file and which app reads it. Each format is native to one family of software and imported by the others. An import works by mapping features from one model to the other, and features without a match get simplified or dropped.
For bank statement data, the content is modest: dates, text descriptions, amounts, perhaps a running balance column and a few totals. Both formats store that without trouble. The risks appear when the workbook carries more, such as a pivot table of spending, a protected sheet or a styled table.
Who can open an ODS file versus an XLSX file?
An XLSX file opens in almost every spreadsheet app people use, while ODS has narrower support. Excel, Google Sheets and LibreOffice Calc open both. Apple Numbers is the main gap: Apple's guide to importing a file into Numbers on Mac covers Excel and text files, and does not list ODS.
That makes the recipient the deciding factor. An accountant, a lender or a family member is very likely to have Excel or a browser with Google Sheets. Someone on a Mac with only Numbers may not be able to open your ODS file at all. Sending XLSX avoids the question.
Browsers matter too. A file opened in Excel for the web or in Google Sheets is uploaded first and then converted. For CSV files there is a separate set of steps, covered in opening a CSV in Excel Online. Google Sheets also caps how much a single spreadsheet can hold, so a multi-year statement workbook in either format may hit the Google Sheets cell limit before it opens.
Formatting and formula features that ODS drops from an Excel workbook
Saving an Excel workbook as ODS keeps the cell values and ordinary formulas but loses some richer features. Microsoft's page on differences between the ODS format and the Excel XLSX format lists features by support level. Formulas are listed as fully supported.
The items most relevant to statement workbooks, from that Microsoft page:
| Feature | Status when saved as ODS |
|---|---|
| Formulas | Supported |
| Table styles and total rows | Not supported |
| Pivot table styles and calculated fields | Not supported |
| Pivot table layouts | Partly supported; compact layouts are lost |
| Some formula-based data validation | May not be saved |
| Chart data labels | Partly supported |
| Sheets protected with a password | Cannot be saved or opened in ODS |
| Encryption | Not supported |
The password row deserves attention. A statement workbook is sensitive, and if you protect a sheet with a password in Excel, saving it as ODS is not an option. Keep it in XLSX, or protect the file another way.
The reverse trip, an ODS file opened in Excel, carries similar risks for LibreOffice-only features. The safe habit is to keep the working copy in the format of the app you edit in, and export a copy for others.
Picking ODS or XLSX for statement files you share
For statement files you share, pick XLSX unless the recipient asked for ODS. It opens on more devices, keeps Excel's formatting intact, and supports password-protected sheets. ODS is a sound choice for files that stay inside LibreOffice, or for an organisation that requires open formats.
A short decision guide:
- Sending to an accountant, bookkeeper or lender: XLSX.
- Archiving your own statements, edited only in LibreOffice: ODS is fine. Keep a CSV copy as well for portability.
- Working in Google Sheets: neither file is native. Download whichever format the next person needs.
- Recipient uses Numbers only: XLSX.
When an ODS or XLSX file is the wrong choice for statement data
An ODS or XLSX file is the wrong choice when the data is going into another program rather than to a person. Budgeting apps, accounting imports and scripts usually expect CSV, a plain text file with one row per line. CSV carries no formatting, so there is nothing to lose in transit.
CSV is also easier to inspect. You can open it in a text editor and see exactly what each field contains, which helps when a date or an amount looks wrong.
The format will not fix a bad conversion, though. If the statement came out with two columns of transactions interleaved, as happens with a two column PDF page in Excel, the problem travels into every format. Fix the rows first, then choose how to save them. FastBankConvert is being built to produce Excel, CSV or JSON from a statement, so you can pick the format that fits the next step; see the plan on the homepage.