Import JSON to Excel

gjacobse

I have a JSON database file that I need to import into Excel

Not having dealt with JSON before,... has anyone else encountered this?

DustinB3403

thwr

@gjacobse multiple possible approaches. Write a COM+-wrapper for JSON.NET to use that component directly in Excel, write a JSON-parser in VBA (would be PITA) or write a small app in a language of your choice with a JSON library of your choice.

gjacobse

@thwr said in Import JSON to Excel:

@gjacobse multiple possible approaches. Write a COM+-wrapper for JSON.NET to use that component directly in Excel, write a JSON-parser in VBA (would be PITA) or write a small app in a language of your choice with a JSON library of your choice.

Yea,.. about that. I don't code.

gjacobse

@DustinB3403 said in Import JSON to Excel:

http://konklone.io/json/

Data I have is about 3MB, to much for the browser conversion.

thwr

Mh, would be a 15 minute job. Anyway, can't you split the file into multiple chunks?