import json with open('log_file.txt', 'r') as f: lines = f.readlines() dings_list = [] macs_list = [] new_line = None for line in lines[1:]: new_line = line[:line.rfind(',')] almost_json = new_line.replace('""', '"') #print(almost_json) new_json = json.loads(almost_json[1:-1]) ding_id = new_json['ding_id'] mac = new_json['device_id'] #print(ding_id) dings_list.append(ding_id) macs_list.append(mac) with open('dings.txt', 'w') as f: f.write('\n'.join(dings_list)) with open('macs+dings.csv', 'w') as f: f.write('mac,ding\n') result = zip(macs_list, dings_list) for x, y in result: f.write(f'{x},{y}\n')