0

I have a data format that looks like this:

enter image description here

Do you know what is the best way to open it in excel so it reads properly un columns?

Thank you!

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
Suren Grigoryan
  • 91
  • 1
  • 9
  • 1
    Looks like Newline Delimited JSON also known as JSON Lines. See e.g. http://ndjson.org/, https://jsonlines.org/ – dbc Nov 12 '22 at 17:19
  • 1
    Json represents objects, so you'd need to first parse it, and then flatten it because the object contains other objects. – Mathieu Guindon Nov 12 '22 at 17:45
  • Thank you @MathieuGuindon. I have not done this before, is there a way to parse JSON directly to excel? – Suren Grigoryan Nov 12 '22 at 19:36
  • 1
    @SurenGrigoryan - Seems like you can do it with [tag:vba], see [Parsing JSON in Excel VBA](https://stackoverflow.com/q/6627652/3744182) or [Parsing JSON data into Excel sheet](https://stackoverflow.com/q/53771291). But to give a proper answer we would need to see a well-formed, complete JSON sample as **text** (not as a screen shot). – dbc Nov 12 '22 at 19:45
  • thank you @dbc i have posted a new question here: https://stackoverflow.com/questions/74416420/json-parsing-from-txt-file-to-excel – Suren Grigoryan Nov 12 '22 at 20:43

0 Answers0