Excel Manipulator Documentation

Describe any spreadsheet operation in plain English and let AI execute it. VLOOKUPs, pivot tables, SUMIFs, clean-ups, and formatting — applied to your workbook automatically. Explore the product page

Overview

The Excel Manipulator executes spreadsheet operations described in natural language. Upload an Excel workbook, describe what you want done — a VLOOKUP, a pivot table, a conditional sum, a clean-up — and GAI writes and runs the formulas, returning your updated workbook with formatting preserved.

Supported Operations

All excel functions supported.

Supported Formats

.xlsx, .xlsm, and .xls workbooks
Multi-sheet workbooks
Up to 20 MB per file, 20 MB total per request
Output preserves the original formatting

API Reference

Manipulate Excel workbooks via our REST API. Upload an Excel file together with a plain-English prompt describing the operation; the engine returns your updated workbook.

POST https://server.gimele.com/api/v1/excel-manipulate

Integrate this endpoint into your applications to upload an Excel workbook and receive a manipulated workbook in return.

You can create a developer account to get an api key fromhere.

Headers

Authorization: Bearer <your-api-key>
Content-Type: multipart/form-data

Form Data Parameters

Parameter	Type	Required	Description
files	File	Yes	Excel file(s) to manipulate (.xlsx, .xlsm, .xls)
prompt	string	Yes	Plain-English description of the operation to perform
prompts	string	No	JSON array of ordered step prompts for multi-step chains
preserve_format	boolean	No	Preserve the original formatting of the workbook (default: false)

curl -X POST https://server.gimele.com/api/v1/excel-manipulate \
  -H "Authorization: Bearer $GIMELE_API_KEY" \
  -F "files=@./sales.xlsx" \
  -F "prompt=Pull the price column from Sheet1 into Sheet2, matching rows on the productId column (XLOOKUP)." \
  -F "preserve_format=false"

Success Response (200 OK)

Returns the manipulated Excel file as a binary stream.
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Disposition: attachment; filename="output.xlsx"

Error Responses

400 Bad Request — Invalid File Type

{
 "detail": "All files must be .xlsx, .xlsm or .xls"
}

→ Fix: Upload Excel files with a .xlsx, .xlsm, or .xls extension only

413 Payload Too Large — File Size Exceeded

{
 "detail": "The Excel file is too large for the manipulation service to process"
}

→ Fix: Keep each file under 20 MB and the total upload under 100 MB; split larger workbooks into parts

401 Unauthorized — Invalid or Missing API Key

{
 "detail": "Invalid or expired API key"
}

→ Fix: Verify your API key is correct and not expired; regenerate from your dashboard

500 Internal Server Error — Processing Failure

{
 "detail": "Error processing files: [error details]"
}

→ Fix: Verify the workbook is not corrupted and the prompt clearly describes a valid operation on the uploaded sheets