Import a Spreadsheet - Wolfram Mathematica 8 Documentation

MATHEMATICA HOW TO

How to | Import a Spreadsheet

You can import spreadsheets created in a variety of formats to take advantage of Mathematica's rich data manipulation and visualization capabilities.

Video 'How to' »

This is a selection of examples from the complete "How to" screencast. »

The spreadsheet

is included in the Mathematica documentation folder ExampleData:

Import the spreadsheet and set it to

In[3]:=

Out[3]=

Display the first worksheet of the spreadsheet

in a grid:

In[4]:=

Out[4]=

You can also import specific rows and columns of a spreadsheet.

Import only the first 3 rows of the spreadsheet:

In[5]:=

Out[5]=

Import only the first column of the first 3 rows of the spreadsheet:

In[6]:=

Out[6]=

Import only the second column of the first 3 rows of the spreadsheet:

In[7]:=

Out[7]=

Import only row 3 of the spreadsheet:

In[8]:=

Out[8]=

TUTORIALS

Importing and Exporting Data

Importing and Exporting Files