topic Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel? in Python Questions

Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

ThomasColton — Mon, 05 Jun 2017 13:57:25 GMT

I am very new to ArcGIS and am very unfamiliar with the process of using Python.

How can I export several selected features from more than one layer into Excel?

I want to be able to lasso select an area or select by location and be able to export every selected row from their various attribute tables into either one large list on Excel or into separated lists for further data processing in Excel

(I am working on stormwater network retrofits and want to be able to rapidly assess approximate costs of different project areas by selecting all features within a certain area, export to excel where I plan to use formulas to determine lengths of pipe widths, areas of sidewalk replacement, numbers of affected utility poles, etc.)

Altogether, how can I export selected items from multiple attribute tables to Excel rapidly?

If there is a way to do this using Modelbuilder, that would be awesome too.

Thank you so very much for your help.

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

KevinHibma — Mon, 05 Jun 2017 14:24:40 GMT

There are many different ways to accomplish this. You can use Python, or Modelbuilder or just run tools individually. I'd personally go about it in this way (running the tools one at a time unless you need to turn this into some sort of automated process):

Select you features
Run Merge with those features into a new featureclass
- Note that you need all the same feature type (poly, point, line) to run merge
Run Table to Excel from that new featureclass to get your excel

If you dont have the same feature type, you can:

Select your features
run Copy Rows (this will generate a table of the selected attributes)
Run Append or Merge to combine all the tables
Run Table to Excel

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

ThomasColton — Mon, 05 Jun 2017 14:34:43 GMT

This seems like it should work, thank you.

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

ThomasColton — Mon, 05 Jun 2017 17:33:59 GMT

How do I make it work such that only the selected features are copied and not all of the features within a given layer?

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

KevinHibma — Mon, 05 Jun 2017 17:45:45 GMT

Thomas,

The tools honor the selection. If you're inside ArcMap with a selection and run Merge, only the selected features are copied over.

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

ThomasColton — Tue, 06 Jun 2017 13:58:06 GMT

I'm sorry, you are correct. I misspoke, is there any way that only the selected records can be copied over instead of the full attribute table.

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

KevinHibma — Tue, 06 Jun 2017 14:13:16 GMT

Do you mean something like - your featureclass has the following fields: A, B, C, D, E but you only want to copy C, D, E into your final output?

Then, yes, absolutely. See the "Field Map" parameter for both the Merge and Append tool. That control allows you to control what field from the source inputs get created/copied into the output featureclass.

Re: Rapidly Export Multiple Selected Features from Multiple Layers into Excel?

GrahamW — Wed, 13 Jun 2018 02:00:41 GMT

The Water Utilities Editing tools comes with a quick export to Excel tool.

It's simple to use: select many features from many feature classes, press the button and they appear in excel on individual tabs.(coded values come across as the full descriptions)

Documentation | ArcGIS for Water