How to | Import a Spreadsheet

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

Selected examples from the video:

The spreadsheet is included in the Wolfram Language documentation folder ExampleData:

Import the spreadsheet and set it to :

In[3]:=
Click for copyable input
Out[3]=

Display the first worksheet of the spreadsheet in a grid:

In[4]:=
Click for copyable input
Out[4]=

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

Import only the first 3 rows of the spreadsheet:

In[5]:=
Click for copyable input
Out[5]=

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

In[6]:=
Click for copyable input
Out[6]=

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

In[7]:=
Click for copyable input
Out[7]=

Import only row 3 of the spreadsheet:

In[8]:=
Click for copyable input
Out[8]=