topic Copy/paste data from Excel into attribute table as new rows in ArcGIS Pro Questions

Copy/paste data from Excel into attribute table as new rows

Bud — Wed, 01 Feb 2023 17:09:31 GMT

Background:

I have an table in ArcGIS Pro that has existing rows. I'm able to copy/paste rows from an Excel spreadsheet to replace the existing Attribute Table data.

Like this:

Click on an existing cell in the Attribute Table
Use CTRL+V to paste

GIF:

That works as expected. The existing data has been replaced.

Question:

I want to do something similar to the above, but this time I want to paste Excel data as new rows in the attribute table, not replace the data in existing rows.

Is there a way to paste data from Excel as new rows?

ArcGIS Pro 3.0.3; mobile geodatabase.

Re: Copy/paste data from Excel into attribute table as new rows

Bud — Mon, 12 Dec 2022 13:30:29 GMT

It looks like the answer is yes. Steps:

Copy the data from Excel.
Create a new row by hitting "Click to add new row" at the bottom of the table.
Hit enter to commit the row.
Hit the ESCAPE keyboard key to stop editing that cell.
Use CTRL+V to paste the data.

New rows have been created from the pasted data, as expected.

GIF:

Re: Copy/paste data from Excel into attribute table as new rows

MicZatorsky_AEC — Wed, 14 Dec 2022 04:18:39 GMT

@Bud - unrelated to your question, what app(s) did you use for the animated GIF?

Re: Copy/paste data from Excel into attribute table as new rows

Bud — Wed, 14 Dec 2022 08:04:45 GMT

https://www.screentogif.com/

https://community.esri.com/t5/community-feedback/what-screen-recording-app-do-you-use/m-p/1240223#M1520

Re: Copy/paste data from Excel into attribute table as new rows

MichaelAugust — Tue, 09 Jan 2024 19:09:20 GMT

I did thanks!