topic Re: Can't Export to Excel or Copy? (Possibly Too Much Data) in Data Management Questions

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

EllieHakari — Wed, 26 Oct 2016 16:11:13 GMT

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!

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

NeilAyres — Wed, 26 Oct 2016 16:18:42 GMT

Firstly, what version of Arc are you using and next what version of excel?

The old xls had a limit of 65536 rows (2 ^ 16).

xlxs or what ever its called had just over a million rows. ( 2 ^ 20).

Is there some funny headers in the data?

Best place is the table to excel tool, but you say this is erroring out. Check paths for spaces etc.

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

RobertScheitlin__GISP — Wed, 26 Oct 2016 16:21:16 GMT

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.

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

EllieHakari — Wed, 26 Oct 2016 17:07:24 GMT

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!

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

EllieHakari — Wed, 26 Oct 2016 17:07:30 GMT