ADHX

Found something good?

Save it before you doomscroll past it.

TheDataJoy©

TheDataJoy©

@femininow

2mo ago

you have fields with JSON -like strings in excel
Select the column
Go to Data → From Table/Range
In Power Query:
Select column
Transform → Parse → JSON
Power Query will automatically expand the fields into single columns.
Works with large datasets as well, this had 1M+ rows

0214618
Keep it forever

Create a free account to save everything you preview — private to you.

Preview another link

Works with X, Instagram, TikTok & YouTube.

One place for everything
Tweets, TikToks, Reels, Shorts & articles in one searchable home.
Media at your fingertips
Full-screen viewer for photos and video — save any post to your collection.
Actually find it later
Full-text search across everything you save.
@femininow: "you have fields with JSON -like strings in excel…" | ADHX