Web App (JSON-to-Excel Web App)

中文

JSON-to-Excel by WTSolutions is a toolkit of tools which can convert JSON to Excel, both Flat and Nested JSON can be converted to Excel. It offers a full-scenario solution for “Converting JSON to Excel”, including Excel add-ins, WPS add-ins, web applications, API service and MCP service.

Requirements

  • A web browser that supports JavaScript, such as Google Chrome, Mozilla Firefox, Safari, or Microsoft Edge etc.

  • A browser works on Windows, Mac, Linux, Android, iOS, etc.

Access

Usage

  • Prepare your JSON data

  • In the Conversion Settings, select conversion mode etc.

  • Load your JSON data (Choose one of the following two ways)

    1. Copy and Paste your JSON data in the text area, or

    2. Click on the Load JSON File(s) file selector, and select your JSON file(s) from your local computer, for batch processing , max 20 files can be loaded at once.

  • Click on Go button

  • Your JSON data will be converted to Excel, and you can find a preview Excel appear at the bottom of the page.

  • You can click on Download button to download the Excel file.

JSON Data and Conversion Settings

Refer to JSON Data and Conversion Settings for more details.

Limitations

  • Maximum 1000 objects (rows) per conversion

  • Maximum 100 unique properties (columns) per dataset

  • Arrays in values will be converted to strings in Excel

  • Maximum 20 loaded local JSON files can be converted at once