 <p>Thank you so much! You guys are life saver! This is the code that I eventually come up with it. I think it is the combination of all answers!</p> <pre><code>import json table = [] with open('simple.json', 'r') as f: for line in f: try: j = line.split('|')[-1] table.append(json.loads(j)) except ValueError: # You probably have bad JSON continue for row in table: print(row) </code></pre>