json2xls

Costas

Administrator
Staff member
Tiny application which converts a JSON array to datagridview with export to excel functionality. Inspired by http://www.json-xls.com/json2xls and timeouts on big files :)

snap164.png


Platform : C# 2012
Operating System : Windows
windows1.gif
2000 /
windows1.gif
XP /
windows1.gif
2003 /
windows1.gif
Vista /
windows1.gif
win7 (32bit)
Requirements : v4.7.2 .NET framework
Filesize : 360kb

Download

v1.4.0
+full distro of Newtonsoft.Json.dll used (merged to executable)

v1.3.1
+support nested tables
+grid selection mode is adjustable
+column resize is adjustable
+export as csv
+support rows in array without equal fields
*excel export optimization

v1.2
+nested array on grid, when double clicked converted to columns

v1.1
+user can execute SQL against JSON Array!


you can try also google sheet json import plugin

and JMESPath is a query language for JSON
and .net lib LitJSON
and Transform a CSV into a JSON and vice versa

or Excel 2016/365
hsNRlC6.jpeg
 
Top