Search

Welcome to the comprehensive guide for our Search and Extract API, a versatile tool designed to simplify the way you locate and retrieve information from a wide variety of spreadsheet formats. Whether you’re working with classic Excel files (.xlsx, .xls, .xlsm), simple CSV or TSV documents, Apple Numbers spreadsheets, or many other supported types, this API provides a single, consistent interface that abstracts away format‑specific quirks. By submitting a single request, you can scan entire workbooks, pinpoint every occurrence of your target text, and receive the results in a clean, structured text file that includes both the matched values and their exact cell coordinates. This powerful combination of flexibility and precision makes the API ideal for tasks ranging from compliance audits and automated reporting to deeper data mining and analytics workflows.

Main Features

Built with developers in mind, the API delivers lightning-fast performance without compromising accuracy, ensuring that even large datasets are processed efficiently. Its intuitive design means you can integrate sophisticated search capabilities into your applications with minimal effort—no complex configuration or multiple calls required. The output format is straightforward to parse, enabling seamless downstream handling, whether you’re feeding the results into a reporting engine, storing them for archival purposes, or feeding them into another data pipeline. Dive into the sections below to learn how to authenticate, craft your search query, handle pagination, and customize the extraction parameters to match your specific use case. With this API, finding the data you need becomes a single, effortless call.

Documents

Parameters

text: The text you are looking for
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 Search API

curl -X 'POST' \ 'https://api.sheetize.cloud/search?text=TheText' \ -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.