There's no real way to do that from the Attribute Viewer. What you'll have to do is:
- Create your selection set
- Open up the Attribute Table
- Right click on one of the boxes next to one of your selected items
- Click on "Copy Selected"
- Go to Excel and paste
You should then have your data in Excel.
Thanks, is there any way to select multiple cells? i'm only able to do it one cell at a time.
Not sure what type of database you are using, but for me - on most Esri formats in ArcMap table window dragging the mouse down the left side if the row indicators or choosing on row then hitting shift and picking your finish row will highlight multiple rows.
Hope this helps,
ArcGIS natively supports pushing out to a DBF file from the table, or selection within a table. Down at the bottom of the context menu, you see the Export... button. This allows you to choose whether to export all records or a selection, and allows you to choose from a (albeit limited) set of formats, including DBF or TXT files. DBF files be natively read by Excel and the TXT file (if you rename it with a .CSV extension) can be read in natively as well.
If you're on 10.2 or 10.2.1 you can also export the table directly to Excel using the Table To Excel script in the ArcToolbox. See how here: 44595 - Export an attribute table to Microsoft Excel
Hope this helps!
So yeah... there are a lot of ways to get the data out...
This is what I was referring to using 10.2.1 (now with pictures!) that I think is the easiest if I just need a few records:
1. Make your selection set
2. Open up the Esri Attribute Table:
3. Click on the "Show Selected Records" on the bottom of the table:
4. Right-click on the gray box next to one of your selected items:
4. Click on "Copy Selected" in the menu that appears:
5. Go to Excel and choose to "Paste" with the "Keep Text Only" option:
6. You have the selection set in Excel with Column headers and everything!
Thanks David. This will work for me.