qw569😳

I already forgot VBA
You can parse ItemTemplates_cleanopenworldprodeu1.json to csv with commandline utilites jq and import to excel
I suppose you use Windows.
The most usefull commandline utilites such as curl and sed is absent.
Download curl (https://curl.haxx.se/download.html) Download sed and dependencies (http://gnuwin32.sourceforge.net/packages/sed.htm) Download jq (https://stedolan.github.io/jq/) And now command line kung fu curl http://storage.googleapis.com/nacleanopenworldprodshards/ItemTemplates_cleanopenworldprodeu1.json | sed "s/^.\{20\}//" | sed "s/.\{1\}$//" | jq-win64 -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.MaxSpeed,.Specs.SpeedToWind[],.HealthInfo.LeftArmor,.HealthInfo.FrontArmor,.HealthInfo.BackArmor,.HealthInfo.InternalStructure,.HealthInfo.Sails]|@csv"  >stats.csv You can skip steps 1-2.
Then you must download ItemTemplates_cleanopenworldprodeu1.json Delete "var ItemTemplates = " in the begining and ";" in the end of file ItemTemplates_cleanopenworldprodeu1.json. Save new file as 1.json jq-win64 -r ".[]|select(.ShipTemplateName!= null)|[.ShipTemplateName,.Specs.MaxSpeed,.Specs.SpeedToWind[],.HealthInfo.LeftArmor,.HealthInfo.FrontArmor,.HealthInfo.BackArmor,.HealthInfo.InternalStructure,.HealthInfo.Sails]|@csv"  1.json >stats.csv And we get file stats.csv