How to import data in XML file into ArcGIS Pro

[CVCJ]

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-su...

[BSBlagojevic]

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

[CVCJ]

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

[BobBooth1 · Accepted solution]

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

[CVCJ]

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