topic Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field? in ArcGIS Pro Questions

How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

AndySiegel — Tue, 23 Apr 2019 17:03:07 GMT

In ArcMap (10.6.1), I am able to copy/paste values from Excel column into attribute table field. I select the first cell in attribute table, then paste and the values populate for all the records below. See example:

I can't figure out how to do this in ArcGIS Pro. Does anyone know how to do this or if it is even possible? Thanks for any help you can provide!

Andy

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

JoeBorgione — Tue, 23 Apr 2019 17:10:19 GMT

'Smear' the value in Excel Cntrl C and Cntrl V into the table. If you're going to do bulk copy and paste, I suggest converting the Excel worksheet to a table.

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

AndySiegel — Tue, 23 Apr 2019 17:29:08 GMT

Thanks for the reply! What do you mean by smear in Excel? Also, it seems Ctrl C / Ctrl V doesn't work the same way for pasting data into ArcGIS Pro table. When the table is editable, it seems that only a single record can be edited (designated by the green background and pencil symbol).

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

JoeBorgione — Tue, 23 Apr 2019 19:03:36 GMT

It's a one at a time sort of thing. That's why I suggest to turn the Excel into a table. None the less, the gif below shows how I did it. You just don't see the Cntrl C and Cntrl V....

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

KoryKramer — Tue, 23 Apr 2019 19:16:17 GMT

https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDExMTU5NQ==

Here is a daily build of 2.4:

We should see 2.4 generally available in June/July this year.

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

AndySiegel — Tue, 23 Apr 2019 19:21:33 GMT

Awesome! Thanks Kory. Looking forward to 2.4

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

JoeBorgione — Tue, 23 Apr 2019 19:21:41 GMT

Good to know @Kory_Kramer. That sounds like a great fix.

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

AndySiegel — Tue, 23 Apr 2019 19:26:41 GMT

Glad the fix is coming in 2.4! Thanks for helping look into the issue.

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

MichaelAugust — Tue, 09 Jan 2024 18:33:41 GMT

I am getting an extra NULL pasted and a new row created in my Pro att table when for example I grab five cells from a column in Excel, then paste to my field/column in ArcGIS Pro, Pro will literally create a new row(or point feature), all fields NULL, as if there were six cells coming from Excel instead of the 5 I selected. It's as if Pro is just always tacking on one additional NULL cell to the bottom of my Excel selection. I can repeat it all day and haven't figured out how to copy/paste correctly...

Wondering if anyone knows what I'm doing wrong, or if they've seen the same?

additionally if I paste these five values copied from Excel into a populated att table in Pro, that 6th mystery/unwanted NULL will overwrite existing data in that 6th row/point feature with NULL

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

Bud — Tue, 09 Jan 2024 18:44:15 GMT

Re: How to copy/paste values from Excel column into ArcGIS Pro attribute table field?

MichaelAugust — Tue, 09 Jan 2024 18:59:11 GMT

This is my issue here Excel on left, Pro on right: