Converting CSV to XML requires mapping table data into a hierarchical structure, converting each row into a element, and column headers as sub-tags. You can use Python scripts to customize the conversion and process special characters, or use online tools or Excel to quickly convert. Finally, you need to verify the correctness of the XML format.

Converting a CSV file to XML format involves transforming tabular data into a structured, hierarchical format. This can be done using programming languages, online tools, or built-in software features. Here's how you can do it effectively.

Understand the Structure

CSV files store data in rows and columns, while XML represents data with nested tags. Before converting, decide how each row and column will map to XML elements.

• Each row in the CSV typically becomes an XML element (eg, ).
• Column headers usually become child element names (eg, , ).
• Ensure special characters in data are properly escaped to avoid XML errors.

Use Python for Custom Conversion

Python offers simple and flexible ways to convert CSV to XML using built-in modules like csv and standard string operations.

import csv
<p>def csv_to_xml(csv_file, xml_file):
with open(csv_file, 'r') as f:
reader = csv.DictReader(f)
xml_rows = ['<?xml version="1.0" encoding="UTF-8"?>', '<data>']
for row in reader:
xml_rows.append(' <record>')
for key, value in row.items():</record></data></p><h1> Escape special characters</h1><pre class='brush:php;toolbar:false;'> value = value.replace(&#39;&&#39;, &#39;&amp;&#39;).replace(&#39;<&#39;, &#39;&lt;&#39;).replace(&#39;>&#39;, &#39;&gt;&#39;)
            xml_rows.append(f&#39; <{key}>{value}</{key}>&#39;)
        xml_rows.append(&#39; </record>&#39;)
    xml_rows.append(&#39;</data>&#39;)

with open(xml_file, &#39;w&#39;) as f:
    f.write(&#39;\n&#39;.join(xml_rows))

Usage

csv_to_xml('input.csv', 'output.xml')

Use Online Tools or Excel

If coding isn't an option, use these alternatives:

• Online converters: Websites like ConvertCSV, OnlineConvert, or FreeFormatter let you upload a CSV and download XML output.
• Microsoft Excel: Open the CSV, then save as “XML Data” format. You may need to define an XML schema first under Developer tab > Source.

Validate the Output

After conversion, check that the XML is well-formed.

• Open the file in a browser or XML editor.
• Look for missing tags, incorrect nesting, or unescaped characters.
• Use an online validator like XML Validation Tool to confirm syntax.

Basically, choose the method based on your technical comfort and data complexity. Python gives full control, while online tools offer speed for simple tasks.

The above is the detailed content of How to convert a CSV file to XML format. For more information, please follow other related articles on the PHP Chinese website!