Parsing data from a JSON column

I had a quick look and couldn't find anything directly related to this but apologies if I missed something.

I have an excel sheet whereby one column is made of JSON data that is somewhat messy and I was hoping to filter it into multiple columns.

This is an example of the text in the JSON column:

{'gender': 'Male', 'nationality': 'IRL', 'document_type': 'passport', 'date_of_expiry': '2019-08-12', 'issuing_country': 'IRL'}
{'gender': 'Female', 'document_type': 'driving_licence', 'date_of_expiry': '2023-02-28', 'issuing_country': 'GBR'}

I have tried to use Text to Columns but I run into an issue because the data is jumbled so I end up with something like this:

Screenshot 2020-09-22 at 16.09.55.png

The problem with that is that 'nationality' and 'document_type' are added to the same column.

Ideally, I would like the data in something like this format:

Screenshot 2020-09-22 at 16.14.08.png

Can anyone help? I am quite new to Excel so please be as descriptive as possible