How to Convert CSV to XML in Python

The CSV format is ideal for inputting large sets of data without worrying about any formatting or program specifications. If this data is needed for a more web-focused purpose, however, you may need to change it to a viewer-friendly, machine-readable file format. The following API will allow you to convert CSV files to XML automatically; the parameters only require the input file with an option for specifying the use of column names from within your CSV.

Image for post
Image for post

To use this API, run this command to install the SDK:

pip install cloudmersive-convert-api-client

Then, you can call the function:

from __future__ import print_function
import time
import cloudmersive_convert_api_client
from cloudmersive_convert_api_client.rest import ApiException
from pprint import pprint
# Configure API key authorization: Apikey
configuration = cloudmersive_convert_api_client.Configuration()
configuration.api_key['Apikey'] = 'YOUR_API_KEY'
# create an instance of the API class
api_instance = cloudmersive_convert_api_client.ConvertDataApi(cloudmersive_convert_api_client.ApiClient(configuration))
input_file = '/path/to/inputfile' # file | Input file to perform the operation on.
column_names_from_first_row = true # bool | Optional; If true, the first row will be used as the labels for the columns; if false, columns will be named Column0, Column1, etc. Default is true. Set to false if you are not using column headings, or have an irregular column structure. (optional)
try:
# Convert CSV to XML conversion
api_response = api_instance.convert_data_csv_to_xml(input_file, column_names_from_first_row=column_names_from_first_row)
pprint(api_response)
except ApiException as e:
print("Exception when calling ConvertDataApi->convert_data_csv_to_xml: %s\n" % e)

You can retrieve the API Key from Cloudmersive at no cost and with no commitment. This will give you access to 800 monthly calls across our library of APIs.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store