Splitter

Welcome to the comprehensive guide for our Spreadsheet Splitting API—a robust solution designed to streamline the handling of multi-sheet documents across a variety of popular formats. Whether you're working with traditional Excel workbooks (.xlsx, .xls, .xlsm), plain-text CSV and TSV files, Apple Numbers (.numbers), or any of the other supported file types, this API automatically extracts each sheet or tab and saves it as an independent file. This capability is perfect for developers who need to break down large, monolithic datasets into manageable pieces for modular workflows, isolate sensitive information, or deliver tailored data sets to different stakeholders. The documentation below walks you through the API's core concepts, authentication mechanisms, request structure, and response handling, giving you everything you need to integrate this powerful functionality with just a single call.

Main Features

Built for speed and reliability, the API leverages optimized parsing engines to ensure rapid processing even for workbooks with dozens of sheets and thousands of rows. Its developer-friendly design embraces standard HTTP methods, JSON payloads, and clear status codes, allowing you to incorporate it seamlessly into existing pipelines or serverless functions. Throughout the guide you will find practical examples, best-practice recommendations, and troubleshooting tips that help you avoid common pitfalls and maximize performance. By the end of this documentation, you'll be equipped to transform complex, multi-sheet spreadsheets into clean, standalone files—empowering you to achieve precise data segmentation with minimal effort. Dive in and discover how a single request can turn a tangled workbook into a collection of ready-to-use assets.

Documents

Parameters

UploadFileRequest.OperationId: This is an operation id
UploadFileRequest.Files: These are files you need to upload them to our online services, you can prepare the data in your very own way but it must follow the standard of the html input file.

Use The Endpoint

Send a request that includes the files and the access token Splitter API

curl -X 'POST' \ 'https://api.sheetize.cloud/splitter' \ -H 'accept: text/plain' \ -H 'Authorization: Bearer TheAccessToken' \ -H 'Content-Type: multipart/form-data' \ -F 'UploadFileRequest.OperationId=' \ -F 'UploadFileRequest.Files=@AFileName.xlsx;type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
The service will respond with a download URL for the processed file, in this example it is:

{ "name": "", "type": "1", "size": 900000, "description": "", "linkToDownload": "/download/TheFolderName/TheFileName.xlsx", "message": "", "statusCode": 200 }
Send a request that includes the file name and the folder name to Download API

curl -X 'GET' \ 'https://api.sheetize.cloud/download/TheFolderName/TheFileName.xlsx' \ -H 'accept: */*' \ -H 'Authorization: Bearer TheAccessToken'
You will receive the file and you can either use it or simply forward it to the next step of your workflow.