topic Re: ArcGIS Pro: batch table to excel result in single result in ArcGIS Pro Questions

ArcGIS Pro: batch table to excel result in single result

Alexandra_Luisa_HøjgaardWood — Fri, 26 Jun 2020 11:05:18 GMT

I might be doing this wrong, but I am attempting to convert a large array of attribute tables into excel files, using Arcgis Pro. I am attempting to do so via the 'batch table to excel', but all my results yield in a single excel sheet containing only information from the first attribute table.

What am I doing wrong?

Re: ArcGIS Pro: batch table to excel result in single result

DrewFlater — Sat, 27 Jun 2020 00:15:00 GMT

Hi Alexandra Luisa Højgaard Wood‌

I followed these steps and it worked for me:

Right-click the Table To Excel tool
Select Batch
Leave all the defaults on the batch page and click Next
Pick several layers/tables from my map to convert, in the Batch Input Table parameter
Specify the output as C:\temp\Excel_%Name%.xlsx (using this %Name% will mean the output will use the name of each individual input for each iteration of the batch)
Click Run

Produced these 6 excel files

Re: ArcGIS Pro: batch table to excel result in single result

RamonWilliams — Wed, 11 Sep 2024 16:45:00 GMT

is the batch table to excel conversion still around I can not batch with it anymore?

Re: ArcGIS Pro: batch table to excel result in single result

Wardal — Mon, 18 Nov 2024 02:35:33 GMT

Yeah, I can't seem to batch it either.

Re: ArcGIS Pro: batch table to excel result in single result

RamonWilliams — Mon, 18 Nov 2024 13:45:19 GMT

you can do it by using the tool in a model builder.