JSON Exporter for Excel

Lately we’ve been using JSON as our text-based interchange format of choice internally. While most of our tools are internal and save this data in a way that’s invisible to the user, we still do work with a lot of external tools. For better or worse one of those tools is Excel.  Giac Veltri (Engine Programmer) has put together a JSON exporter for Excel and short presentation that give a bit of background on the plugin. This plugin might not do exactly what you want, but it could be a good place to start if you’re also looking to export JSON from Excel.
Included here are Giac’s Excel plugins for Excel 2007 (xlam) and Excel 97-2003 (xla) and sample data and the generated JSON.
Have fun!
 
 
  • Yellow Ant

    Hi there,

    I’d love to try this, looks like exactly what I’m after. Link though is an old on-working version, apparently there is an updated version from 15th Aug posted on macton.posterous but to an externally inaccessible file /assets/files/128111437569259.zip any chance of updating this link to the working version.

    thanks heaps