Using JMP > Save and Share Your Data > Save Data Tables > Save JMP Data as a Text File
Publication date: 07/08/2024

Save JMP Data as a Text File

JMP can convert data from a JMP data table to standard text format with rows and columns.

Text Formatting Options

Export Column Names to Text File

To save column headings in the first line of text, and to save labels or header information with the data, select Export Table Headers.

Add quotation marks to all column names, Add quotation marks to all character values, Add quotation marks to all numeric values

Select an option to add quotation marks even when they are not required. Some programs that import CSV files might need the quotation marks to display the text correctly. Quotation marks are always added to fields that contain special characters such as the field delimiter (typically a comma or tab), the line separator (typically a carriage return), or quotation marks.

End of Field

Select the radio button next to the character that marks the end of a field (or cell). Select Other and enter a character if the appropriate character is not listed.

End of Line

Select the radio button next to the character that marks the end of a line (or row). Select Other and enter a character if the appropriate character is not listed.

Windows

1. Select File > Export.

2. Select Text and then click Next.

3. (Optional) Rename the file.

4. Click the Options button and specify end-of-line and end-of-field characters, and choose whether to export column headings as text.

5. Click OK.

6. (Optional) To avoid opening the file in the default text editor after saving, deselect Open the file after saving.

7. Click Save.

macOS

1. Select File > Export.

2. Select Text and then click Next.

3. (Optional) Rename the file.

4. Specify end-of-line and end-of-field characters, and choose whether to export column headings as text.

5. (Optional) To avoid opening the file in the default text editor after saving, deselect Open the file after saving.

6. Click Export.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).