Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

How can I copy a table, or selection of rows or columns in a table, from Arcmap without going through the pointy-clicky-typey exercise of Export table? The destination of said copy could be anything: notepad, excel, word, whatever.

The existing context menu only allows copying the value for a single cell and using the keyboard [Ctrl-C] also just copies a single cell value:

context menu expanded to showing copy cell value

I'm using Arcmap 10.1, but this has been annoying for years, so don't feel the need to restrict your answer to a particular version.

share|improve this question
add comment

5 Answers 5

up vote 13 down vote accepted

Your screen capture shows nicely how to copy current cell value to the clipboard. To copy selected records, right-click on the left-most gray button (where the 'triangle' is shown in your screen capture) and choose Copy Selected. Note: keyboard shortcut for both is Ctrl + Shift + C.

share|improve this answer
    
beautiful! Now, how long has that been there and I didn't know?? (too bad it doesn't work for columns too). –  matt wilkie Apr 23 '13 at 19:12
1  
I know what you mean about copying columns! It takes a few more clicks but once you hide all fields you don't want (usually through Layer Properties > Fields tab), select all rows, and then use the Copy Selected command (typically much faster to just delete the columns you don't want in an Excel spreadsheet or Word table format). –  ccn Apr 23 '13 at 19:17
4  
The full list is here - resources.arcgis.com/en/help/main/10.1/index.html#//… over 120 shortcuts have been added since ArcGIS 8.3 - Also depending on what mode (table edit) you are in. –  Mapperz Apr 23 '13 at 19:52
add comment

This is one of those annoyingly simple but obscure software things. If you just right click on the grey boxes over on the left of the attribute table and select "copy selected" there, you will get the whole tuple, not just the field your mouse happens to be over. You'll be able to paste the table as tab separated plain text into whatever application you please.

r-click on grey row heading bars, at left

share|improve this answer
2  
I accepted @ccn's answer because he was first up and gave the keyboard shortcut. Your contribution with screenshot definitely fleshes out the answer more fully, thanks :) –  matt wilkie Apr 24 '13 at 18:44
    
after seeing Brad Nessom's similar answer here, I decided the screenshot could benefit from some more context; so updated. –  matt wilkie May 7 at 18:50
add comment

Not sure what Kevin mean but I did find another way around..

Select all the rows and columns ( if your highlight shows light blue) Then at the bottom of the Attribute table that has two buttons and one of them says Show selected records. Re-hightlighted again and it should turn yellow hightlight right clicked on your mouse and it should show you Copy selected.

enter image description here

1: I still have to do this to copy the acres and Tfactor to the Data Layout.

This is done in ArcMap 10.1

share|improve this answer
add comment

For Arcmap 9.x this functionality is available from the Table Of Contents but not in the attribute table.

  • select the records, right-click on the layer/table in the TOC, then click on
  • Selection/Copy records for selected features, if it's a feature layer, or
  • Copy records, if it's a table.
  • Paste into whatever other program you like: Notepad, Word, Excel, etc.

Hat tip to Valentina Boycheva in the old Esri Forums.

share|improve this answer
add comment

XTools Pro has many functions, including a simple export to Excel function. XTools isn't a free extension, but the export function works after your evaluation period expires.

share|improve this answer
    
Thanks for contributing HeyOverThere. Export is built in to Arcmap, though perhaps not with the same proficiency as XTools. However this is off-topic, I specifically asked for a method that doesn't involve exporting. –  matt wilkie Apr 23 '13 at 20:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.