JSON Formatting in ArcGIS for Excel

[AndrewFaulkner]

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

[Anonymous User]

Hello!

It maybe that the geometry isn't getting formatted properly as it imports into Excel. We have a connector now for Power Automate that will properly format the JSON so that you do not have to perform any gymnastics in Power Query. 

https://www.esri.com/arcgis-blog/products/power-bi/announcements/arcgis-connectors-in-power-automate...

If you have the time, I'd love to discuss your workflows to see if theres anything else we can do to support you. Feel free to DM me your contact info so we can connect.

Cheers,

Andrew

[AshmithaNihar]

Can You help me with the same. I have to import a json file and view the geometry in excel. I'm stuck quiet from the beginning. Please help me

[Yuchen111]

Hi!

Thanks for introducing power automate to us. 

Could you please just show us maybe a screenshot of a properly formatted geometry in excel? Since currently I'm only focusing on solving my problem via excel.

So far I believe I share the same question as Andrew does. If I didn't guess wrong, I think what we want is an example of a correctly & properly formatted column (or a couple of columns) in Excel that can be recgonised by Arcgis for Excel to show features like lines and polygons in the map. 

We don't have trouble dealing with points simply because a pair of lng-lat coordinates are valid enough to visualise its location.  But in case of lines and polygons, it's not enough anymore, which leads us to try geojson file instead.

Thank you!

Yuchen

[MJB62]

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.

[Gaurav-Singh]

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

[Yuchen111]

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