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.
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):
If you dont have the same feature type, you can:
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.
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)