Microsoft Excel
The Microsoft Excel connector uses a template file to process data from Excel documents to generate JSON payloads.
Solution Details
- Solution Type
- Platform Connector
- Author
- Boomi
- Published on
- May 16, 2026
- Last updated on
- May 16, 2026
Get Started
Get StartedKey Features
- Parse Excel documents and transform structured cell data into well-formed JSON payloads automatically
- Utilize customizable template files to define precise data mapping and extraction rules
- Support both .xls and .xlsx file formats for broad spreadsheet compatibility
- Enable automated ingestion of spreadsheet data into enterprise integration workflows without manual intervention
- Map multiple sheets, columns, and rows to generate complex nested JSON output structures
How it works
The Microsoft Excel connector enables seamless integration between Excel spreadsheets and the Boomi platform by converting structured workbook data into JSON payloads for downstream processing. It leverages a predefined template file to map columns, rows, and sheets, ensuring consistent and accurate data extraction from Excel documents. This eliminates manual data entry and enables automated workflows that transform spreadsheet-based business data into formats consumable by APIs, databases, and other enterprise applications. Organizations benefit from reduced processing time, fewer errors, and the ability to incorporate Excel-driven data into end-to-end integration processes.
Applications Required
- Microsoft Excel