RadarPricesOrder

Home › APIs › Spreadsheets & data files

Spreadsheets & data files

XML to Excel API

In plain words

Turns an XML file (orders, feeds, exports) into an Excel table.

Used by: Office and finance teams, shop owners, data and integration developers.

Turn XML (feeds, exports, orders) into an Excel or CSV table: finds the repeating row element, flattens attributes and nested tags. 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/xml-to-excel \
  -H "X-API-Key: YOUR_KEY" -H "Content-Type: application/json" \
  -d '{"fileName": "orders.xml", "fileContent": "PG9yZGVycz48b3JkZXIgaWQ9JzEnPjxpdGVtPlBlbjwvaXRlbT48cXR5PjM8L3F0eT48L29yZGVyPjxvcmRlciBpZD0nMic+PGl0ZW0+Qm9vazwvaXRlbT48cXR5PjE8L3F0eT48L29yZGVyPjwvb3JkZXJzPg=="}'

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)}]
rowTagstringRow element name (optional, auto-detected)
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 XML to Excel API do?

Turns an XML file (orders, feeds, exports) into an Excel table.

Where does the data come from?

Turn XML (feeds, exports, orders) into an Excel or CSV table: finds the repeating row element, flattens attributes and nested tags. 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.
Spreadsheet Cleaner APITidies messy Excel or CSV files: extra spaces, empty rows and duplicate rows go away.