Mathematica 9 is now available
Previous section-----Next section

1.11.3 Importing and Exporting Data

Import["file", "Table"] import a table of data from a file
Export["file", list, "Table"] export list to a file as a table of data

Importing and exporting tabular data.
This exports an array of numbers to the file out.dat.

In[1]:=  Export["out.dat", {{5.7, 4.3}, {-1.2, 7.8}}]

Out[1]=

Here are the contents of the file out.dat.

In[2]:=  !!out.dat


This imports the contents of out.dat as a table of data.

In[3]:=  Import["out.dat", "Table"]

Out[3]=

Import["file", "Table"] will handle many kinds of tabular data, automatically deducing the details of the format whenever possible. Export["file", list, "Table"] writes out data separated by spaces, with numbers given in C or Fortran-like form, as in 2.3E5 and so on.

Import["name.ext"] import data assuming a format deduced from the file name
Export["name.ext", expr] export data in a format deduced from the file name

Importing and exporting general data.

table formats "CSV", "TSV", "XLS"
matrix formats "HarwellBoeing", "MAT", "MTX"
specialized data formats "DIF", "FITS", "HDF5", "MPS", "SDTS", etc.

Some common formats for tabular data.

Import and Export can handle not only tabular data, but also data corresponding to graphics, sounds, expressions and even whole documents. Import and Export can often deduce the appropriate format for data simply by looking at the extension of the file name for the file in which the data is being stored. Sections 2.10.19 and 2.12.7 discuss in more detail how Import and Export work. Note that you can also use Import and Export to manipulate raw files of binary data.

This imports a graphic in JPEG format.

In[4]:=  Import["turtle.jpg"]

Out[4]=

This displays the graphic.

In[5]:=  Show[%]

Out[5]=

$ImportFormats import formats supported on your system
$ExportFormats export formats supported on your system

Finding the complete list of supported import and export formats.


Any questions about topics on this page? Click here to get an individual response.Buy NowMore Information
THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.