---
title: Split Excel API
slug: split-excel-files
url: https://apyverse.com/pankajretestflows/service/split-excel-files
provider: External Providers
categories: [File Manipulation]
tags: [excel-splitting, workbook, spreadsheets, file-manipulation, batch-processing]
auth: api_key
---

# Split Excel API

Split .xlsx and .xlsm files into one workbook per group in a chosen column. Track job progress and download the finished split output.

## Endpoints

| Method | Path | Description | Atoms |
| --- | --- | --- | --- |
| POST | `` | What it does Splits one or more Excel files into separate workbooks based on the unique values in a… | 100 |
| GET | `/status/:job_id` | What it does Retrieves the current status of an Excel split job using its job identifier. The respo… | 1 |
| GET | `/download/:job_id` | What it does Downloads the finished output file for a previously created Excel split job. The jobid… | 1 |
| GET | `/overall-status` | What it does Returns the aggregate progress for one or more Excel split jobs identified by jobids.… | 1 |

## About

## What it does
Excel Splitter breaks uploaded Excel workbooks into separate files based on the value in a chosen column. Send one or more `.xlsx` or `.xlsm` files, choose a sheet by 1-based `sheet_index`, and choose a 1-based `target_column_index` to group rows by.

The split request returns a `jobs` array. Each job includes a `job_id`, `filename`, `status`, `progress`, and the sheet and column indexes used for that file. Use `/status/:job_id` to check an individual job, or `/overall-status` with `job_ids` to get aggregate progress across multiple splits.

When a job is finished, `/download/:job_id` returns the split Excel output as binary data. This is useful when you need to turn a single workbook into per-department, per-region, or per-category files without doing the grouping logic in your own code.

Use Excel Splitter when you receive consolidated spreadsheets and need to distribute them into smaller workbooks for reporting, review, or downstream processing.

## Usage

Authenticate with an ApyHub API key in the `apy-token` header.
Full docs and a live playground: https://apyverse.com/pankajretestflows/service/split-excel-files