Convert JSON to Excel
Convert → Convert JSON to Excel
The Convert JSON to Excel API turns JSON into an Excel spreadsheet. You send the JSON as Base64 (docContent), docName, worksheetName, isTitleWrapText, isTitleBold, convertNumberAndDate, numberFormat, dateFormat, ignoreNullValues, firstRow, firstColumn, and IsAsync. The API returns the Excel file (or 202 + Location for async). Use the tester below to try it; more details are in the sections that follow.
Try the Convert JSON to Excel API
Endpoint: POST /api/v2/ConvertJsonToExcel · Required: api-key, docContent, docName, worksheetName, isTitleWrapText, isTitleBold, convertNumberAndDate, numberFormat, dateFormat, ignoreNullValues, firstRow, firstColumn, IsAsync
Use the form below to send your API key and JSON (Base64). Set worksheet name, formatting, number/date options, and start row/column; the response is the Excel file (or polling URL when async). No code required—fill the fields and click Send request.
Overview, parameters, and use cases
- Overview
- Parameters
- Use cases
What is Convert JSON to Excel?
This endpoint converts JSON data into an Excel spreadsheet. You provide the JSON (Base64), docName, worksheetName, isTitleWrapText, isTitleBold, convertNumberAndDate, numberFormat, dateFormat, ignoreNullValues, firstRow, firstColumn, and IsAsync. The API returns the Excel file or a Location URL for async.
Key features
- Worksheet – worksheetName, firstRow, firstColumn for placement.
- Formatting – isTitleWrapText, isTitleBold; numberFormat, dateFormat; ignoreNullValues.
- Async – IsAsync returns 202 with Location URL for polling.
Use when you need Excel from JSON (API data, exports). For PDF tables use Convert PDF to Excel.
API parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| api-key | string | Yes | Your PDF4me API key, Base64 encoded. Get it from the dashboard. |
| docContent | base64 | Yes | Base64 encoded JSON content. |
| docName | string | Yes | Output file name (e.g. output). |
| worksheetName | string | Yes | Excel worksheet name (e.g. Sheet1). |
| isTitleWrapText, isTitleBold | boolean | Yes | Wrap text in title cells; bold title row. |
| convertNumberAndDate | boolean | Yes | Auto-convert numbers and dates. |
| numberFormat, dateFormat | string | Yes | Number format code; date format pattern. |
| ignoreNullValues | boolean | Yes | Ignore null values. |
| firstRow, firstColumn | integer | Yes | Starting row and column (1-based). |
| IsAsync | boolean | Yes | Enable asynchronous processing. |
When to use Convert JSON to Excel
- API data – Convert JSON API responses to Excel.
- Exports – Turn JSON exports into spreadsheets for analysis.
- Pipelines – Use JSON as source for Excel reports or dashboards.
For request/response schemas and code samples, see Convert JSON to Excel in the PDF4me API docs.
Prerequisites
Before using this endpoint, make sure you have:
- A valid PDF4me API key (Get your API Key)
- JSON data in Base64 format
Response Format
The API returns an Excel file:
- Status 200: JSON to Excel conversion completed immediately - binary Excel file content in response body
- Status 202: Request accepted and processing asynchronously - use the Location header URL to poll for results
For asynchronous requests, poll the Location URL until status 200 is returned with the Excel file.