Spreadsheets

Many people find it useful to load these APIs in spreadsheets such as Microsoft Excel or Google Sheets. There is no single best way to do this, but some of the common ways are as follows:

  • Excel Power Query
  • Google Sheets IMPORTXML
    • Example: =IMPORTXML("https://west.albion-online-data.com/api/v2/stats/prices/T4_BAG.xml?locations=Caerleon&qualities=2","//ArrayOfMarketResponse/MarketResponse")
  • Google Sheets ImportJSON (third-party script)
    • Note: Some people have noticed issues with ImportJSON and repeating rows
    • Example: =ImportJSON("https://west.albion-online-data.com/api/v2/stats/prices/T4_BAG.json?locations=Caerleon&qualities=2", "", "noHeaders")