I have a series of gene id json files setup inside of a single excel cell.

Each cell is setup with 5 key:value pairs
Lets say they are Dog, Cow, Whale, Cat and Snake

Within one cell [{"Name":"Canus Bitus","Leg Number":"4","Lung Number":"1","LengthinFeet":"2.5","Poisonious":"no"},{"Name":"Moo Milker","Leg Number":"4", "Lung number":"4",etc...},{whale},{cat},{snake}]

How can I take that string and turn each key:value into a column? {dog}col1 {cow}col2 {whale}col3 {cat}col4 {snake}col5

Yes... this should be done in python but nothing is documented so I am creating the process 'as is' in excel, then upgrading to a tool designed for this century.