You are viewing a single comment's thread from:

RE: How to Parse Custom JSON Data using Excel

in #excel5 years ago

Hi Paula,
I was following the example and hit a snag. When I try to parse, I receive an error message. I tried to research this on the internet to no avail. My screen looks exactly like the one above, but when I parse, every row in the json_metadata column says Error. What might I be doing wrong?

Sort:  

I have just come back to try this now and I am also getting the same error

Hi @coop78 and @dernan I have updated the post to contain download links to files for the activities. When you copy and paste the tables into excel, the json field is not recognized as a json field. So please work of the downloads.