topic Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19? in Discussions

Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

Ressel — Wed, 15 Oct 2025 12:25:08 GMT

JMP 18 allowed copy pasting of column headers from Excel to JMP tables easily using point & click. See the video here:

Sadly, this isn't out of the box functionality for JMP 19. Anyone who knows a fix? I think this was really useful functionality to have and am wondering what made JMP remove it.

(view in My Videos)

As a somewhat seasoned JMP user, this looks like it could be one of the things that makes new users decide against JMP. Could be I'm wrong, of course.

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

hogi — Wed, 15 Oct 2025 14:42:16 GMT

I don't know why the functionality was removed.
maybe it was too secret:

For your approach (with column names in row 1),
you could directly paste the values with column names:

If the data is already in JMP, "Move Up" is the coolest way to get the column names "up":

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

hogi — Wed, 15 Oct 2025 13:27:17 GMT

As an alternative, you can use "Paste column names"

from

https://community.jmp.com/t5/Discussions/Undocumented-Secrets/m-p/907821/highlight/true#M106607

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

hogi — Wed, 15 Oct 2025 13:28:36 GMT

To get CTRL-V back, you can support one of these wishes from the wish list :
Restore data-grid behavior: Pasting onto column names to rename them

Restore Column Name Update Via Paste

Please restore ability to copy-paste column names from one table to another

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

Ressel — Wed, 15 Oct 2025 13:30:36 GMT

@hogi ... always there. Thanks.

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

hogi — Wed, 15 Oct 2025 13:31:55 GMT

All of us, we have similar issues : )

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

EvanMcCorkle — Wed, 15 Oct 2025 14:39:33 GMT

As mentioned earlier, there are several ways to address this after your data is in JMP. However, it should be faster (and with better handling of column data and modeling types) to use import tools:

Use "Paste With Column Names" under the JMP Data Table "Edit" menu.
Excel-specific
- Use the JMP Excel Add-in in the Excel ribbon to transfer your selection from Excel to JMP using the "Data Table" button.
- Import your .xls or .xlsx file into JMP rather than using copy/paste.

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

Greenhorn — Thu, 04 Dec 2025 15:09:34 GMT

Alternative way is not near as good as function in jmp 18. Sometimes I have creepy data snippets and I need to compile data quickly. I admired that function to paste column names from copy clipboard. :(

Re: Copy pasting column headers & data from Excel to JMP - changed behaviour in JMP19?

Dan_Obermiller — Mon, 08 Dec 2025 16:31:10 GMT

Lots of good options here, of course. But my favorite was holding down the shift key while hitting CTRL-V.