Convert Json To Excel in Power Automate

PDF4me Convert Json To Excel action delivers intelligent data transformation in Power Automate with automated conversion of JSON data structures into professionally formatted Excel spreadsheets. This comprehensive conversion service transforms API responses, database exports, and structured JSON data into Excel files with customizable formatting, number conversion, date handling, and worksheet organization—enabling seamless data reporting and analysis across Microsoft 365 workflows.

Authenticating Your API Request

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

Get your API Key

Key Features

• JSON to Excel Conversion: Transform structured JSON data into Excel spreadsheets
• Custom Formatting: Configure date formats, number formats, and title styling
• Data Positioning: Control starting row and column for data placement
• Worksheet Naming: Customize worksheet names for organized Excel files
• Null Handling: Configure null value behavior for clean data output
• Auto-Conversion: Automatically detect and convert numbers and dates

Parameters

Complete list of parameters for the Convert Json To Excel action. Configure these parameters to control data transformation and Excel formatting.

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

Source Data Parameters

Parameter	Type	Description	Example
File Content***	Binary	JSON Source Data • JSON data content to convert to Excel • Supports API responses and database exports • Accepts dynamic content from previous actions • Compatible with JSON arrays and objects	[JSON Data]
File Name***	String	Output Excel Filename • Specify Excel filename with .xlsx extension • Used for saved file identification • Supports dynamic naming from flow variables • Maintains file tracking in workflows	report.xlsx

Data Positioning Parameters

Parameter	Type	Description	Example
First Row	Integer	Starting Row Position • Row number where data insertion begins • Leave empty to start from row 1 • Useful for adding headers or spacing • Enables custom layout control	2
First Column	Integer	Starting Column Position • Column number where data insertion begins • Leave empty to start from column A • Allows offset for labels or formatting • Supports custom Excel layouts	1

Worksheet Configuration Parameters

Parameter	Type	Description	Example
Worksheet Name	String	Excel Sheet Name • Custom name for Excel worksheet • Defaults to "Sheet1" if not specified • Supports descriptive naming for clarity • Enables organized multi-sheet workbooks	Sales Data

Data Conversion Parameters

Parameter	Type	Description	Example
Convert Number and Data	Boolean	Auto-Convert Data Types • True - Automatically convert numbers and dates • False - Keep all data as text • Enables proper Excel data typing • Improves calculation and sorting capabilities	True
Date Format	String	Date/Time Format String • Custom format for date values • Uses .NET date format patterns • Examples: "yyyy-MM-dd", "MM/dd/yyyy HH:mm" • Format reference	yyyy-MM-dd
Number Format	String	Numeric Format String • Custom format for number values • Uses .NET numeric format patterns • Examples: "N2" (2 decimals), "C" (currency) • Format reference	N2

Formatting & Display Parameters

Parameter	Type	Description	Example
Ignore Null Values	Boolean	Null Value Handling • True - Skip null values in output • False - Show empty cells for nulls • Enables clean data presentation • Removes unwanted empty entries	True
Set title to bold	Boolean	Bold Header Row • True - Format column headers as bold • False - Normal weight headers • Improves visual hierarchy • Enhances spreadsheet readability	True
Wraps Title Text	Boolean	Header Text Wrapping • True - Wrap long column headers • False - Single line headers • Prevents header truncation • Maintains column width efficiency	True

Output

The PDF4me Convert Json To Excel action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
File Content	Binary	Complete Excel spreadsheet with converted JSON data

JSON

JSON Response Format

The raw JSON response from the action:

{
  "File Content": "[Binary Excel Data]"
}

Flow Integration

Power Automate Flow Usage

Use converted Excel files in subsequent actions:

• Email Distribution: Attach Excel reports to Outlook emails
• SharePoint Storage: Save Excel files to document libraries
• OneDrive Archive: Store Excel reports in organized folders
• Teams Sharing: Share Excel data reports in Teams channels
• Power BI: Import Excel data for visualization and analytics
• Database Import: Use Excel as intermediate format for data import

Workflow Examples

The PDF4me Convert Json To Excel action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

API Data Reporting

Automated API Response to Excel Report Workflow

Transform your API data with automated JSON to Excel conversion for stakeholder reporting:

Complete Workflow Steps:

1. Trigger: Scheduled daily at 8 AM for morning reports
2. Call API: Retrieve sales data from CRM API endpoint
3. Parse JSON: Extract JSON response from API call
4. Convert to Excel: Transform JSON sales data to Excel spreadsheet
5. Format: Apply bold headers, number formatting (2 decimals)
6. Add Charts: Optionally create Excel charts using Graph API
7. Email Report: Send Excel report to sales team via Outlook
8. Archive: Save Excel report to SharePoint reports library

Business Benefits:

• Automates daily sales reporting for 50+ team members
• Eliminates manual JSON to Excel conversion saving 2 hours daily
• Ensures consistent report formatting with automated conversion
• Enables data analysis with properly typed Excel data

Create Flow

Database Export

Automated Database JSON Export to Excel Workflow

Streamline your data exports with automated SQL to Excel conversion via JSON:

Complete Workflow Steps:

1. Trigger: Request received for customer data export
2. Query Database: Execute SQL query to retrieve customer records
3. Get JSON: Extract JSON output from SQL query results
4. Convert to Excel: Transform customer JSON to formatted Excel
5. Apply Formatting: Set date format (MM/dd/yyyy), bold titles
6. Customize Sheet: Name worksheet "Customer Export [Date]"
7. Secure: Apply password protection if sensitive data
8. Deliver: Email Excel export to requesting user securely

Business Benefits:

• Processes 200+ database export requests monthly automatically
• Reduces export preparation time from 30 minutes to 2 minutes
• Ensures data formatting consistency with automated conversion
• Maintains data security with password protection options

Create Flow

Analytics Dashboard Export

Automated Analytics JSON to Excel Export Workflow

Optimize your analytics delivery with automated dashboard data export to Excel:

Complete Workflow Steps:

1. Trigger: User clicks "Export to Excel" button in Power Apps
2. Get Analytics: Retrieve JSON analytics data from Azure SQL
3. Prepare Data: Filter and aggregate JSON for reporting
4. Convert to Excel: Transform analytics JSON to Excel format
5. Multi-Sheet: Create separate worksheets for metrics categories
6. Format Numbers: Apply currency and percentage formats
7. Add Summary: Include summary statistics in first worksheet
8. Download: Provide Excel download link to Power Apps user

Business Benefits:

• Enables on-demand analytics exports for 100+ users
• Provides offline data access with Excel conversion
• Improves decision-making with formatted analytics data
• Reduces IT support requests with self-service export

Create Flow

Inventory Reporting

Automated Inventory JSON to Excel Report Workflow

Enhance your inventory management with automated JSON to Excel inventory reports:

Complete Workflow Steps:

1. Trigger: Scheduled weekly inventory report generation
2. Get Inventory: Retrieve inventory JSON from WMS API
3. Parse Products: Extract product, quantity, location data
4. Convert to Excel: Transform inventory JSON to Excel spreadsheet
5. Format Data: Apply number formats, wrap headers, bold titles
6. Add Filters: Enable Excel AutoFilter for data filtering
7. Calculate Totals: Add summary row with total quantities
8. Distribute: Email Excel inventory report to warehouse team

Business Benefits:

• Automates weekly inventory reporting for 5 warehouse locations
• Eliminates 4 hours of manual report preparation weekly
• Enables instant inventory analysis with filtered Excel data
• Maintains inventory visibility with automated reporting

Create Flow

Industry Use Cases & Applications

Data Analytics & BI

Data Analytics & BI Use Cases

• API Reports: Convert API JSON responses to Excel reports
• Dashboard Exports: Export analytics dashboards to Excel
• Data Extracts: Transform database JSON to Excel files
• KPI Reports: Generate Excel KPI reports from JSON data

E-commerce & Retail

E-commerce & Retail Use Cases

• Sales Reports: Convert sales JSON data to Excel reports
• Inventory Exports: Transform inventory JSON to Excel
• Order Data: Export order JSON to Excel spreadsheets
• Product Catalogs: Convert product JSON to Excel catalogs

Finance & Accounting

Finance & Accounting Use Cases

• Transaction Reports: Transform transaction JSON to Excel
• Financial Statements: Convert GL JSON to Excel reports
• Reconciliation: Export reconciliation JSON to Excel
• Audit Data: Transform audit JSON to Excel format

IT & Development

IT & Development Use Cases

• Log Analysis: Convert log JSON to Excel for analysis
• System Reports: Transform system JSON to Excel reports
• Error Tracking: Export error JSON to Excel spreadsheets
• Performance Data: Convert metrics JSON to Excel format

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation