JSON Formatting in ArcGIS for Excel

Question

Hi, I am trying to create line features with the ArcGIS for Excel extension, from a JSON file I have exported from ArcGIS Pro. With reference to the screenshots attached, can anyone advise how I need to reformat the JSON (using power query editor or other means) in order for ArcGIS for Excel to recognise the JSON geometry?

Many Thanks,

Andrew

MJB62 · Answer

Not able to find the connector for Power Automate to format the JSON in Power Query. I'm new to Power Query, and very little experience with JSON. Spent a couple of days searching the ESRI website and other web searches and have no idea how to bring the JSON data into Excel. Would ne grateful for any advise.

Yuchen111 · Answer

Thank you SOOO much! This solves a long time puzzle for me and helps me a lot!

Gaurav-Singh · Answer

Attached EsriJSON sample datasets (points, polygons, and polylines) that works with ArcGIS for Excel. Hope it helps.

You may use the ArcGIS Pro tool 'Feature to JSON' to convert features to Esri JSON format - https://pro.arcgis.com/en/pro-app/3.1/tool-reference/conversion/features-to-json.htm

EsriJSON_sampledata_ArcGISforExcel.xlsx