table to excel

130
4
01-12-2018 02:43 AM
Highlighted
New Contributor II

Hello,

is there a possibility to export different tables to the same excel-file?

with the tool "table to excel" the excel-file is overwriten when you try to export a different table into the same excel-file. Is there a possibility to save the new table in a new sheet of the same table?

Regards

Felix

Tags (1)
Reply
0 Kudos
4 Replies
Highlighted
Regular Contributor II
Reply
0 Kudos
Highlighted
Regular Contributor II

If you are using any database other than a GDB, you can open up MS Access, connect to the tables you wish and export easily to one excel file from any number of tables or views.....

Vote here to keep this extremely flexible and useful tool !

 Enable ArcGIS Pro to access ESRI Personal Geodatabases

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

With the standard tools available you will create a sheet in a Excel file and you won't be able to do this. If you have knowlegde of Python you can do this. See for instance: python - creating multiple excel worksheets using data in a pandas dataframe - Stack Overflow 

Reply
0 Kudos
Highlighted
New Contributor II

Thank you for your help, i will see if i can use one of these things.

Reply
0 Kudos