Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Convert JSON to Excel - Data Transform API

PDF4me Convert JSON to Excel is a comprehensive enterprise-grade solution that transforms JSON data into professional Excel spreadsheets through robust API integration. Our advanced cloud-based processing engine supports comprehensive data conversion with custom worksheet naming, advanced text formatting, intelligent number and date conversion, and flexible positioning controls. The API efficiently processes data transformation by receiving JSON content and conversion parameters through REST API calls, utilizing advanced rendering technology for precise spreadsheet generation with professional formatting. With comprehensive support for custom headers, data type conversion, null value handling, and professional formatting options, this solution is ideal for business intelligence systems, data reporting platforms, analytics dashboards, and enterprise data transformation workflows that require reliable, scalable JSON to Excel conversion with professional-grade output quality.

Authenticating Your API Request​

To access the PDF4me REST API, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user of the REST API.

Get your api Key

Key Features​

  • Custom Worksheet Management: Assign descriptive names to Excel worksheets for better organization and professional presentation
  • Advanced Text Formatting: Control title wrapping, bold formatting, text positioning, and typography for enhanced readability
  • Intelligent Data Type Conversion: Automatically convert numbers, dates, and other data types to proper Excel formats with validation
  • Flexible Data Positioning: Control starting row and column placement for precise data organization and layout control
  • Smart Null Value Handling: Choose to include or exclude null values in output with intelligent data cleaning options
  • Professional Excel Formatting: Generate clean, business-ready Excel files with consistent formatting and professional appearance

REST API Endpoint​

The PDF4me REST API uses standard HTTP methods to interact with resources. All JSON to Excel conversion operations are performed through a single endpoint:

  • Method: POST
  • Endpoint: /api/v2/ConvertJsonToExcel

REST API Parameters​

Complete list of parameters for the Convert JSON to Excel REST API. Parameters are organized by category for better understanding and implementation.

Important: Parameters marked with an asterisk (*) are required and must be provided for the API to function correctly.

Required Parameters​

ParameterTypeDescriptionExample
fileName*StringName of the output Excel file with .xlsx extensiondata_export.xlsx
docName*StringContent of the base JSON file encoded in Base64 formatJVBERi...
worksheetName*StringName of the worksheet. Can be any string valueSheet1

Formatting Parameters​

ParameterTypeDescriptionExample
isTitleWrapText*BooleanWrap title text to next line if too long. Options: true (wrap), false (single line)true
isTitleBold*BooleanMake title text bold for emphasis. Options: true (bold), false (normal)true

Data Conversion Parameters​

ParameterTypeDescriptionExample
convertNumberAndDate*BooleanConvert numeric values and dates to standard formats. Options: true (convert), false (keep as text)false
numberFormat*StringNumber format specification as string value"11"
dateFormat*StringDate format specification as string value"01/01/2025"

Data Processing Parameters​

ParameterTypeDescriptionExample
ignoreNullValues*StringSkip fields containing null values. Options: "true" (ignore), "false" (include)"false"
firstRow*IntegerStarting row for data placement (must be integer)1
firstColumn*IntegerStarting column for data placement (must be integer)1

Output​

The PDF4me Convert JSON to Excel REST API returns a response that can be viewed in multiple formats. Choose the view that best fits your needs:

JSON Response Format

The raw JSON response from the API:

[
  {
    "fileName": "data_export.xlsx",
    "mimeType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
    "fileSize": 156789,
    "success": true,
    "worksheetName": "Sheet1",
    "rowsProcessed": 150,
    "columnsProcessed": 8
  }
]

Request Example​

Content-Type: application/json
Authorization:  YOUR_API_KEY

Note: Get your API key from the PDF4me Dashboard

Payload​

{
  "fileName": "output.xlsx",
  "docName": "Please put text base64 content",
  "worksheetName": "Sheet1",
  "isTitleWrapText": true,
  "isTitleBold": true,
  "convertNumberAndDate": false,
  "numberFormat": "11",
  "dateFormat": "01/01/2025",
  "ignoreNullValues": "false",
  "firstRow": 1,
  "firstColumn": 1
}

Code Samples​

The PDF4me Convert JSON to Excel REST API provides code samples in multiple programming languages. Choose the language that best fits your development environment:

C# (CSharp) Sample

Complete C# implementation for converting JSON to Excel:

Industry Use Cases & Applications​

Business Intelligence & Analytics Use Cases

  • Data Reporting: Convert API responses and database exports to Excel for stakeholder reports
  • Dashboard Data: Transform JSON analytics data into Excel for further analysis and visualization
  • KPI Tracking: Convert performance metrics from JSON APIs into structured Excel reports
  • Financial Analysis: Transform financial data from APIs into Excel for accounting and analysis

Get Help​

Get Your API KeyAPI SamplesGetting Started