[okfn-labs] JSON to CSV converter

Tue Mar 11 21:40:46 UTC 2014

It recursively flattens nested objects and arrays into a tabular form, and
tries to guess at which array should decide what the "rows" should be. It's
a pretty simple algorithm, and there's no right answer, so it doesn't
handle everything.

But you can see it flattening stuff successfully here, for example:
http://konklone.io/json/?id=9341620

On Tue, Mar 11, 2014 at 5:02 PM, Alvaro Graves <alvaro at graves.cl> wrote:

> Hi Eric,
>
> Thanks for the tool. I'm wondering if do you plan to deal (and how) with
> more complex JSON files (nested objects, arrays, etc.)?
>
> Alvaro Graves-Fuenzalida, PhD
> Web: http://graves.cl - Twitter: @alvarograves
>
>
> On Tue, Mar 11, 2014 at 1:51 PM, Eric Mill <eric at sunlightfoundation.com>wrote:
>
>> Hey all,
>>
>> I made an in-browser JSON->CSV converter to support a workshop at Open
>> Data Day <http://dc.opendataday.org/> here in DC, and it turned out
>> pretty well:
>> http://konklone.io/json/
>>
>> I also added some pretty rendering for JSON and the resulting CSV, and
>> let you make permalinks to specific data, like this data on votes<http://konklone.io/json/?id=9478398>
>> .
>>
>> Finally, I wrote a blog post today for Sunlight about how it works,
>> encouraging anyone to dig into JSON:
>>
>> http://sunlightfoundation.com/blog/2014/03/11/making-json-as-simple-as-a-spreadsheet/
>>
>> Hope it's useful for people!
>>
>> -- Eric
>>
>> --
>> Developer | sunlightfoundation.com
>>
>> _______________________________________________
>> okfn-labs mailing list
>> okfn-labs at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/okfn-labs
>> Unsubscribe: https://lists.okfn.org/mailman/options/okfn-labs
>>
>>
>

-- 
Developer | sunlightfoundation.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/okfn-labs/attachments/20140311/9f001ec2/attachment-0004.html>