Textyou 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
