Using JMP > Enter and Edit Your Data > Enter Data in Data Tables > Copy and Paste Data into Data Tables
Publication date: 07/15/2025

Copy and Paste Data into Data Tables

When you paste data from another document into a data table, JMP adds rows and columns as needed. Click a cell and paste the data.

Multiple Lines of Data

When you copy one data table cell and paste several lines of data, each line is pasted into its own cell.

To paste all lines into one cell, perform one of the following tasks:

Double-click an existing cell and then paste.

Right-click an existing cell and select Paste into Cell. The Paste into Cell option is available on character and expression columns only.

Note: If you try to paste into a cell that does not exist, the text will paste into separate cells.

The data type of the copied content must match the data type of the cells that you are pasting into. You can add new columns and paste the data, paste the data into cells of the correct data type, or change the data type of the cells if necessary.

Note: To copy the entire numeric value, select Edit > Copy With Full Precision. This option applies only to the fixed decimal format.

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