Mathematica 9 is now available
THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.
Mathematica > Data Handling & Data Sources > Importing & Exporting >
Tabular & Spreadsheet Formats
Mathematica 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 Mathematica 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)
"ODS" OpenDocument spreadsheet (.ods)
"SXC" OpenOffice 1.0 spreadsheet file (.sxc)
"DIF" VisiCalc data interchange format (.dif)
    
Common Elements
"Data" — array of numbers or strings
"Rules" — rules for all elements
"Elements" — all available elements
TUTORIALS
MORE ABOUT
Ask a question about this page  |  Suggest an improvement  |  Leave a message for the team