Replace
Welcome to the Replace API documentation—a streamlined solution for transforming the content of your spreadsheet files with a single, powerful call. Whether you work with the ubiquitous Excel formats (.xlsx, .xls, .xlsm), simple CSV and TSV files, or Apple Numbers (.numbers) documents, our API understands them all and offers a consistent interface for making precise text replacements. By defining clear equality conditions, you can pinpoint exactly which cells should be altered and supply the new values you need, eliminating the guesswork and manual effort that often accompany bulk data edits. This makes the API an ideal companion for tasks such as data cleansing, where you need to correct recurring errors across large datasets, or localization projects that require systematic substitution of language-specific terms. The design philosophy behind Replace is to keep the process fast, secure, and developer-friendly, letting you integrate spreadsheet modifications into your existing workflows without sacrificing performance or safety.
Main Features
Beyond its core replacement capabilities, the Replace API is built to handle the practical realities of modern data handling. It processes files in memory where possible, reducing the need for intermediate storage and speeding up operations even on sizable spreadsheets. Robust authentication and encrypted transmission ensure that your sensitive data remains protected throughout the transaction. The API's response structure provides clear feedback about which cells were modified, how many replacements were performed, and any rows that did not meet the specified conditions, giving you full visibility into the transformation process. Whether you're cleaning up a legacy data dump, preparing a product catalog for a new market, or simply automating repetitive spreadsheet updates, this API gives you the confidence to reformat your data reliably with minimal code and maximum control.
Documents
Parameters
- AppRequest.Replace: The text you want it to be replaced
- AppRequest.With: The replacement text
- 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 Replace API
curl -X 'POST' \ 'https://api.sheetize.cloud/replace' \ -H 'accept: text/plain' \ -H 'Authorization: Bearer TheAccessToken' \ -H 'Content-Type: multipart/form-data' \ -F 'AppRequest.Replace=TheTargetedText' \ -F 'AppRequest.With=TheText' \ -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.
