XML to CSV Conversion Guide

import pandas as pd
import xml.etree.ElementTree as ET

def xml_to_csv(xml_file, csv_file):
    # Parse XML file
    tree = ET.parse(xml_file)
    root = tree.getroot()
    
    # Extract data into list of dictionaries
    data = []
    for item in root.findall('.//item'):  # Adjust path as needed
        row = {}
        for child in item:
            row[child.tag] = child.text
        data.append(row)
    
    # Convert to DataFrame and save as CSV
    df = pd.DataFrame(data)
    df.to_csv(csv_file, index=False)
    print(f"Converted {xml_file} to {csv_file}")

# Example usage
xml_to_csv('data.xml', 'output.csv')

const fs = require('fs');
const xml2js = require('xml2js');
const { parse } = require('json2csv');

// Read XML file
const xml = fs.readFileSync('data.xml', 'utf8');

// Parse XML to JSON
xml2js.parseString(xml, (err, result) => {
  if (err) {
    console.error('Error parsing XML:', err);
    return;
  }
  
  // Extract data (adjust path for your XML structure)
  const data = result.root.item; // Adjust based on your XML
  
  // Convert to CSV
  const csv = parse(data);
  
  // Save to file
  fs.writeFileSync('output.csv', csv);
  console.log('Converted to CSV successfully!');
});

import javax.xml.parsers.*;
import org.w3c.dom.*;
import java.io.*;

public class XmlToCsvConverter {
    public static void main(String[] args) throws Exception {
        // Parse XML
        DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
        DocumentBuilder builder = factory.newDocumentBuilder();
        Document doc = builder.parse(new File("data.xml"));
        
        // Get elements
        NodeList items = doc.getElementsByTagName("item");
        
        // Write to CSV
        FileWriter writer = new FileWriter("output.csv");
        writer.write("id,name,price\n"); // CSV header
        
        for (int i = 0; i < items.getLength(); i++) {
            Element item = (Element) items.item(i);
            String id = item.getAttribute("id");
            String name = item.getElementsByTagName("name").item(0).getTextContent();
            String price = item.getElementsByTagName("price").item(0).getTextContent();
            
            writer.write(id + "," + name + "," + price + "\n");
        }
        
        writer.close();
        System.out.println("Conversion complete!");
    }
}