Extract Worksheets from Excel using Zapier

PDF4me Extract Worksheets from Excel exports complete worksheets as JSON, automatically using the first row as headers. Whether you need one specific sheet or all worksheets from a workbook, this action converts your Excel data into clean JSON arrays that databases, APIs, and modern applications consume easily. Extract by worksheet name, index number, or get everything—the result is organized as a dictionary keyed by sheet name, making it simple to work with multi-sheet exports. Perfect for archiving complex Excel files, feeding workbook data into analytics platforms, or building data pipelines from multi-sheet reports.

Authenticating Your API Request

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

Get your API Key

Configure the Excel Extract Worksheets action—File input and worksheet targeting.

Configuration at a Glance

Example configuration from the Zapier interface

The screenshot above shows extracting Sheet1 and Sheet2 from an Excel workbook, with File and File Name mapped from previous steps.

File

add_header_sample_file.xlsx

Worksheet Names

Sheet1, Sheet2

Worksheet Indexes

Optional (1-based)

:::tip Map File and File Name from previous steps Use the + button next to File and File Name to map from earlier Zap steps—e.g., Full File Name from a previous PDF4me Excel action. The Excel file must provide full content, not "Exists but not shown" references. :::

:::warning File: (Exists but not shown) If you see "File: (Exists but not shown)" in the File field and get "File is Empty" errors, select the option that provides the full file content instead. See Zapier & Power Automate Tips for details. :::

Key Features

• Complete Worksheet Extraction to JSON with automatic header detection
• Flexible Selection: Extract by Worksheet Names, Worksheet Indexes, or both (union)
• Multi-Sheet Support extracts multiple worksheets in one operation
• Dictionary Output keyed by worksheet name for easy access
• 1-Based Indexing for Worksheet Indexes

Parameters

Complete list of parameters for the Extract Worksheets action. Parameter names match the Zapier configuration UI.

Quick setup checklist

1. Map File (Excel) from your trigger or a previous step
2. Map File Name (e.g., Full File Name from previous step)
3. Enter Worksheet Names and/or Worksheet Indexes (leave both empty to extract all)

Important: Parameters marked with an asterisk (***) are required. Use the + button next to each field to map data. Worksheet indexes are 1-based (1 = first worksheet).

Parameter	Type	Description	Example
File***	File	Excel File Content—map from previous step. Shows "File: (Exists but not shown)" when mapped	[2. File from Step 2]
File Name***	String	Excel Filename—map from previous step (e.g., Full File Name)	add_header_sample_file.xlsx
Worksheet Names	String	Extract by name—comma-separated. Empty with Indexes = all worksheets	Sheet1, Sheet2
Worksheet Indexes	String	Extract by index (1-based)—comma-separated. 1 = first worksheet. Union with Names	1,3

Output

The PDF4me Extract Worksheet from Excel action returns comprehensive JSON output data for seamless Zapier workflow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
document	Base64	JSON byte array (serialized dictionary)
FileName	String	Output filename (e.g., report.txt)
Success	Boolean	Operation result

JSON

JSON Response Format

The raw JSON response from the action:

{
  "document": "[Base64 JSON]",
  "FileName": "report.txt",
  "Success": true
}

Extracted JSON Structure (decoded from document):

{
  "Summary": [
    {"Month": "January", "Revenue": 50000, "Expenses": 30000},
    {"Month": "February", "Revenue": 55000, "Expenses": 32000}
  ],
  "Sales": [
    {"Product": "Widget A", "Quantity": 100, "Price": 10.50},
    {"Product": "Widget B", "Quantity": 150, "Price": 15.75}
  ]
}

Zap Integration

Zapier Workflow Usage

Use extracted worksheet JSON in subsequent steps:

• Multi-API Integration: Send each worksheet's JSON to different API endpoints
• Database Import: Map worksheet names to database table names for loading
• Workbook Archival: Store complete workbook as JSON for historical records
• Data Transformation: Process and enrich multi-sheet JSON data

Scenario Examples

The PDF4me Extract Worksheets from Excel action in Zapier provides comprehensive scenario templates designed for real-world multi-sheet data integration needs:

Multi-Sheet API Feed

Automated Multi-Worksheet API Distribution Workflow

Distribute different worksheets to different API endpoints automatically:

Complete Scenario Steps:

1. Trigger: Daily data export scheduled at midnight
2. Get Multi-Sheet Report: Retrieve consolidated report from Google Drive
3. Extract Worksheets: Map File, File Name; leave Worksheet Names and Worksheet Indexes empty to extract all
4. Parse JSON Document: Decode Base64 document to get worksheet dictionary
5. Process Summary Sheet: Extract "Summary" key data and POST to dashboard API
6. Process Sales Sheet: Extract "Sales" key data and POST to sales analytics API
7. Process Expenses Sheet: Extract "Expenses" key data and POST to finance API
8. Handle API Responses: Check each API response and log results
9. Email Summary: Send distribution summary to integration team
10. Archive Source: Store processed Excel in archive for audit trail

Business Benefits:

• Distributes 3+ worksheets to separate APIs daily
• Automatic routing eliminates manual worksheet copying
• Each system receives only relevant worksheet data
• Reduces data distribution time from 2 hours to 5 minutes

Create Zap

Data Archival

Automated Monthly Workbook JSON Archival Workflow

Archive complete workbooks as JSON for long-term storage and compliance:

Complete Scenario Steps:

1. Trigger: Monthly archival scheduled on last day of month at 11 PM
2. Get Monthly Report: Retrieve month-end report workbook from SharePoint
3. Extract Worksheets: Map File, File Name; leave Worksheet Names/Indexes empty to extract all
4. Decode JSON: Parse Base64 document to get full workbook JSON structure
5. Add Metadata: Append archive date, user, and file hash to JSON
6. Store to Blob Storage: Save enriched JSON to Azure Blob Storage
7. Create Archive Index: Add entry to archive index with month and location
8. Email Archive Confirmation: Send confirmation to compliance officer
9. Clean Up Source: Move original Excel to cold storage
10. Log Archive Event: Record archival in audit log with retention info

Business Benefits:

• Archives 12+ monthly workbooks annually as JSON
• JSON format enables easy search and compliance queries
• Reduces archive storage costs by 60% vs. Excel format
• Maintains complete audit trail with metadata

Create Zap

Selective Export

Automated Selective Worksheet Export Workflow

Export only requested worksheets for client or external distribution:

Complete Scenario Steps:

1. Trigger: Client data request submitted via form
2. Get Master Workbook: Retrieve complete data workbook from secure storage
3. Parse Request: Extract requested worksheet names from form submission
4. Extract Worksheets: Map File, File Name; set Worksheet Names = "Q1,Q2" (or requested list)
5. Decode JSON: Parse Base64 document to get selected worksheets only
6. Sanitize Data: Remove sensitive columns from extracted JSON
7. Create Excel: Optionally convert cleaned JSON back to Excel
8. Upload to Client Portal: Save sanitized data to client-accessible location
9. Email Client: Send notification with download link
10. Log Export: Record export event with client ID and worksheets exported

Business Benefits:

• Processes 50+ selective export requests monthly
• Extracts only authorized worksheets preventing data leakage
• Automated sanitization ensures compliance with data policies
• Reduces manual export time from 30 minutes to 2 minutes

Create Zap

Industry Use Cases & Applications

IT & Integration

• Multi-API Feeds: Extract different worksheets to different system APIs automatically
• Data Warehouse Loading: Load multi-sheet financial workbooks to data warehouse tables
• System Migration: Extract complete Excel workbooks to JSON for migration to cloud systems
• Data Backup: Archive multi-sheet operational workbooks as JSON for disaster recovery
• ETL Pipeline: Extract worksheets as intermediate format in multi-step transformation pipelines

Finance & Accounting

• Period Close: Extract monthly P&L, balance sheet, and cash flow worksheets to financial systems
• Consolidation Export: Extract entity-level worksheets from consolidation workbooks for GL posting
• Budget Distribution: Extract department budget worksheets and distribute to respective systems
• Audit File Archival: Extract complete audit workbooks to JSON for 7-year retention compliance
• Management Reporting: Extract executive summary and detail worksheets for different stakeholder systems

Operations

• Multi-Site Data: Extract site-specific worksheets from consolidated operational workbooks
• Dashboard Feeds: Extract KPI worksheets from operational Excel to BI dashboard APIs
• Inventory Sync: Extract warehouse inventory worksheets to WMS systems
• Production Reporting: Extract shift worksheets from production workbooks to MES systems
• Quality Data: Extract inspection worksheets by product line to QMS platforms

Education

• Course Data Export: Extract course enrollment worksheets from registrar workbooks to SIS
• Grade Distribution: Extract grade worksheets by semester to learning management systems
• Student Records: Extract student data worksheets for reporting to state education systems
• Financial Aid: Extract aid worksheets from master workbooks to financial aid platforms
• Assessment Data: Extract test score worksheets by subject for analytics platforms

Get Help

Zapier IntegrationGet your API KeyZapier Documentation