json2xlsx
Extract specified field data from json to xlsx/csv
Used to select fields from JSON / JSONL / NDJSON data, preview tables, and export XLSX or CSV. Support uploading.json / .jsonl / .ndjson / .txt files. Supports directly pasting JSON text; uploading files takes precedence over pasting text. When the input file or paste content changes, the selected fields, candidate check-ins and export cache related to the previous JSON will be cleared immediately to avoid the use of old and new data. Supports JSON tree browsing, and converts array subscripts to [*] by default, making it easy to extract the entire set of array data. Support fast path location. For example,$. data.fst.0.name will be automatically normalized to $.data.fst[0].name. The "Field Candidate" form supports: Check the field in the check box and synchronize the selected status with the JSON tree; Double-click the "Field Path" cell to quickly add; Filter by path, type, or sample value within the candidate table. Support editing output column names, mouse dragging to adjust field order, and canceling selected fields. Support form preview. Support exporting XLSX / CSV; automatic mode takes precedence over XLSX, and automatically switches to CSV when Excel column limits or configured cell thresholds are exceeded.




