These hands-on activities allow you to practice importing data from Excel into JMP using the Excel Import Wizard. This post contains the Excel import hands-on activities, the data, and a PDF file of these solutions in English.
1. Import the data from the file Practice 1.xls into JMP. Your table should look like the following screen capture when finished.
![Di_Michelson_1-1690550703550.png Di_Michelson_1-1690550703550.png](https://community.jmp.com/t5/image/serverpage/image-id/55346i993E39BB57BEFA15/image-size/medium?v=v2&px=400)
a) Select File > Open.
b) If needed, change the file type to Data Files or All Files.
c) Select Practice 1.xlsx.
d) Click Open.
e) Click Restore Default Settings.
![Di_Michelson_4-1690556122620.png Di_Michelson_4-1690556122620.png](https://community.jmp.com/t5/image/serverpage/image-id/55352iE7F3F3C2580A8AF9/image-size/medium?v=v2&px=400)
f) In the Data Preview panel, scroll down, then select row 9.
![Di_Michelson_5-1690556172056.png Di_Michelson_5-1690556172056.png](https://community.jmp.com/t5/image/serverpage/image-id/55353iA8893FAEFFB384EE/image-size/medium?v=v2&px=400)
g) Click the green plus button
next to Column headers start on row.
![Di_Michelson_7-1690556227625.png Di_Michelson_7-1690556227625.png](https://community.jmp.com/t5/image/serverpage/image-id/55356i35390A0F8C493939/image-size/medium?v=v2&px=400)
h. Click Import.
i. Widen the Date column.
![Di_Michelson_8-1690556272493.png Di_Michelson_8-1690556272493.png](https://community.jmp.com/t5/image/serverpage/image-id/55357iA640911CB065F582/image-size/medium?v=v2&px=400)
The Date column format looks acceptable, but the column has been imported with a Character data type and Nominal modeling type. Change to Numeric, Continuous.
j) Right-click the top of the Date column and select Column Info.
![Di_Michelson_9-1690556322776.png Di_Michelson_9-1690556322776.png](https://community.jmp.com/t5/image/serverpage/image-id/55358iCABB8FB323C46626/image-size/medium?v=v2&px=400)
k) Change the Data Type to Numeric.
l) Change the Modeling Type to Continuous.
m) Under Format, click Best, then select Time > ddMonyyyy h:m.
![Di_Michelson_10-1690556377466.png Di_Michelson_10-1690556377466.png](https://community.jmp.com/t5/image/serverpage/image-id/55359iD6D9B822C0FDACCD/image-size/medium?v=v2&px=400)
n) Click OK.
![Di_Michelson_0-1690556512856.png Di_Michelson_0-1690556512856.png](https://community.jmp.com/t5/image/serverpage/image-id/55361i66FAFB38D6ECA3FE/image-size/medium?v=v2&px=400)
2. Import the data from the file Practice 2.xls into JMP. Your table should look like the following screen capture when finished.
![Di_Michelson_2-1690550740695.png Di_Michelson_2-1690550740695.png](https://community.jmp.com/t5/image/serverpage/image-id/55347iCC480F5F5ABD3748/image-size/medium?v=v2&px=400)
a) Select File > Open.
b) If needed, change the file type to Data Files or All Files.
c) Select Practice 2.xlsx.
d) Click Open.
e) Click Restore Default Settings.
![Di_Michelson_0-1690556788399.png Di_Michelson_0-1690556788399.png](https://community.jmp.com/t5/image/serverpage/image-id/55362i18E0CD188D6C9472/image-size/medium?v=v2&px=400)
f) In Worksheets, click each sheet in turn, then scroll in the Data Preview panel to see they have the same format.
g) Click Select All.
h) In the Data Preview panel, select row 6.
![Di_Michelson_1-1690556821008.png Di_Michelson_1-1690556821008.png](https://community.jmp.com/t5/image/serverpage/image-id/55363iA1536DE6DD0C232A/image-size/medium?v=v2&px=400)
i) Click the green plus button next to Column headers start on row.
j) Select both checkboxes Concatenate worksheets and try to match columns and Create column with worksheet name when concatenating.
![Di_Michelson_2-1690556846188.png Di_Michelson_2-1690556846188.png](https://community.jmp.com/t5/image/serverpage/image-id/55365i6D7C032E66C28A2D/image-size/medium?v=v2&px=400)
k) Click Import.
![Di_Michelson_3-1690556867973.png Di_Michelson_3-1690556867973.png](https://community.jmp.com/t5/image/serverpage/image-id/55366iA18C7992F8C48C3A/image-size/medium?v=v2&px=400)
l) Change the name of the Source Table column to Tank.
m) Right-click the top of the Tank column and select Recode.
n) Change the values to 1, 2, 3, 4.
o) Select New Column > In Place.
p) Click Recode.
q) Change the data type of the Date column to Numeric.
r) Change the modeling type of the Date column to Continuous.
s) Change the format of the Date column to ddMonyyyy h:m.
![Di_Michelson_4-1690556934793.png Di_Michelson_4-1690556934793.png](https://community.jmp.com/t5/image/serverpage/image-id/55367i2E55A8BF2A004325/image-size/medium?v=v2&px=400)
3. Import the data from the file Practice 3.xls into JMP. Your table should look like the following screen capture when finished.
![Di_Michelson_3-1690550771786.png Di_Michelson_3-1690550771786.png](https://community.jmp.com/t5/image/serverpage/image-id/55348i6E9F4966029A2B5A/image-size/medium?v=v2&px=400)
a) Select File > Open.
b) If needed, change the file type to Data Files or All Files.
c) Select Practice 3.xlsx.
d) Click Open.
e) Click Restore Default Settings.
![Di_Michelson_5-1690557043023.png Di_Michelson_5-1690557043023.png](https://community.jmp.com/t5/image/serverpage/image-id/55368i430931555E334B78/image-size/medium?v=v2&px=400)
f) Change the Number of rows with column headers to 2. Note that Data starts on row automatically changes to 3.
![Di_Michelson_6-1690557060320.png Di_Michelson_6-1690557060320.png](https://community.jmp.com/t5/image/serverpage/image-id/55369i0B2953EAB293A81D/image-size/medium?v=v2&px=400)
g) Click Next.
h) Select Treat multiple column header lines as hierarchies.
![Di_Michelson_7-1690557093710.png Di_Michelson_7-1690557093710.png](https://community.jmp.com/t5/image/serverpage/image-id/55370i5BC032AEE3ED7ACC/image-size/medium?v=v2&px=400)
i) Click Import.
j) Change the name of Column to Year.
k) Change the name of Column 2 to Month.
l) Change the name of Data to Temp.
![Di_Michelson_8-1690557128111.png Di_Michelson_8-1690557128111.png](https://community.jmp.com/t5/image/serverpage/image-id/55371i2BD32292A5DE21DA/image-size/medium?v=v2&px=400)