Intact CSV Editor
DE Download
  1. Home
  2. Formats
Formats

Every format, opened as a table.

33 kinds of data in, 33 formats out. Files are recognised by their bytes, not their names, and saving writes the same format back.

Download free trial
33

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 .xlsxOpenDocument .odsHTML tables .htmlMarkdown tables .md

Structured data

JSON .jsonJSON Lines .jsonlYAML .yamlXML .xmlProperty list .plistBSON .bson

Data engineering

Apache Parquet .parquetApache Avro .avroApache ORC .orcApache Arrow / Feather .arrowSQLite .sqliteHDF5 .h5

Statistics

SPSS .savStata .dtaSAS transport .xptSAS dataset .sas7bdatR data .rdsMATLAB .mat

Mainframe, banking & contacts

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

formats it writes

Delimited text

CSVTSVFixed-width text

Spreadsheets

Excel .xlsxOpenDocument .ods

Structured data

JSONNested JSONJSON LinesYAMLXMLProperty list

Databases

SQL insertsSQLite database

Data engineering

Apache ParquetApache AvroApache ORCApache ArrowBSONHDF5

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 80+ encodings, saved back byte for byte.

Details →Format

Excel and OpenDocument

Every sheet as a table, text kept as text, a workbook again when you save.

Details →Format

JSON, XML and YAML

Nested objects as dotted columns, JSON inside cells as a tree.

Details →Format

Parquet, Avro, ORC, Arrow

The data world's formats, read and written without Python or Spark.

Details →Format

SPSS, Stata, SAS, R, MATLAB

Datasets opened and written without the package that made them.

Details →Format

EBCDIC, copybooks, fixed width

52 code pages, COMP-3 and zoned decimals, bank layouts built in.

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.

Every feature for seven days, fourteen with a free account. No card, and your files never leave your Mac.

Download free trial

macOS 14 Sonoma or later · See pricing