files and formats

Excel workbooks

Open the sheets of an Excel or OpenDocument workbook as CSV, and save any tab, or all of them, as a new Excel workbook.

Opening a workbook

Open an .xlsx, .xlsm, .xls or .ods file like any other (Ctrl+O⌘O, or drop it on the window). A workbook with one sheet opens straight away; with several, Trusty CSV asks which one, or All sheets, one tab each. The tab is named after the workbook and the sheet: Q2 report.xlsx · Sales.

The list Q2 report.xlsx has 4 sheets, Select a sheet to open: Sales, Returns, Customers, Notes, and All sheets, one tab per sheet

Each sheet becomes CSV text, one row per line. Dates come in written as 2026-03-01, the international way, and numbers with all their digits. Formulas come in as their results, and formatting (colours, fonts, merged cells) stays behind, because a CSV file can’t hold it.

Saving

Because formulas and formatting can’t come back from CSV, the original workbook is never overwritten. Ctrl+S⌘S on a tab that came from a workbook does a Save As, and the dialog says so; the suggested name is the workbook’s and the sheet’s, Q2 report - Sales.

Exporting to Excel

Any tab can be saved as a new Excel workbook: File › Download as › Excel Workbook (.xlsx) (in the desktop app, File › Export as › Excel Workbook (.xlsx)), or Excel workbook as the format in Ctrl+Shift+S⇧⌘S.

In the workbook, numbers are numbers, so that Excel can add them up, but only when nothing would be lost: a code like 00123 keeps its zeros, and stays text. The header row always stays text, even a column named 2026.

The Download dialog for a tab imported from an Excel workbook: a note that saving creates a new file and the original workbook is not modified, Format set to Excel workbook (.xlsx), and Sheets set to All 4 open tabs, one sheet each

With more than one tab open, a Sheets choice appears: This tab only, or All 3 open tabs, one sheet each (with the number of tabs you have). Each sheet takes the name of the sheet the tab came from, or of its file, and they come in the order of the tabs. When every open tab is a sheet of the same workbook, the second choice is already selected, and the suggested name has (edited) after it, so that you don’t overwrite the original by accident.

Exporting doesn’t change the tab: it stays a CSV file, and unsaved changes stay unsaved.