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)

"UBJSON" Universal Binary JSON (.ubj)

Statistical Formats

"DTA" Stata database transport format (.dta)

"SAS7BDAT" SAS database transport format (.sas7bdat)

"XPORT" SAS interchange format

"SAV" SPSS database transport format (.sav, .zsav)

"POR" SPSS database transport format (.por)

"RData", "RDS" R data format family import

Common Elements

"Data" array of numbers or strings

"Rules" rules for all elements

"Elements" all available elements