Read data from Excel and convert them to JSON!

In this example, we're going to read an Excel spreadsheet and convert into JSON format.

For this purpose, we have an Excel spreadsheet with four columns.

With following script in Python, we can load the spreadsheet and convert it to JSON format:

import xlrd from collections import OrderedDict import simplejson as json   # Open the workbook and select the first worksheet wb = xlrd.open_workbook('excel-xlrd-sample.xls') sh = wb.sheet_by_index(0)   # List to hold dictionaries cars_list = []   # Iterate through each row in worksheet and fetch values into dict for rownum in range(1, sh.nrows): cars = OrderedDict() row_values = sh.row_values(rownum) cars['car-id'] = row_values[0] cars['make'] = row_values[1] cars['model'] = row_values[2] cars['miles'] = row_values[3]   cars_list.append(cars)   # Serialize the list of dicts to JSON j = json.dumps(cars_list)   # Write to file with open('data.json', 'w') as f: f.write(j)