cia_world_factbook_api icon indicating copy to clipboard operation
cia_world_factbook_api copied to clipboard

JSON to CSV

Open gts26832 opened this issue 4 years ago • 3 comments

Greetings Ian,

Great work!

Was wondering if there's a simple way to convert the most recently updated json file to csv? I seem to have trouble converting the file using typical json-csv converters online. Do you have a recommended converter or method to do so? Main objective is to analyze the json file in excel.

Any help would be much appreciated sir.

gts26832 avatar Dec 11 '19 22:12 gts26832

This might be useful:

https://iancoleman.io/explorer-cia-world-factbook/

iancoleman avatar Dec 12 '19 04:12 iancoleman

Thank you for the prompt response!

Is there a "select all" button for the "change columns" section? Does the internet browser make a difference? I can't seem to find one.

Any help is much appreciated.

gts26832 avatar Dec 12 '19 15:12 gts26832

Sorry there's no select all button.

I had a look for some tools to do it but nothing came up.

Might be a good feature to have, a csv version as well as a json version.

iancoleman avatar Dec 18 '19 01:12 iancoleman