Excel to JSON

Extract data from Excel files and convert to JSON format with multiple read modes.

Endpoint

POST https://www.acrewity.com/api/services/execute

Authentication

Include your API key in the Authorization header:

Authorization: Bearer YOUR_API_KEY

n8n Integration

This service is also available via our n8n community node: @acrewity/n8n-nodes-acrewity

Operations

List Sheets

Get all sheet names and metadata from an Excel file

Operation ID: list_sheets

Parameters

Parameter	Type	Required	Default	Description
`file`	file	Yes	-	Excel file (.xlsx, .xls)

Example Request

{
  "service": "excel-to-json",
  "operation": "list_sheets",
  "parameters": {
    "file": "BASE64_ENCODED_EXCEL_FILE"
  }
}

Example Response

{
  "success": true,
  "result": {
    "data": {
      "sheets": [
        { "name": "Contacts", "rowCount": 150 },
        { "name": "Orders", "rowCount": 500 },
        { "name": "Products", "rowCount": 75 }
      ]
    }
  },
  "credits_used": 1
}

Read Entire File

Read all sheets with full cell data, types, and formulas

Operation ID: read_excel

Parameters

Parameter	Type	Required	Default	Description
`file`	file	Yes	-	Excel file (.xlsx, .xls)
`sheets`	array	No	-	Array of sheet names to read (empty for all)
`includeDetectedTables`	boolean	No	`true`	Include auto-detected table data

Example Request

{
  "service": "excel-to-json",
  "operation": "read_excel",
  "parameters": {
    "file": "BASE64_ENCODED_EXCEL_FILE",
    "sheets": ["Contacts", "Orders"],
    "includeDetectedTables": true
  }
}

Read Specific Sheet

Read a single sheet with full cell data

Operation ID: read_sheet

Parameters

Parameter	Type	Required	Default	Description
`file`	file	Yes	-	Excel file (.xlsx, .xls)
`sheetName`	string	Yes	-	Name of the sheet to read
`includeDetectedTables`	boolean	No	`true`	Include auto-detected table data

Example Request

{
  "service": "excel-to-json",
  "operation": "read_sheet",
  "parameters": {
    "file": "BASE64_ENCODED_EXCEL_FILE",
    "sheetName": "Contacts",
    "includeDetectedTables": true
  }
}

Get Cell Range

Extract values from a specific cell range (e.g., A1:D10)

Operation ID: get_range

Parameters

Parameter	Type	Required	Default	Description
`file`	file	Yes	-	Excel file (.xlsx, .xls)
`range`	string	Yes	-	Cell range in A1 notation (e.g., A1:D10, B2, A:A)
`sheetName`	string	No	-	Sheet name (uses first sheet if not specified)

Example Request

{
  "service": "excel-to-json",
  "operation": "get_range",
  "parameters": {
    "file": "BASE64_ENCODED_EXCEL_FILE",
    "range": "A1:D50",
    "sheetName": "Sales Data"
  }
}

Smart Table Extract

Intelligently detect and extract tables from Excel

Operation ID: convert

Parameters

Parameter	Type	Required	Default	Description
`file`	file	Yes	-	Excel file (.xlsx, .xls)
`sheetName`	string	No	-	Specific sheet name (empty for all sheets)
`format`	string	No	`array_of_objects`	Output format Options: `array_of_objects`, `raw_arrays`

Example Request

{
  "service": "excel-to-json",
  "operation": "convert",
  "parameters": {
    "file": "BASE64_ENCODED_EXCEL_FILE",
    "sheetName": "Contacts",
    "format": "array_of_objects"
  }
}

Example Response

{
  "success": true,
  "result": {
    "data": {
      "rows": [
        { "Name": "John Smith", "Email": "john@example.com", "Phone": "555-1234" },
        { "Name": "Jane Doe", "Email": "jane@example.com", "Phone": "555-5678" }
      ],
      "headers": ["Name", "Email", "Phone"],
      "rowCount": 2
    }
  },
  "credits_used": 1
}

More Examples

See Data Transformation Examples for complete workflow examples including bulk data imports and spreadsheet processing.