topic Re: Extracting Multiple Layers as Single Excel file in ArcGIS Online Questions

Extracting Multiple Layers as Single Excel file

BradLambert — Thu, 09 Nov 2023 03:17:44 GMT

I have collected some data from a bird survey that has multiple layers (one for each bird species). The data is collected via Quick Capture and now i want to extract the data so that i can analyse areas for biodiversity value. Unfortunately when I extract the data it does so by creating an individual file for each layer. I dont want to manual copy and paste the data from each file into a single file for analysis.

Is there a way to extract multiple layers as a single Excel or CSV file?

I have possibly set this up the wrong way but the map works really well!

Re: Extracting Multiple Layers as Single Excel file

JonathanNowlan — Thu, 09 Nov 2023 11:50:54 GMT

Hey Brad,

If your feature layer is configured with multiple layers you will receive individual files for each layer when you export them.

You could explore using the Append tool in ArcGIS Pro to merge them together.

If you repeat this field work again, an alternative approach would be to use one feature layer and create a bird type field. You can use that bird type field to generate different buttons in Workforce. Then all your data will be in one layer rather than multiple.