How to: convert XML or JSON into spreadsheets using Open Refine

[Image and caption from original post] The Food Standards API has a series of links to XML files with the latest food hygiene data.

[Image and caption from original post] The Food Standards API has a series of links to XML files with the latest food hygiene data.

Paul Bradshaw explains how to convert XML or JSON into spreadsheets using Open Refine for data cleaning:

One of the most useful applications of the data cleaning tool Open Refine (formerly Google Refine) is converting XML and JSON files into spreadsheets that you can interrogate in Excel.

Banner image Curly brackets pattern by Dan McCullough licenced under CC by 2.0