XML to CSV / Excel

 

XML




CSV / TSV






Options for XML output




Options for CSV input / output









This tool allows you to Convert XML to CSV, Convert XML to Excel and Convert CSV to XML. It managed also the TSV files (Tabulation Separated Values).

If you want convert CSV data: The first line of the file must include a header with a list of the column names.

You can see the user guide to help you to use this online converter.

User guide

To convert XML data:

  • Drag and drop your XML file or copy / paste your XML text directly into the editors above.
  • As soon as the editor detects a valid XML, it displays the result.
  • In order to download the results you must click on "Download CSV" button.
  • In order to download the results in Excel file you must click on "Download Excel" button.
  • You can also copy the result to the clipboard by clicking on the button "Copy to clipboard".

To convert CSV data: It's analogous to the xml conversion.

Above the editors, you can set the options:

  • Select the separator of CSV / TSV
  • Indicate whether to parse the numbers in CSV
  • Root and element tags to generate the XML file


Why convert CSV to XML ?

CSV file format is a useful for import or export data from databases (example: import data from a CSV file into a table) or softwares. It is easy to use, data published on the Web is commonly published as CSV files.

For developers, it may be more convenient to work on data in xml format, XML format allow easily to send data to and from a server (SOAP web services). Indeed you can find one or more robust and widely-used libraries for parsing and formatting XML in any programming languages.

This online converter tool allows you to convert your CSV data directly into XML format, so your data can more easily be processed.


Why convert XML to CSV ?

A lot of software handles the XML, but it can sometimes be useful to convert this data for importing in others softwares (many people use excel to visualize data). For example, a CSV file can easily be integrated into a database.

This online converter tool allows you to convert your XML file directly in CSV, TSV and Excel format.

You can report a bug or give feedback by adding a comment (below) or by clicking "Contact me" link (at the top right hand corner of the page).

Comments