JSON-stat, CSV-stat and Excel

[Xavier Badosa]

Importing a JSON-stat dataset already has a web-based solution (https://jsonstat.com/excel/), that can use VBA + Power Query to enrich the export.

There was a lack of solutions based on CSV-stat. CSV-stat is a CSV-based format that, unlike similar solutions (Frictionless Data Package or CSVW), requires a single file (it's a enriched CSV format that includes some metadata). There are several tools (CLI, NodeJS, browser) to create CSV-stat from JSON-stat (jsonstat-conv, jsonstat-io, jsonstat-suite).

https://github.com/jsonstat/csv#conversion-tools

I have added a section on "Importing CSV-stat into Excel"

https://github.com/jsonstat/csv#importing-csv-stat-into-excel

You only need to create an Excel Workbook with a set of fixed Power Queries plus a customizable Power Query (FilePath.pq) where you only need to set the name of the CSV-stat file you want to import. 

https://github.com/jsonstat/csv/tree/master/pq

The same template can be applied to any CSV-stat just by changing a parameter value in FilePath.

All the details at:

https://github.com/jsonstat/csv

Xavier