CSV to XML,JSON Converter

To convert CSV (Comma-Separated Values) files to JSON or XML format, you can use tools or scripts that process the CSV data and output it in the desired format.

1. CSV to JSON Conversion:
The CSV to JSON conversion involves converting rows of a CSV file into a structured JSON object, where each row becomes an element in a JSON array.

CSV to JSON Example:
CSV Input:

c

name,age,city
John,30,New York
Alice,25,Los Angeles
Bob,35,Chicago
Converted JSON Output:

json

[
{
"name": "John",
"age": 30,
"city": "New York"
},
{
"name": "Alice",
"age": 25,
"city": "Los Angeles"
},
{
"name": "Bob",
"age": 35,
"city": "Chicago"
}
]
2. CSV to XML Conversion:
In the CSV to XML conversion, each row of the CSV becomes a <row> element in the XML, and each column becomes a corresponding child element inside that row.

CSV to XML Example:
CSV Input:

csv

name,age,city
John,30,New York
Alice,25,Los Angeles
Bob,35,Chicago
Converted XML Output:

xml

<rows>
<row>
<name>John</name>
<age>30</age>
<city>New York</city>
</row>
<row>
<name>Alice</name>
<age>25</age>
<city>Los Angeles</city>
</row>
<row>
<name>Bob</name>
<age>35</age>
<city>Chicago</city>
</row>
</rows>
Tools for Conversion:
If you're looking for automated tools to convert CSV to JSON or CSV to XML, here are a few options:

Online Tools:
CSV to JSON:

CSVJSON: A simple tool to convert CSV to JSON.
ConvertCSV: Another tool to convert CSV files to JSON.
CSV to XML:

CSV to XML Converter: A web tool to convert CSV to XML.
CSV to XML - Free Tool: A free tool to convert CSV data to XML format.
Command Line (Scripts):
If you are comfortable with scripting, you can use command-line tools or write simple scripts for this conversion.

CSV to JSON using Python:
python

import csv
import json

csv_file = 'input.csv'
json_file = 'output.json'

# Read CSV and write to JSON
with open(csv_file, mode='r') as infile:
reader = csv.DictReader(infile)
rows = list(reader)

with open(json_file, mode='w') as outfile:
json.dump(rows, outfile, indent=4)
CSV to XML using Python:
python

import csv
import xml.etree.ElementTree as ET

csv_file = 'input.csv'
xml_file = 'output.xml'

# Create the root element
root = ET.Element("rows")

# Read CSV and create XML structure
with open(csv_file, mode='r') as infile:
reader = csv.DictReader(infile)
for row in reader:
row_elem = ET.SubElement(root, "row")
for key, value in row.items():
child = ET.SubElement(row_elem, key)
child.text = value

# Save to XML file
tree = ET.ElementTree(root)
tree.write(xml_file)
Conclusion:
CSV to JSON converts your tabular data into a structured JSON array, where each row becomes an object.
CSV to XML represents your tabular data as an XML document, with each row as an XML element.
You can use online tools, command-line scripts, or programming languages like Python to automate these conversions.