nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

AndySiegel

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

Encontre mais publicações marcadas com

Accepted answers

GISMallku

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.

All comments

MichaelAugust

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

Bud

MichaelAugust

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

AndySiegel

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

JoeBorgione

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

AndySiegel

Awesome! Thanks Kory. Looking forward to 2.4

GISMallku

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.

JoeBorgione

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....

AndySiegel

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).

JoeBorgione

'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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.