Rename, reorder and exclude spreadsheet columns with a point-and-click interface, and each column becomes an XML element. Download the result instantly — everything runs in your browser.
Free plan: 5 files/month. First 3 require no account.
Drag and drop an .xlsx or .xls file. TangoText reads your headers and data instantly — no upload, no waiting.
Rename, reorder or exclude columns as needed. Each column becomes an element in the XML, and dash-separated names such as address-city build nested elements.
Click Generate Output. TangoText produces well-formed XML, a <data> root with one <record> per row, and you download it directly to your computer.
Each column’s output name becomes its element name. Use dash-separated names for nested XML, and add optional header and trailer rows.
Standardise dates, numbers, and text before they appear in the XML. Convert mixed date formats to ISO 8601, fix number formatting, clean up case — all available free.
Automatically flags PII columns, mixed date formats, blanks, and duplicate IDs in your spreadsheet before you export — one-click fixes included.
Run 30 rule types against your data — required fields, value lists, numeric ranges, regex — before writing the XML. Catch errors at the source.
Mask sensitive fields before writing XML. Scramble values, keep their format, or hide all but the last characters. Repeatable masking available with a passphrase.
Save your XML structure, column mappings, and Format Values rules as a template. Reprocess next week's file in seconds (Solo & Team plans).
TangoText reads .xlsx and .xls files. If a workbook has several sheets, the first sheet is loaded and you are told so, so move the sheet you need to the front.
All processing runs in JavaScript in your browser. Your spreadsheet is never sent to any server — ever.
XML consumers — APIs, downstream systems, data warehouses — expect consistent formats. Format Values normalises your data on the way out. Free on all plans.
Mar 25, 2024 / 2024/03/25 / 25-Mar-2024 all become the same output — 2024-03-25 or any format you choose.
Strip commas and currency symbols, set decimal precision, or add zero-padding for consistent numeric fields in XML.
Trim whitespace, normalize case, remove unwanted characters. " jane SMITH " → "Jane Smith".
Phone → (416) 555-1234. SSN/SIN → 123-45-6789. Postal codes to their canonical forms.
<data> root with one <record> per row. You can rename, reorder and exclude columns, and use dash-separated names such as address-city to build nested elements. TangoText does not currently write XML attributes or let you rename the root and row elements.No upload. No install. No credit card. Your data never leaves your machine.
Open TangoText free →Free: 5 files/mo · Solo from $7.50/mo · Team from $24.17/mo