Convert JSON to Excel - Data Export for Make

What this module does

PDF4me Convert JSON to Excel transforms JSON arrays into formatted Excel workbooks inside your Make scenario with customizable date, number, and layout settings. Supply the JSON buffer from an HTTP request, database query, or API response and receive a ready-to-use XLSX file. Works with Google Drive, Dropbox, SharePoint, and any downstream storage or reporting module.

Enable Convert number and date for proper Excel data types

Set Convert number and date to Yes so numeric and date fields in your JSON become real Excel values, not plain text strings. Without this, Excel cannot sort, filter, or sum those columns. Pair it with a Date Format and Number Format string to control how each type renders in the cells.

Use First Row and First Column to leave space for headers

Both fields are 1-based integers. Set First Row to 2 if you want to manually add a title row above the data, or set First Column to 2 if you need row labels in column A. Default is row 1, column 1. Combining these offsets lets you position the JSON data precisely inside a pre-formatted template.

WorksheetName defaults to Sheet1 if left empty

Providing a WorksheetName gives the sheet tab a meaningful label, "Sales Q1" or "API Export", which matters when the file is opened by a business user. Maximum 31 characters. If left blank the module uses the default Excel tab name Sheet1, which is fine for automated pipelines where no human opens the file.

Related Blog Posts

No blog post yet for this feature — coming soon.

In the meantime, browse the PDF4me blog for tutorials and workflows across every platform.

Visit the blog →

Authenticating Your API Request

To access the PDF4me Web API through Make, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Make scenarios and PDF4me's powerful JSON conversion services.

Get your API Key

Key Features

• JSON to Spreadsheet: Transform JSON arrays into Excel workbook format
• Date/Number Formatting: Apply custom formats to date and numeric values
• Worksheet Customization: Configure sheet names and starting positions
• Title Formatting: Bold titles and wrap text for professional appearance
• Null Value Handling: Option to ignore or include null values in output

Parameters

Complete list of parameters for the Convert JSON to Excel module. Configure these parameters to control JSON conversion.

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

Parameter	Type	Description	Example
Json File Name***	String	JSON Filename • Specify filename with .json extension • Map from previous module output • Used for output Excel file naming • Supports dynamic naming	sales_data.json
Json File***	Buffer	JSON File Content • Map JSON file buffer from previous module • Source from HTTP request, database, API • Binary JSON data containing array • Structured data for conversion	[JSON Buffer]
First Row	Integer	Starting Row Number • Row number to begin data insertion (1-based) • Leave space for headers or titles • Default is row 1 if not specified • Allows custom positioning	2
First Column	Integer	Starting Column Number • Column number to begin data insertion (1-based) • Leave space for row labels or metadata • Default is column 1 if not specified • Enables custom layout	1
WorksheetName	String	Excel Sheet Name • Custom name for worksheet tab • Default is "Sheet1" if empty • Descriptive names for multiple sheets • Maximum 31 characters	Sales Report
Convert number and date	Boolean	Enable Format Conversion • Yes - Apply date/number formatting • No - Keep values as text • Enables proper Excel data types • Required for calculations and sorting	Yes
Date Format	String	Date Field Format String • Custom date/time format pattern • Uses .NET format strings • Examples: "yyyy-MM-dd", "MM/dd/yyyy" • See Microsoft format docs	yyyy-MM-dd
Number Format	String	Numeric Field Format String • Custom number format pattern • Uses .NET numeric formats • Examples: "N2" (2 decimals), "C" (currency) • See Microsoft format docs	N2
Ignore Null Values	Boolean	Null Value Handling • Yes - Skip null values in output • No - Include null values as empty cells • Affects spreadsheet data completeness • Choose based on data requirements	Yes
Set title to Bold	Boolean	Bold Title Row • Yes - Apply bold formatting to headers • No - Keep standard text formatting • Improves spreadsheet readability • Professional appearance for titles	Yes
Wrap Title text	Boolean	Wrap Header Text • Yes - Enable text wrapping in title cells • No - Keep single-line headers • Useful for long column names • Improves column header readability	No

Output

The PDF4me Convert JSON to Excel module returns comprehensive output data for seamless Make scenario integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
Name	String	Output Excel filename (.xlsx)
Doc Data	Buffer	Excel workbook in Buffer format

JSON

JSON Response Format

The raw JSON response from the module:

{
"Name": "sales_data.xlsx",
"Doc Data": "[Buffer Data - Excel Workbook]"
}

Scenario Integration

Make Scenario Usage

Use converted Excel file in subsequent modules:

• Email Distribution: Send Excel report to stakeholders
• Cloud Storage: Upload to Google Drive, Dropbox folders
• Google Sheets: Import to Google Sheets for collaboration
• Database Import: Load data into database systems
• Data Analysis: Process with Excel analytics tools
• Report Archiving: Store Excel reports in archive

Scenario Examples

The PDF4me Convert JSON to Excel module in Make provides comprehensive scenario templates for JSON conversion automation:

API Reports

Automated API Data to Excel Report Scenario

Transform your API data into professional Excel reports automatically:

Complete Scenario Steps:

1. Trigger: Scheduled daily analytics report generation
2. Call API: HTTP request to analytics API endpoint
3. Get JSON Response: Receive sales data as JSON array
4. Convert to Excel: Transform JSON to formatted Excel
5. Apply Formatting: Bold headers, format dates and currencies
6. Upload to Drive: Save Excel report to Google Drive
7. Email Team: Send daily report to management via Gmail
8. Archive Report: Store in monthly reports folder

Business Benefits:

• Generates 30+ API reports monthly automatically
• Eliminates manual data export and Excel formatting
• Ensures consistent professional report appearance
• Reduces report generation time from 2 hours to 5 minutes

Create Scenario

Database Export

Automated Database to Excel Export Scenario

Streamline your database reporting with automated Excel exports:

Complete Scenario Steps:

1. Trigger: Scheduled weekly database export run
2. Query Database: Get records from PostgreSQL or MySQL
3. Format as JSON: Convert query results to JSON array
4. Convert to Excel: Transform database data to Excel
5. Format Columns: Apply date/number formats appropriately
6. Name Worksheet: Set descriptive sheet name
7. Upload to Dropbox: Save Excel file to shared folder
8. Notify Team: Email team that export is ready

Business Benefits:

• Exports 50+ database reports weekly automatically
• Provides Excel format preferred by business users
• Eliminates manual database export process
• Ensures accurate data representation with formatting

Create Scenario

CRM Export

Automated CRM Data to Excel Export Scenario

Optimize your CRM reporting with automated Excel exports:

Complete Scenario Steps:

1. Trigger: Monthly sales report requested
2. Query CRM: Get deals and contacts from CRM API
3. Process Response: Extract relevant fields from JSON
4. Convert to Excel: Create formatted Excel spreadsheet
5. Apply Currency Format: Format revenue fields as currency
6. Bold Headers: Make column headers bold
7. Email Sales Team: Send Excel report to sales management
8. Archive in Drive: Store in monthly reports archive

Business Benefits:

• Generates 40+ CRM reports monthly automatically
• Provides Excel format for sales team analysis
• Eliminates manual CRM data export and formatting
• Ensures accurate sales data representation

Create Scenario

Survey Results

Automated Survey Results to Excel Scenario

Enhance your survey analysis with automated Excel conversion:

Complete Scenario Steps:

1. Trigger: Survey closed in survey platform
2. Get Survey Responses: Retrieve all responses via API
3. Parse JSON: Extract responses from JSON structure
4. Convert to Excel: Create Excel with response data
5. Format Dates: Apply date format to submission timestamps
6. Create Charts: Generate summary charts in Excel
7. Upload Results: Save to Google Drive survey folder
8. Email Stakeholders: Distribute results to project team

Business Benefits:

• Exports 25+ survey results monthly automatically
• Provides Excel format for easy analysis and charting
• Reduces results processing time by 90%
• Enables immediate data analysis upon survey close

Create Scenario

Industry Use Cases & Applications

Business Intelligence & Analytics

• API Data Reports: Convert API responses to Excel reports
• Dashboard Exports: Export dashboard data to Excel
• Metrics Reports: Transform JSON metrics to spreadsheets
• KPI Tracking: Create Excel KPI reports from JSON

Database & Data Management

• Database Exports: Export database queries to Excel
• Data Migration: Convert JSON exports to Excel format
• Backup Exports: Create Excel backups of JSON data
• Data Distribution: Share database data as Excel files

Sales & CRM

• CRM Exports: Convert CRM data to Excel reports
• Sales Reports: Transform sales data to spreadsheets
• Pipeline Reports: Export opportunity data to Excel
• Contact Lists: Convert contact JSON to Excel

Survey & Research

• Survey Results: Export survey responses to Excel
• Research Data: Convert research JSON to spreadsheets
• Form Responses: Transform form data to Excel
• Feedback Analysis: Create Excel from feedback JSON

Get Help

Make IntegrationGet your API KeyMake Documentation