https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idi-p/1698762 <P>I work in Transportation, and I would like to be able to add layers to my maps using geographic data that is filtered by fields in my excel sheet. This would simplify my project tracker and allow for easier updating and expansion of my tracker.</P><P>My project tracker uses the project's roadway segment number and matches it to the segments in the hosted feature layer provided by my organization at a 1 to 1 relation. The problem occurs when a project is across multiple segments or subsegments, resulting in the visualization only showing part of the project. Being able to see all features/roadway segments matching my project number would eliminate extra rows in my project tracker and simplify the process of adding new projects that cover multiple segments.</P><P>Images below: The green line shows the layer mapped from excel through geographic data. The red shows the actual project extent which I made in ArcGIS Pro just to compare.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrandonDrawhorn_2-1777388717524.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/151677iD08D4E00250722D0/image-size/medium?v=v2&amp;px=400" role="button" title="BrandonDrawhorn_2-1777388717524.png" alt="BrandonDrawhorn_2-1777388717524.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">BrandonDrawhorn_2-1777388717524.png</span></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrandonDrawhorn_3-1777388726013.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/151678iE901BC776815405E/image-size/medium?v=v2&amp;px=400" role="button" title="BrandonDrawhorn_3-1777388726013.png" alt="BrandonDrawhorn_3-1777388726013.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">BrandonDrawhorn_3-1777388726013.png</span></span></P><P>&nbsp;</P><P>Note: The layer seems to get confused when there are multiple matches and will show different segments, somewhat randomly at different elevations. Exporting the layer in this case results in partial data being exported.</P> Tue, 28 Apr 2026 15:14:17 GMT BrandonDrawhorn 2026-04-28T15:14:17Z https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idi-p/1698762 <P>I work in Transportation, and I would like to be able to add layers to my maps using geographic data that is filtered by fields in my excel sheet. This would simplify my project tracker and allow for easier updating and expansion of my tracker.</P><P>My project tracker uses the project's roadway segment number and matches it to the segments in the hosted feature layer provided by my organization at a 1 to 1 relation. The problem occurs when a project is across multiple segments or subsegments, resulting in the visualization only showing part of the project. Being able to see all features/roadway segments matching my project number would eliminate extra rows in my project tracker and simplify the process of adding new projects that cover multiple segments.</P><P>Images below: The green line shows the layer mapped from excel through geographic data. The red shows the actual project extent which I made in ArcGIS Pro just to compare.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrandonDrawhorn_2-1777388717524.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/151677iD08D4E00250722D0/image-size/medium?v=v2&amp;px=400" role="button" title="BrandonDrawhorn_2-1777388717524.png" alt="BrandonDrawhorn_2-1777388717524.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">BrandonDrawhorn_2-1777388717524.png</span></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrandonDrawhorn_3-1777388726013.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/151678iE901BC776815405E/image-size/medium?v=v2&amp;px=400" role="button" title="BrandonDrawhorn_3-1777388726013.png" alt="BrandonDrawhorn_3-1777388726013.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">BrandonDrawhorn_3-1777388726013.png</span></span></P><P>&nbsp;</P><P>Note: The layer seems to get confused when there are multiple matches and will show different segments, somewhat randomly at different elevations. Exporting the layer in this case results in partial data being exported.</P> Tue, 28 Apr 2026 15:14:17 GMT https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idi-p/1698762 BrandonDrawhorn 2026-04-28T15:14:17Z https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1699639#M84 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/984852">@BrandonDrawhorn</a>&nbsp;Hey there! Thank you for sharing! These user cases are so insightful and help us develop and improve the software. I would like to be able to research this further. Are you able to share a sample of your dataset?</P><P>All the best,</P><P>SC</P> Fri, 01 May 2026 18:29:39 GMT https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1699639#M84 ShannonCardoza 2026-05-01T18:29:39Z https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1700439#M85 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/228863">@ShannonCardoza</a>&nbsp;I DMed you some sample data: my project tracker Excel and a lyrx.</P> Wed, 06 May 2026 18:18:22 GMT https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1700439#M85 BrandonDrawhorn 2026-05-06T18:18:22Z https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1700964#M86 <P>Thank you&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/984852">@BrandonDrawhorn</a>&nbsp;I will be touch!</P> Fri, 08 May 2026 18:10:15 GMT https://community.esri.com/t5/arcgis-for-excel-ideas/add-layers-by-filtering-geographic-data-with-excel/idc-p/1700964#M86 ShannonCardoza 2026-05-08T18:10:15Z