Home › APIs › Spreadsheets & data files
Spreadsheet Cleaner API
Tidies messy Excel or CSV files: extra spaces, empty rows and duplicate rows go away.
Used by: Office and finance teams, shop owners, data and integration developers.
Clean one or many Excel/CSV files: trim spaces, drop empty rows/columns, remove duplicate rows (all columns or one key column), turn numbers-stored-as-text into numbers, merge files by column name. Runs on our server, files are deleted right after the call, nothing stored.
Try it live, no sign-up
Run the example as is, or change the input. 5 own tries a day without a key.
Example request
curl -X POST https://radarbg.com/v1/spreadsheet-cleaner \
-H "X-API-Key: YOUR_KEY" -H "Content-Type: application/json" \
-d '{"fileName": "list.csv", "fileContent": "TmFtZSxRdHkKIEFubmEgLDEKQW5uYSwxCiwKQm9iLDIK"}'
Answer: {"ok": true, "count": N, "items": [...], "usage": {...}}. Failed calls are not counted.
Inputs
| Field | Type | Description |
|---|---|---|
fileContent | string | The file as base64 (a data: URI is fine) |
fileName | string | File name with extension, e.g. report.pdf |
files | array | Or several files: [{fileName, fileContent (base64)}] |
trimSpaces | boolean | Remove extra spaces |
dropEmpty | boolean | Remove empty rows and columns |
dedupe | boolean | Remove duplicate rows |
fixNumbers | boolean | Numbers stored as text -> numbers |
key | string | Duplicates by this column only (optional) |
format | string | xlsx or csv |
Price
Included in every plan: 500 calls a month free, then from €9 a month for 5,000 calls across all APIs. Pro, €29 for 25,000 calls, is the one we recommend.
Questions
What does the Spreadsheet Cleaner API do?
Tidies messy Excel or CSV files: extra spaces, empty rows and duplicate rows go away.
Where does the data come from?
Clean one or many Excel/CSV files: trim spaces, drop empty rows/columns, remove duplicate rows (all columns or one key column), turn numbers-stored-as-text into numbers, merge files by column name. Runs on our server, files are deleted right after the call, nothing stored.
How much does it cost?
500 calls a month are free with no card. Paid plans start at EUR 9 a month for 5,000 calls and include every API on Radar. Failed calls are not counted.
Can I use it without writing code?
Yes. Try it live on this page, use our free browser tools, or ask us to run it on your list as a service.