How to convert Excel XLSX into JSON in Python

I don’t think anybody has ever been keen about the prospect of coding around format conversions. It’s very dry, but it is quite necessary. To solve this problem, I present to you this lovely API that will allow you to convert between XLSX and JSON without the boring part. Here we go.

Install the client for the API with pip install:

pip install cloudmersive-convert-api-client

Calling convert_data_xlsx_to_json comes next.

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'
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['Apikey'] = 'Bearer'
# create an instance of the API class
api_instance = cloudmersive_convert_api_client.ConvertDataApi(cloudmersive_convert_api_client.ApiClient(configuration))
input_file = '/path/to/file' # file | Input file to perform the operation on.
try:
# Convert Excel XLSX to JSON conversion
api_response = api_instance.convert_data_xlsx_to_json(input_file)
pprint(api_response)
except ApiException as e:
print("Exception when calling ConvertDataApi->convert_data_xlsx_to_json: %s\n" % e)

And just like that, you can now make your file conversions. It really is that simple. Our APIs offer a ton of other solutions, too. If you need to then convert your JSON into XML, for example, you can apply convert_data_json_to_xml. Same easy process.