How do I load and filter JSON with Excel?

Occasional Contributor I was to filter by the color Red, i.e. just see the rows "foo" and "bar".


How do I do that in Excel?



My own attempt was

2 Replies
best response confirmed by kaihendry (Occasional Contributor)

@kaihendry After converting the list to a table, click on the button with the two arrows to expand Column1

Screenshot 2020-09-20 at 07.17.12.png

Screenshot 2020-09-20 at 07.17.27.png

Do the same again for the color column, choose "Expand to new rows"

End result:

Screenshot 2020-09-20 at 07.18.05.png

Is that what you had in mind?





I was hoping that it wouldn't mean splitting into rows, since my JSON has many embedded lists, so there is effectively a LOT of repeating rows (besides one column).