Export selected features from multiple layers to excel at the same time

[ATong]

I know how to export selected features from a table to excel in multiple ways. However, I would like to make a multilayered selection and export all selected features from multiple tables out to excel at the Same Time.

I would like to do this Without Merging features because my datasets are vast (takes hours to cycle through all layers within my map doc).  I am working with my group's base map so I can not change how it is setup but I am tasked to review about 30 layers with polygon and point data for the same specified area. Doing this manually each time takes a lot of time.

My goal is to reduce the amount of time it takes to output these selected features. The export can be in multiple tabs or reach out as a wide excel sheet, but it would be ideal to be in the same document, so as not have to open up 30 excel docs and combine them defeating the timeliness goal.

Thanks!

[DanPatterson]

coding or modelbuilder would be the first suggestion since you seem to have a workflow

but

Is this something that you have to do hourly? daily? every month?

Is there a wide spread use for this?

the effort expended in developing the code might have to be weighed against the above

[ATong]

It has to be done on a weekly basis. If I can save time by doing this a lot of people I work with would be pretty happy.

[DanPatterson]

I would start with modelbuilder to see if you can get part of your workflow done.  You can create submodels then tie them together.

Simle things like

Iterate Tables (ModelBuilder)—ArcGIS Pro | Documentation

can be added if you have your spreadsheets organized

[Bud]

I imagine this question will be moved by a mod to the ArcGIS Pro Questions community.

You could also consider creating an ArcGIS Pro Idea. Do you want to choose the layers by selecting them in the Contents pane? Or do you want a geoprocessing tool with a list of layers as checkboxes? If you want a geoprocessing tool, you might be able to set up a batch operation. I don't have any experience with using GP tools in batch mode, but someone else might be able to weigh in or you could look it up.

Somewhat related: Export table to existing Excel file instead of creating new file

[RhettZufelt]

You didn't say what format the data is in, or what 'type' of selections you are making.

But, I have some people that want a table with all the attributes from several feature class layers features that have been added in the last month.

So, since my data is in SQL Server, I just connected several workbooks in an Excel spreadsheet to the SQL tables for the feature classes I need.  Then, put custom filter on each table that only shows values for the next month.

Then, all they have to do is open the Excel spreadsheet to refresh the data, and look at the worksheets as needed.

So, if your data is Enterprise, and your selections are by code (not manual), this could be a potential solution for you.

R_

[Bud]

I do the same. In Excel, in a worksheet, I use an ODBC connection to bring in data from a table/FC in the Oracle enterprise geodatabase, using Microsoft Query or Excel Power Query. I hit the refresh button in Excel to refresh the data or set up the connection so that the data refreshes when I open the Excel workbook.

[ATong]

Thanks, good suggestions. However, due to security reasons, which don't completely make sense. I am not allowed direct access to the data through proper database software/interfaces beyond Arc products. I could go on about that for hours but that is my situation working with the various groups supplying the data. So, data processing or extraction must be done through ArcPro or ArcMap currently which gives the permissions to use the data that is being pulled.  Data Interoperability extension is an option I haven't tried yet. Will get back with results. Thanks!

[jyh]

Have you looked at the new tool that does the same job as the old ArcMap Extract Data Wizard?  Extract Data From Geodatabase (Data Management)—ArcGIS Pro | Documentation