Workbooks, read as the data they hold
An .xlsx opens with its shared strings, rich text, formula results, date formats and skipped rows and
columns understood. An OpenDocument .ods opens with its repeated rows and columns expanded. A workbook
with several sheets opens on the first; the others are a click away in File ▸ Sheet, and the window says which
sheet is on show and what else the workbook holds.
What looks like a number in a text cell stays text: an article number stored as 00731 in the
workbook is 00731 in the grid.
Saving writes a workbook again
Open a workbook, edit it, press ⌘S and you get a workbook — not a CSV with the wrong ending. Save As converts to any of the other formats. Two things are worth knowing, because Intact CSV Editor is a data editor rather than a spreadsheet:
- Formulas arrive as their results, and cell styles — colours, borders, fonts — are not kept.
- Saving writes the sheet on show. The inspector says so before you save, rather than leaving it to be discovered.
That is the right trade for the job most workbooks arrive for: an export from another system that needs checking, cleaning and sending on.
HTML tables from a web page
Open a saved web page and the app lists the tables in it, with their size, and opens the ones you choose — each as a document of its own. A table copied from a browser pastes in as rows and columns. Markdown pipe tables open too.
Export to Excel
Any table — a CSV, a Parquet file, a SQL result — exports to .xlsx with a sheet name and a frozen
header row, or to .ods for LibreOffice and Numbers. A million rows go out in seconds. Two presets are
built in: Excel (European) and Excel (US) for the CSV files each flavour of Excel expects.
