English

DATA CONVERTER

XML & TSV Converter

Turn repeated XML records into TSV or build reviewable XML data from a TSV table.

Free to useEnglish explanationClear method and limits
Updated

PRIVATE BROWSER WORKSPACE

XML & TSV Converter

Conversion runs locally. Review the mapping preview and any data-shape warnings before copying or downloading the result.

VISIBLE RESULT

Review the output

Run the tool to display a result. Nothing is copied or downloaded silently.

Method
Turn repeated XML records into TSV or build reviewable XML data from a TSV table.
Privacy
Ordinary text, code, and files remain in the current browser tab. Reset clears the working state.
Limit
Structured data is limited to 1,000,000 characters, 20,000 data rows, 200 columns, and 200,000 cells.

METHOD & CONTEXT

Use XML and TSV without hiding data-shape changes

This tool helps you select repeated XML records and place their values and attributes into TSV columns, or wrap TSV rows in simple XML row elements. It is intended for feeds that need tabular inspection without comma conflicts. Paste a small representative sample first, choose the direction, and compare the visible result with the source before you use a larger file. The page never sends the working data to NexaCurrent, so ordinary conversion stays inside the current browser tab.

Try repeated event elements with code attributes, titles, dates, and city names. The result area reports the row count and shows the output column paths. Check that nested values and identifiers appear in the intended columns before using the result. If the two formats describe data differently, the page explains the exact compromise instead of simply announcing that the conversion succeeded. That review step matters whenever the result will feed another application.

Choose the direction and column-path behavior

Use the first conversion button for the direction named on its label and the second button for the reverse direction. Keep the path-preserving choice for nested input. A heading such as /address/city identifies where a value came from and avoids collisions between similarly named fields. Readable dot-separated headings such as address.city are easier to scan, but they do not retain enough information to rebuild nesting automatically.

For table downloads, ordinary UTF-8 works in modern editors and data tools. The UTF-8 with BOM option adds a small marker to the downloaded copy for spreadsheet programs that otherwise guess the wrong character encoding. The marker is not added to the visible result. Copy the visible text when you want clean clipboard data, or use the named download when you need a file.

Read the mapping preview before using the result

The mapping preview lists the columns produced or read by the conversion. Check that important identifiers, names, dates, amounts, and nested values are present. TSV has no native element order, namespaces, comments, or mixed-content model. A warning is therefore useful information, not a generic error. It tells you where a reverse conversion may differ from the original even though the output remains syntactically valid.

Empty table cells remain empty strings on conversion back to JSON or YAML because guessing null, zero, false, or a missing value would silently change meaning. Numbers and booleans also remain strings after a table round trip. If the destination has a schema, apply its type rules after conversion and validate a few known records. Keep the original source until that comparison is complete.

Handle XML attributes, repeated elements, and table fields

XML attributes appear with visible @_ path names, repeated elements can become table rows, and Unicode text remains UTF-8. CSV and TSV fields are quoted when they contain delimiters, quotation marks, or line breaks. Comments, processing instructions, CDATA boundaries, namespaces, and exact mixed-text order do not fit fully inside a two-dimensional table.

When several unrelated XML collections are present, the converter selects the largest repeated record collection and tells you which path was used. Split unrelated collections into separate conversions. For reverse conversion, table rows use explicit rows and row elements; rename or validate them if the receiving system requires a private XML schema.

Limits, errors, privacy, and a practical final check

Empty input, malformed XML, document type declarations, invalid XML field names, excessive nesting, inconsistent row widths, duplicate headings, unclosed quoted fields, and oversized data stop with a visible message. The page limits input, rows, columns, and total cells so an accidental paste cannot freeze the tab. For very large datasets, use a streaming desktop or command-line workflow instead.

Reset clears the input, result, mapping notice, warnings, and download from this page. Before sharing a converted file, open it in the intended destination, count the records, inspect several rows with punctuation or non-English text, and confirm the fields used as identifiers. A successful conversion confirms the rules shown here; it does not prove that a private schema, business rule, or third-party importer will accept every value.

KEEP EXPLORING