XML and CSV validator online

Paste XML or CSV and choose the format. The tool reports every problem with line, column and an explanation – for CSV also the detected delimiter and a preview of the first rows. Nothing is uploaded.

Paste your text – it is checked on every change.

Your text stays in your browser – it is not sent, not stored and not added to the address bar.

Your inputs are saved in this browser only.

Result

Result
✓ Well-formed XML
Overview
Root element: <order> · Elements: 8 · Attributes: 8 · Depth: 3

How it is calculated

XML: what “well-formed” means

An XML document is well-formed when it follows the syntax rules of the W3C Recommendation XML 1.0 (Fifth Edition). The tool checks this with its own parser – with the same message in every browser – and stops at the first violation:

No validation against a DTD or schema

The tool does not check whether the document matches a DTD, an XML Schema (XSD) or a standard such as UBL – i.e. whether required elements exist or values have the right format. Well-formedness is the precondition for that: every program rejects a document that is not well-formed. A DOCTYPE declaration is read only far enough to recognise the entities declared in it. Namespace prefixes without an xmlns:… declaration are reported as a warning.

CSV according to RFC 4180

RFC 4180 describes the common CSV format:

RFC 4180 only knows the comma. Spreadsheets in many European locales save CSV with a semicolon because the comma is the decimal separator there; tab and | are common too. Automatic detection counts the fields of the first 50 records for each candidate and picks the character that most consistently yields at least two columns. If that is wrong, choose the delimiter manually.

The tool reports differing field counts, unclosed or misplaced quotes and blank lines in the middle of the file – with the actual line number (a field containing a line break spans several lines). RFC 4180 requires CRLF line endings; since practically every program also reads LF, the line ending is only shown in the overview.

Limits

At most 5 million characters; the first 50 errors are listed. Columns count characters starting at 1, a tab counts as one character.

Frequently asked questions

Is my data uploaded?

No. The check runs entirely in your browser. The text is not added to the address bar and not saved – the link only contains the format, delimiter and header option.

What is the difference between well-formed and valid?

Well-formed means the XML syntax is correct (tags, nesting, attributes, entities). Valid additionally means the document follows the rules of a DTD or XML Schema. This tool checks well-formedness only.

Why is &amp;nbsp; an error?

&nbsp; is an HTML entity. Without a DTD, XML only knows five: &lt; &gt; &amp; &apos; &quot;. Write a non-breaking space as &#160; or insert the character directly.

Excel shows my CSV file in a single column – why?

Usually the delimiter: Excel with a European locale expects semicolons while the file uses commas (or the other way round). The tool shows the detected delimiter. In Excel, “Data → From Text/CSV” lets you choose it.

Why does a row have too many fields?

Almost always the delimiter appears inside a value that is not quoted – e.g. Smith, John in a comma-separated file or 1,50 as a decimal. The correct form is "Smith, John".

Sources and legal basis

As of:

Related tools