arcgis-explorerexcelexportfeaturesfiles
I need to export the underlying data contained in these GIS files (http://wildfire.cr.usgs.gov/firehistory/data.html) into a .txt or .ascii file.
I am using ArcGIS explorer so I do not have the "Table to Excel function."
Some of the layers have less than 100,000 features so I've been creating attribute tables and then exporting those as .txt files. Some of the layers have >100,000 features. I'm at a loss for how to export those into an excel file.
Do you receive the same error by copy/pasting records?
This is from memory, but if you right-click on the gray row indicator box, your menu should have "Copy Selected Records". Then you can paste directly into an Excel spreadsheet.
A caveat: if your selections are in a related table that are a result of a feature selection, you might actually have incorrect selections (you get rows in your related table that aren't actually related to any of your selected features and you could be missing others). One of my users discovered this issue, which appears intermittent. I did narrow down the issue to ArcMap. The geodatabase+custom ArcObjects test code works correctly. Our workaround: if our users need the related data for something important and the number of records is too large for them to visually inspect, we obtain the data from the database using a sql query. We haven't seen this issue with ArcGIS 10.
Update: You said you got the data into Excel. Are your DMS values in a text field? You might be able to parse the information that you need and round your decimal value. based on what I see in your screen shot, i came up with:
=LEFT(A1,8) & ROUND(VALUE(MID(A1,9,6)),1) & MID(A1,15,2)
If you open the attribute table,
open an empty excel spreadsheet,
Select all or some of the records in the attribute table.
to select all the button in upper left gives this pulldown to accomplish that.
right click on the left edge (on a box).
copy selected.
Switch to the spreadsheet. right click in the upper left cell (just one cell)
ctrl+V (paste).
Best Answer
If exporting to excel you would have to be within the limitations of the spreadsheet, which is available on Microsoft help page
1,048,576 rows by 16,384 columns
In addition, you can follow these different methods as outlined by ESRI on their support page here
Start ArcMap.
Open the Table To Excel tool from ArcToolbox > Conversion Tools > Excel > Table To Excel. -show me-
Specify the Input Table from the drop-down list, or move the feature class into the text box.
Specify the Output Excel File. -show me-
Click OK. The Excel file is created in the designated output location.
Start ArcMap.
Open the attribute table; right-click the feature class > Open Attribute Table. -show me-
Click the Table Options arrow > Select All. -show me-
Right-click the left-most column of the attribute table, and select Copy Selected. -show me-
Start Microsoft Excel.
Right-click cell A1 of the Excel file, and select Paste. -show me-
Save the file.
Follow steps 1 and 2 in Option B above.
Click the Table Options arrow, and select Export. -show me-
Under 'Output table', click folder browsing icon. -show me-
Under 'Save as type', click the drop-down list, and select Text File. -show me-
Specify the desired name and change the '.txt' to '.csv' to the name.
Click Save.
Navigate to the folder location through Windows Explorer to view the .csv file in Microsoft Excel.