Intact CSV Editor
DE Join the beta
  1. Home
  2. Formats
Formats

Every format, opened as a table.

43 kinds of data in, 38 formats out. Files are recognised by their bytes, not their names, and saving writes the same format back — over the file where the table is all it holds, to a copy where it is not.

Join the beta
43

kinds of data it opens

Delimited text

CSV .csvTSV .tsvAny separator ; | : ␟ASCII Separated Values .asvFixed-width text .txtLog files, by pattern .log

Spreadsheets & documents

Excel .xlsx .xlsmExcel 97–2003 .xlsExcel binary .xlsbOpenDocument .odsHTML tables .htmlMarkdown tables .md

Structured data

JSON .jsonJSON Lines .jsonlYAML .yamlXML .xmlProperty list .plistTOML .tomlGeoJSON .geojsonBSON .bsonMessagePack .msgpack

Data engineering

Apache Parquet .parquetApache Avro .avroApache ORC .orcApache Arrow .arrowFeather .featherDelta Lake table folderApache Iceberg table folderPython pickle .pklSQLite .sqlite

Statistics & science

SPSS .savStata .dtaSAS transport .xptSAS dataset .sas7bdatR data .rdsMATLAB .matHDF5 .h5NetCDF .nc

Mainframe, banking & contacts

EBCDIC with a COBOL copybook .datSwiss ESR V11 records .v11NACHA ACH files .achvCard .vcfmacOS Contacts
38

formats it writes

Delimited text

CSVTSVFixed-width text

Spreadsheets

Excel .xlsxOpenDocument .ods

Structured data

JSONNested JSONJSON LinesYAMLXMLProperty listTOMLGeoJSON

Databases

SQL insertsSQLite database

Data engineering

Apache ParquetApache AvroApache ORCApache ArrowFeatherBSONMessagePackPython pickleHDF5

Statistics

SPSSStataSAS transportR dataMATLAB

Mainframe

COBOL copybookMainframe data (EBCDIC)

Documents

PDFWord .docxRich TextHTMLMarkdownLaTeXAsciiDoc
In detail

Each family of file.

Format

CSV and delimited text

Every separator, quoting style, line ending and 133 character sets, saved back byte for byte.

Details →Format

Excel and OpenDocument

Every sheet as a table, .xls and .xlsb too, and a workbook saved back as itself.

Details →Format

JSON, XML, YAML and TOML

Nested objects as dotted columns, GeoJSON with its places, JSON inside cells as a tree.

Details →Format

Parquet, Delta Lake, Avro, ORC, Arrow

The data world's formats and pandas' pickles, without Python or Spark.

Details →Format

SPSS, Stata, SAS, R, NetCDF

Datasets and measurements opened without the package that made them, labels kept.

Details →Format

EBCDIC, copybooks, fixed width

52 code pages, COMP-3 and zoned decimals, a copybook written for a file that came without one.

Details →Format

SQLite and SQL

Databases as tables; SQL across every open file.

Details →Format

vCard and Mac Contacts

One value per cell, ready for a mail merge.

Details →Format

Log files

A regular expression per line, a column per group.

Details →Format

PDF, Word and HTML

Tables people can read — PDF/A, Word, rich text, self-sorting HTML.

Details →

Open your most difficult file.

Join the beta and we will write to you as soon as your access is ready. Your files never leave your Mac.

macOS 14 Sonoma or later · How we use your address