RadarPricesOrder

Home › APIs › Spreadsheets & data files

Spreadsheets & data files

Spreadsheet Cleaner API

In plain words

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

FieldTypeDescription
fileContentstringThe file as base64 (a data: URI is fine)
fileNamestringFile name with extension, e.g. report.pdf
filesarrayOr several files: [{fileName, fileContent (base64)}]
trimSpacesbooleanRemove extra spaces
dropEmptybooleanRemove empty rows and columns
dedupebooleanRemove duplicate rows
fixNumbersbooleanNumbers stored as text -> numbers
keystringDuplicates by this column only (optional)
formatstringxlsx 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.

Related APIs

CSV Splitter APICuts a big Excel or CSV file into smaller files, each with the header row.
CSV to vCard APITurns a contact list from Excel or CSV into a file your phone or Outlook can import.
Data Converter APIConverts between CSV, Excel and JSON files, so any program can open your data.
List Compare APICompares two lists and shows what is only in one, only in the other, and in both.
XML to Excel APITurns an XML file (orders, feeds, exports) into an Excel table.