Mathematica 9 is now available
SEARCH MATHEMATICA 8 DOCUMENTATION
THIS IS DOCUMENTATION FOR AN OBSOLETE PRODUCT.
SEE THE DOCUMENTATION CENTER FOR THE LATEST INFORMATION.
Mathematica HowTo
How to | Import a Spreadsheet
You can import spreadsheets 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 »
Import the spreadsheet population.xls and set it to s:
In[1]:=
Click for copyable input
Out[1]=
Display the first worksheet of the spreadsheet s in a grid:
In[2]:=
Click for copyable input
Out[2]=
You can also import specific rows and columns of a spreadsheet.
Import only the first 3 rows of the spreadsheet:
In[3]:=
Click for copyable input
Out[3]=
Import only the first column of the first 3 rows of the spreadsheet:
In[4]:=
Click for copyable input
Out[4]=
Import only the second column of the first 3 rows of the spreadsheet:
In[5]:=
Click for copyable input
Out[5]=
Import only row 3 of the spreadsheet:
In[6]:=
Click for copyable input
Out[6]=
Ask a question about this page  |  Suggest an improvement  |  Leave a message for the team