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

2305
4
Jump to solution
12-12-2022 05:29 AM
Bud
by
Notable Contributor

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:

paste into existing rows.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.

Related: Pasting rows from Excel into Attribute Table using CTRL+V works; do it with the paste button too

 

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
Bud
by
Notable Contributor

It looks like the answer is yes. Steps:

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

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

GIF:

paste to create new rows.gif

View solution in original post

0 Kudos
4 Replies
Bud
by
Notable Contributor

It looks like the answer is yes. Steps:

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

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

GIF:

paste to create new rows.gif

0 Kudos
MicZatorsky_AEC
Occasional Contributor III

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

0 Kudos
MichaelAugust
Occasional Contributor III

I did thanks!