topic Re: How to import data in XML file into ArcGIS Pro in ArcGIS Pro Questions

How to import data in XML file into ArcGIS Pro

CVCJ — Thu, 27 Feb 2025 17:06:27 GMT

Hi,

I'm building a map of facilities in Eastbourne and have found some open data from Data.gov.uk with the locations of schools from East Sussex County Council. I'd like to import this to my map, but the only format available is XML and I can't find a way to get this into ArcGIS Pro. Can anyone help me please? There are other datasets in this format too so I need to work out a solution!

Thank you

This is a screenshot of the webpage. Address is

Schools in East Sussex -https://www.data.gov.uk/dataset/e20e6581-1da4-46bb-94e8-bab86cd0e165/east-sussex-county-council-schools data.gov.uk

Re: How to import data in XML file into ArcGIS Pro

BSBlagojevic — Thu, 27 Feb 2025 18:53:14 GMT

Use ext. Data Interoperability and import .xml data to gdB.

Re: How to import data in XML file into ArcGIS Pro

BobBooth1 — Thu, 27 Feb 2025 20:11:02 GMT

You might try an XML to CSV converter, the take the output CSV file and use XY table to Point in ArcGIS Pro to make points.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/xy-table-to-point.htm

Re: How to import data in XML file into ArcGIS Pro

CVCJ — Fri, 28 Feb 2025 15:47:16 GMT

Thanks, I found this tool which seems really good. The file is actually a JSON array it seems and I managed to save it as a csv.

Convert JSON Array to CSV Online - Table Convert Online

Re: How to import data in XML file into ArcGIS Pro

CVCJ — Fri, 28 Feb 2025 15:47:59 GMT

Thanks, I think that might be a bit too much for our budget but I'll keep it in mind.