topic Re: Export selected features from multiple layers to excel at the same time in ArcGIS Pro Questions

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

ATong — Tue, 25 Feb 2025 16:34:03 GMT

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!

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

DanPatterson — Tue, 25 Feb 2025 16:56:13 GMT

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

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

Bud — Tue, 25 Feb 2025 17:03:30 GMT

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.

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

ATong — Tue, 25 Feb 2025 19:29:35 GMT

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.

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

DanPatterson — Tue, 25 Feb 2025 20:09:48 GMT

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

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

RhettZufelt — Tue, 25 Feb 2025 22:49:04 GMT

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.

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

Bud — Tue, 25 Feb 2025 23:18:37 GMT

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.

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

jyh — Thu, 27 Feb 2025 15:59:49 GMT

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

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

ATong — Mon, 03 Mar 2025 13:48:58 GMT

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!