Conversion
Welcome to the Merger API documentation! This powerful service lets you seamlessly combine multiple spreadsheet files into a single, cohesive document with just one API call. Whether you're working with Apple Numbers, CSV, TSV, Excel (.xlsx, .xls), or a variety of other formats, Merger handles the conversion and merging process for you. Choose to consolidate all data into a single sheet for a flat view, or preserve the original structure by placing each source file on its own separate sheet. The API is built for speed, security, and developer friendliness—so you can integrate it into your workflow with minimal effort and maximum reliability.
Main Features
In the sections that follow, you'll find detailed guidance on authentication, request formatting, and response handling. We'll walk you through practical examples for both single-sheet and multi-sheet merges, show you how to fine-tune options like column alignment and data type preservation, and explain error handling strategies to keep your integration robust. By the end of this documentation, you'll be equipped to automate data consolidation across any number of files, freeing up valuable time and reducing the risk of manual errors. Let's get started and unlock the full potential of your data with Merger!
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.
-
Send a request that includes the files and the access token Merger API
curl -X 'POST' \ 'https://api.sheetize.cloud/merger' \ -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.
