Viewer for XLSX, JSON, XML REST responses or files as HTML table with detection nested columns and tables
JSON -> TABLE Extension
lite PostMan to debug REST backends or generate simple reports
HOT explore data as table: filter, sort and export desired data, send requests
install and just open DEMO urls:
https://api.github.com/repositories/19438/commits
https://www.w3schools.com/xml/plant_catalog.xml
!!! for new browsers version - if you have an issue with large JSON data - disable embedded in browser formater: add to chrome command line this argument:
--disable-features=PrettyPrintJSONDocument
NEW Features:
- row numbers, xml view fixes, install fixes
- Options
- use IndexedDB to store temporary data
- Report style
- Ctrl-Q works like Alt-TAB between Chrome TABs
Features:
- view 'application/json' response data or file as HTML table with embeded tables
- HOT on fly CSV and XLSX files can be viewed
- table filtering(mongo style allowed and embeded tables), sorting, export, totals, grouping(with totals for numeric columns), removing columns
- virtual scrolling(huge files is not problem), viewing in New window
- url query parameters parser/form editor with template(see below)
- send a JSON/FormData/urlencoded/XML requests (POST, PUT, DELETE, PATCH, GET) with headers
- scan Page TAB for XHRs and shows it on icon and opens it in PopUp
- table skins and formatting template
{
$$format: { field0: \"show {$field1} like this\" },
$$form: {
check: { value: true, type:'checkbox' },
date2: { type: 'date', label:\"end Date\"},
type: { value: 2, options: ['1', '2'], required:1},
'multi[]': { value: [22,33], options: ['11', '22', '33'], required:1},
},
...data
}
used libraries xlsx, xml2js, mongo-parse, jsoneditor, file-saver
Read more
HOT explore data as table: filter, sort and export desired data, send requests
install and just open DEMO urls:
https://api.github.com/repositories/19438/commits
https://www.w3schools.com/xml/plant_catalog.xml
!!! for new browsers version - if you have an issue with large JSON data - disable embedded in browser formater: add to chrome command line this argument:
--disable-features=PrettyPrintJSONDocument
NEW Features:
- row numbers, xml view fixes, install fixes
- Options
- use IndexedDB to store temporary data
- Report style
- Ctrl-Q works like Alt-TAB between Chrome TABs
Features:
- view 'application/json' response data or file as HTML table with embeded tables
- HOT on fly CSV and XLSX files can be viewed
- table filtering(mongo style allowed and embeded tables), sorting, export, totals, grouping(with totals for numeric columns), removing columns
- virtual scrolling(huge files is not problem), viewing in New window
- url query parameters parser/form editor with template(see below)
- send a JSON/FormData/urlencoded/XML requests (POST, PUT, DELETE, PATCH, GET) with headers
- scan Page TAB for XHRs and shows it on icon and opens it in PopUp
- table skins and formatting template
{
$$format: { field0: \"show {$field1} like this\" },
$$form: {
check: { value: true, type:'checkbox' },
date2: { type: 'date', label:\"end Date\"},
type: { value: 2, options: ['1', '2'], required:1},
'multi[]': { value: [22,33], options: ['11', '22', '33'], required:1},
},
...data
}
used libraries xlsx, xml2js, mongo-parse, jsoneditor, file-saver
Source Manifest.json
{"update_url": "https://clients2.google.com/service/update2/crx", "name": "JSON -> TABLE", "description": "Viewer for XLSX, JSON, XML REST responses or files as HTML table with detection nested columns and tables", "version": "1.39", "manifest_version": 3, "permissions": [ "webRequest", "storage", "scripting" ], "host_permissions": [ "" ], "background": { "service_worker": "background.js" }, "commands": { "recent-tab": { "description": "Switch between Recent Tabs", "suggested_key": { "chromeos": "Ctrl+Q", "default": "Ctrl+Q", "linux": "Ctrl+Q", "mac": "Command+Q", "windows": "Ctrl+Q" } } }, "action": { "default_popup": "popup.html" }, "icons": { "128": "json128.png" }, "offline_enabled": true, "web_accessible_resources": [ { "resources": ["images/*", "json128.png", "libs/*"], "matches": [""] } ], "options_page": "options.html", "content_scripts": [ { "matches": [""], "css": ["contents.css", "dropdown.css", "libs/jsoneditor/jsoneditor.min.css", "skins.css"], "all_frames": true, "match_about_blank": true, "js": [ "options.js", "store.js", "contents.js" ], "run_at": "document_start" } ]}
Read more