The Autohive Spreadsheet Tools integration provides powerful spreadsheet processing capabilities within Autohive’s automation platform, enabling:

  • Multi-format support - Convert Excel (.xlsx, .xls) and CSV files to structured JSON format
  • Automatic header parsing - Intelligently extract and sanitize column headers for clean JSON property names
  • Row-to-object mapping - Transform spreadsheet rows into JSON objects with header-based properties
  • Seamless file handling - Process base64-encoded files with automatic content type detection
  • Data normalization - Clean and standardize spreadsheet data for downstream processing and integration

Install the integration

  1. Log in to Autohive and navigate to Your user profile > Connections or Your workspace -> Integrations

  2. Locate the Spreadsheet Tools Integration card and click Connect to workspace

    List of integrations in Autohive

  3. Confirm installation - the integration will be available immediately with “Connected” status displayed

Use the integration

You can now use the integration with your agents, workflows and scheduled tasks!

  1. Follow our Create your first agent guide on how to create an agent.
  2. In the ‘Agent settings’, scroll down to the ‘Add Integrations and Agents’ section, click ‘Add integrations and agents’, and select Spreadsheet Tools. You can choose what individual Spreadsheet Tools capabilities to turn on and off.
  3. Once the settings have been selected, begin prompting the agent with the workflow you’d like to achieve with Autohive and Spreadsheet Tools!

Available capabilities

File Conversion

  • Convert Spreadsheet to JSON: Transform Excel (.xlsx, .xls) and CSV files into structured JSON format with automatic header detection and sanitization

Key features

Universal Format Support

  • Process Microsoft Excel files (.xlsx and .xls formats) for modern and legacy spreadsheets
  • Handle CSV files with automatic delimiter detection and parsing
  • Support for base64-encoded file content for secure transmission
  • Automatic content type detection for seamless multi-format processing

Intelligent Data Transformation

  • Automatic header row detection for column name extraction
  • Header sanitization to create clean, valid JSON property names
  • Row-to-object mapping where each row becomes a JSON object
  • Consistent array output format where each element represents a spreadsheet row

Seamless Integration Workflow

  • Accept files from other integrations via base64-encoded content
  • Return JSON files in the same format for downstream processing
  • Preserve original file names with automatic .json extension
  • Output files ready for immediate use in workflows, APIs, or databases

Data Quality and Consistency

  • Remove special characters and whitespace from headers for clean property names
  • Handle missing or empty cells gracefully in the conversion process
  • Maintain data type integrity during transformation
  • Generate well-structured JSON suitable for programmatic access

Common use cases

Data Import Automation

  • Convert uploaded Excel or CSV files to JSON for database import workflows
  • Transform spreadsheet data for API consumption and integration with external systems
  • Automate data migration from spreadsheets to CRM, ERP, or other business systems
  • Process bulk data uploads with automatic format standardization

Spreadsheet Processing Workflows

  • Extract data from Excel reports for analysis and visualization
  • Convert CSV exports from legacy systems to JSON for modern application integration
  • Transform survey results from spreadsheet format to structured data
  • Process financial reports, inventory lists, or customer data from spreadsheet sources

Integration and Data Pipeline

  • Bridge spreadsheet-based data sources with JSON-consuming APIs
  • Create automated ETL (Extract, Transform, Load) pipelines from spreadsheet uploads
  • Normalize data from multiple spreadsheet sources into consistent JSON format
  • Feed spreadsheet data into machine learning models or analytics platforms

Business Process Automation

  • Convert employee timesheets or expense reports from Excel to JSON for payroll systems
  • Transform customer order spreadsheets into JSON for order processing workflows
  • Process inventory updates from CSV files for real-time stock management
  • Automate reporting by converting spreadsheet data to JSON for dashboard systems

Data Exchange and Collaboration

  • Convert partner data submissions from Excel to JSON for system integration
  • Transform spreadsheet-based data exports into API-friendly JSON format
  • Facilitate data sharing between teams using different technology stacks
  • Enable non-technical users to submit structured data via familiar spreadsheet formats

Disconnect the integration

Important: Disconnecting stops the integration but does not affect previously converted data.

  1. Navigate to Your user profile -> Connections or Your workspace -> Integrations
  2. Find the Spreadsheet Tools Integration
  3. Click Disconnect and confirm

Data Impact: Previously converted JSON files remain accessible, but new conversions cannot be performed.

Technical details

Input Format

  • File Object: Base64-encoded file content with name and content type metadata
  • Supported Formats: Excel (.xlsx, .xls), CSV (.csv)
  • Required Fields: content (base64 string), name (string), contentType (string)

Output Format

  • File Object: Base64-encoded JSON file with .json extension
  • JSON Structure: Array of objects where each object represents a spreadsheet row
  • Property Names: Sanitized column headers from the first row of the spreadsheet
  • Content Type: application/json

Data Processing

  • First row of spreadsheet is treated as header row for property names
  • Special characters and whitespace in headers are removed or replaced for valid JSON keys
  • Empty cells are included as null or empty string values depending on the source format
  • All subsequent rows are converted to JSON objects with properties matching sanitized headers