Conversion

The Metadata API is a purpose-built, developer-friendly service that puts complete control over spreadsheet-file metadata at your fingertips with just a single HTTP request. Whether you are dealing with classic office formats such as Excel (.xlsx, .xls), simple delimited files like CSV (.csv) and TSV (.tsv), or even Apple Numbers documents (.numbers), the API abstracts away the complexities of file parsing and lets you read, add, or modify key descriptive properties in a matter of milliseconds. Imagine being able to batch-process thousands of reports, research data sets, or financial statements, enriching each file with a consistent set of author information, titles, subjects, descriptions, keyword lists, and even custom tag collections that your own application defines. This level of automation not only saves countless hours of manual editing but also guarantees that every file you ship to clients, collaborators, or archival systems carries the exact metadata you need for indexing, compliance, and discoverability. The service works by accepting either the raw file bytes or a URL pointing to a cloud‑hosted document, then returns a new, fully‑formed file with the requested metadata changes applied without altering the original data layout or formulas.

Main Features

Because the API is stateless, you can easily integrate it into CI/CD pipelines, server-side batch jobs, or client-side JavaScript widgets, ensuring that every export from a web app or every periodic backup contains the correct provenance information. Security is baked in: all calls are made over TLS, the payloads are encrypted end‑to‑end, and the API supports API‑key or OAuth 2.0 authentication, allowing you to limit access to trusted services only. The underlying engine leverages highly optimized parsing libraries for each supported format, guaranteeing that even massive Excel workbooks with hundreds of worksheets are processed quickly; most typical requests complete in under 200 ms. In practice, this means you can build a seamless “Add Metadata” button inside your product that sends the file to the service, receives the enriched version, and offers it for immediate download—all without the user ever leaving the interface. The API also returns detailed operation logs, so developers can programmatically verify that the expected fields were updated, roll back changes if needed, or trigger further processing steps based on custom tag values. By providing a uniform, language‑agnostic REST endpoint, the Metadata API eliminates the need for developers to maintain multiple format‑specific libraries, reduces maintenance overhead, and ensures future‑proof compatibility as new spreadsheet standards emerge. Whether you are a SaaS vendor seeking to embed licensing information, a research institution cataloguing data sets, or an enterprise automating document compliance, this API offers a fast, secure, and scalable way to enrich your files with one simple call.

Documents

Parameters

AppRequest.Metadata: With PropertyName and PropertyValue
AppRequest.MetadataJson: If you are not using the Metadata structure then you must use json data type.
UploadFileRequest.OperationId: 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.
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 Metadata API

curl -X 'POST' \ 'https://api.sheetize.cloud/metadata' \ -H 'accept: text/plain' \ -H 'Authorization: Bearer TheAccessToken' \ -H 'Content-Type: multipart/form-data' \ -F 'AppRequest.Metadata={"propertyName":"string","propertyValue":"string"}' \ -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.