{"id":"2032800603630440450","url":"https://x.com/femininow/status/2032800603630440450","text":"you have fields with JSON -like strings in excel\nSelect the column\nGo to Data → From Table/Range\nIn Power Query:\nSelect column\nTransform → Parse → JSON\nPower Query will automatically expand the fields into single columns. \nWorks with large datasets as well, this had 1M+ rows","author":{"name":"TheDataJoy©","username":"femininow","avatarUrl":"https://pbs.twimg.com/profile_images/2042556734737100800/8K4na19I_200x200.jpg"},"createdAt":"Sat Mar 14 12:46:46 +0000 2026","engagement":{"replies":0,"retweets":2,"likes":14,"views":618},"adhxContext":{"savedByCount":1,"publicTags":[],"previewUrl":"https://adhx.com/femininow/status/2032800603630440450"}}