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 into attribute table from Excel

IsabelleWolf

I would like to copy and paste values (eg. an Excel column) to an ArcGIS Pro Attribute table.

According to Edit an active table—ArcGIS Pro | ArcGIS Desktop , this should work as follows: "Copy the information from the other application that you need to the clipboard. Highlight the starting cell in your database table inside ArcGIS Pro and paste the values using Ctrl+V or right-click and click Paste."

However this does not do anything in my table. Also I noted that when I right-click in a cell of an attribute table, I do not get a context menu for copy paste?

Any thoughts on this?

Thank you, Isi

Find more posts tagged with

Accepted answers

KoryKramer

Isi, are you in ArcGIS Pro 2.4? Much of the table editing experience was improved in that (the latest) version.

As for the editing comment, you are correct that there is no need to explicitly start an edit session - but technically an edit session does exist as you are able to undo edits before saving them. Here is a blog that will hopefully help to demystify how editing in Pro works: https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/dont-fret-it-just-edit/

All comments

IsabelleWolf

Great to know/get the link. Thanks, Kory. Do you know if the functionality of being able to copy the value from one cell in an attribute table to several cells will be integrated as well? Or does it already exist and I have somehow missed it? Similarly, the functionality to copy one column in an ArcGIS Pro attribute table into Excel (I seem to only be able to copy several/all rows and then paste into Excel which pastes all columns).

Thank you again, Isabelle

KoryKramer

Cool! I'm glad that worked. It wasn't a bug, the functionality just hadn't been built into Pro yet.... until 2.4.

LOTs and lots of stuff was added in 2.4, including a ton of customer ideas: https://community.esri.com/community/arcgis-ideas/blog/2019/06/21/ideas-in-arcgis-pro-24

Cheers!

IsabelleWolf

Thanks so much, Kory, great suggestion. Just updated to 2.4, and guess what, table editing works now! must have been a bug in the previous version. thanks stacks and happy GIS'ing.

Isi

KoryKramer

Isi, are you in ArcGIS Pro 2.4? Much of the table editing experience was improved in that (the latest) version.

IsabelleWolf

Thanks, Dan, I tried all that, unfortunately to no avail. In saying that, why would you need an edit session in Pro. It seems different to ArcMap since you do not have to start editing, you simply edit, or have I missed something?

DanPatterson_Retired

I don't know, I only use excel when I have to, but if you can I suspect you have to select the cells in excel (not just the column) and you would probably have to be in an edit session in Pro

IsabelleWolf

Thanks heaps, Dan, this answers another question I had about copying from ArcGIS Pro to Excel!

However, how does the following work:

I add a new field and therefore have empty cells in this field (see image), which I now like to fill by copying a column from Excel into ArcGIS Pro?

And similarly, I add a new field and therefore have empty cells in this field, and would like to lets say copy the value of one cell in ArcGIS Pro to all the other cells of this column.

Thank you again, Isabelle

DanPatterson_Retired

Then paste in excel will work properly

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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