for row in ws.iter_rows():
    name = row[0].value
value = row[1].value
data[name].append(value)
for key, valuelist in list(data.items()):
    value = ','.join(valuelist)
with open(key + '.txt', 'w') as f:
    f.write(value)
Fastest Way To Run Through 50k Lines of Excel File in OpenPYXL