Using JMP • Save and Share Data • Save and Share Data Tables • Save as a Microsoft Excel File

For the latest version of JMP Help, visit JMP.com/help.

Previous
 • 
Next
Save as a Microsoft Excel File
There are two options for saving data tables as Microsoft Excel files:
•
Save one data table in Microsoft Excel format (.xls or .xlsx). Data from a single table is saved in a workbook named after the data table.
•
Generate a workbook in .xlsx format from multiple tables. Data from each table appear on a different worksheet in the workbook.
The .xlsx file includes data table cell colors. The file also provides hidden data and excluded data. Formulas and most formatting are not included.
The maximum length of the Excel filename is determined by your computer’s operating system.
Save One Data Table as a Microsoft Excel Workbook
To save a data table as a Microsoft Excel workbook, follow these steps:
Windows
1.
Select File > Save As.
2.
Select Excel Workbook (*.xlsx, *.xls).
3.
Enter a name for your file in the File name box.
4.
(Optional) To save the file as an .xls file, select Use Excel 97-2003 Format (*.xls).
5.
(Optional) To avoid opening the file in the default spreadsheet program after saving, deselect Open the file after saving.
6.
Click Save.
Macintosh
1.
Select File > Export.
2.
Select Excel and select the format.
3.
Click Next.
4.
Enter a name for the file in the Save As box.
5.
(Optional) To avoid opening the file in the default spreadsheet program after saving, deselect Open the file after saving.
6.
Click Export.
Note: On Windows, data is split among several worksheets when the number of columns or rows exceeds the number that Excel supports.
Save Multiple Data Tables as a Microsoft Excel Workbook
To save multiple data tables in a new or existing Microsoft Excel workbook, follow these steps:
1.
Open the data tables.
2.
(Windows) Select File > Create Excel Workbook.
3.
(Macintosh) Select File > Export, select Export Multiple Data Tables from the Excel list, and then click Next.
4.
In the Include Table column, select only the data tables that you want to save.
5.
In the Worksheet Name column, specify the name of the worksheet tab if necessary.
6.
Enter a name for the workbook in the Workbook Name box.
The workbook is named after the current data table by default.
7.
Click Choose and browse to select a directory to save the file in.
You can overwrite an existing workbook. Worksheets that already exist in the workbook are replaced. Worksheets that are not in the existing workbook appear at the end of the sheets.
8.
Click Save.
The file is saved as an .xlsx file.

Previous
 • 
Next
Help created on 3/19/2020