Can't Export to Excel or Copy? (Possibly Too Much Data)

Question

Hello Everyone!

I am handling a LOT of data. We're talking about millions of points, separated into multiple dataframes. I need to get the data into Excel. The shapefile that I'm trying to extract data from has about 100,000 rows and 20 columns. I first tried using the export to Excel tool, but it errored out. I then tried copying from the attribute table and pasting into Excel. Again, it errored in Excel, and then ArcMAP crashed. I thought that maybe there was just too much data for Excel, but I looked up the extents and it shows that Excel can handle up to a million rows and thousands of columns. So I don't know what to do at this point. Any help would be greatly appreciated!

EllieHakari · Answer

I actually figured out how to fix this by not having to export to Excel. Instead, I did a One to One spatial join and took the average of each of the fields I needed. It worked! Thank you for your quick response though!

EllieHakari · Answer

I actually figured out how to fix this by not having to export to Excel. Instead, I did a One to One spatial join and took the average of each of the fields I needed. It worked! Thank you for your quick response though!

RobertScheitlin__GISP · Answer

Ellie,

I commonly export the table from ArcMap as TXT and then once I have that file created I change the .txt extension to .csv and then open the file in Excel.