Home icon
Data Visualisation Guide

XML files

2 minutes read

Data file formats

Less common in data visualisation than CSV and XLSX files, but still important for exchanging data, is the XML format. XML stands for Extensible Markup Language, and it was designed to be both readable by humans as well as by computers.

Like CSV files, XML files can be opened and edited with any text editor. XML contains elements which each have a start and end tag (this is called the markup), with the element content embedded in between them.

<note>
  <date>2015-09-01</date>
  <hour>08:30</hour>
  <to>Tove</to>
  <from>Jani</from>
  <body>Don't forget me this weekend!</body>
</note>

From the example XML above, you can see that XML data is not tabular. XML data is hierarchical, with parent elements containing child elements.

Microsoft Excel can import and export XML, but because the structure of data stored in an XML file can be complex, importing XML is not straightforward.

Examples of XML are the data exported from the iPhone Health app and the GPX file format used by GPS devices. HTML, the language for displaying web pages in a browser is also based on XML.

<p>My cat is <strong>very</strong> grumpy.</p>

Related pages

Excel files

RAWGraphs

Datawrapper

Flourish

CSV files

PDF files

Data file formats