Community

ArcGIS Pro: batch table to excel result in single result

1980
1
06-26-2020 04:05 AM
Alexandra_Luisa_HøjgaardWood
by
New Contributor II
‎06-26-2020 04:05 AM

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?

0 Kudos
1 Reply
DrewFlater
by Esri Regular Contributor
Esri Regular Contributor
‎06-26-2020 05:15 PM

Hi Alexandra Luisa Højgaard Wood‌ 

I followed these steps and it worked for me:

  1. Right-click the Table To Excel tool
  2. Select Batch
  3. Leave all the defaults on the batch page and click Next
  4. Pick several layers/tables from my map to convert, in the Batch Input Table parameter
  5. 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)
  6. Click Run

Produced these 6 excel files