JSON exports

This may not be answerable by the community, but we have a work problem. Our department has been using an on-line kandam board for a number of years to manage projects and workflow, but our IT department has suddenly blocked access (and won't unblock access) on the grounds that we have to use MS Planner instead of an off-site 3rd party application.

Unfortunately, we only have the free access, and the only way to export data is via JSON.

Does anyone have tips on converting the JSON export into a sensible (and readable) format? My 2 boards will probably end up in Excel (one I will need to do the year-end analysis next month); I don't know what the rest of the department will use (comments on Planner range from 'not suitable for our needs' and go down from there).

Maybe.

I guess you were using something like Trello as a Kanban board. Json is normally pretty readable although not normally very well structured for importing into Excel.

You could look at https://json-csv.com/ but be aware that there are likely to be quite a number of columns you are not interested in.

I have never used either of those products, so take this with the suitable quantity of sodium chloride.

It looks as though Planner is able to import JSON from Trello, so if that's the tool you're using, you may be in luck. Once it's in Planner you can probably get it from there into CSV/XLS.

andyl's proposed solution should work if the JSON is simple enough (not a lot of nesting or of columns containing lists, etc.) but not having used the product I don't know if that's the case here.

It is indeed Trello we've been using - the problem is that most of us are blocked from the site. We've also only been using the free version.

I will talk to those people who still have access.

>2 andyl: I've already looked at that site and played around with the outputs.