Tabular & Spreadsheet Formats

The Wolfram Language can export tables of numerical and textual data to any common spreadsheet file format or as formatted text. It can also import from such formats to give Wolfram Language arrays and metadata in various forms.


Tabular Text Formats

"Table" generic tabular data (.dat)

"CSV" comma-separated values (.csv)

"TSV" tab-separated values (.tsv)

Spreadsheet Formats

"XLS" Excel spreadsheet (.xls)

"XLSX" Excel 2007 format (.xlsx)

"ODS" OpenDocument spreadsheet (.ods)

"SXC" OpenOffice 1.0 spreadsheet file (.sxc)

"DIF" VisiCalc data interchange format (.dif)

Data Interchange Formats

"RawJSON" JSON with objects as associations

"JSON" JSON with objects as rule lists (.json)

Common Elements

"Data" array of numbers or strings

"Rules" rules for all elements

"Elements" all available elements

Translate this page: