Select to view content in your preferred language

table to excel

553
4
01-12-2018 02:43 AM
FelixBuchinger
Emerging Contributor

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)
0 Kudos
4 Replies
AbdullahAnter
Honored Contributor
0 Kudos
TedKowal
Honored Contributor

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

0 Kudos
XanderBakker
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 

0 Kudos
FelixBuchinger
Emerging Contributor

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

0 Kudos