Forum Discussion

Copper Contributor

Sep 12, 2020

Excel can Convert JSON data to Table in Excel

Hi, Actually i am getting data from external source through API by using "From Web" option in excel & getting JSON data. But after getting data in excel, trying to transform that JSON data into T...

Excel Query.xlsx23 KB

Copper Contributor

Sep 13, 2020

Hi Riny_van_Eekelen ,

I have got that JSON data by using an API, nothing more than that.

Thanks for your solution, the solution you provided is exactly what i needed. But, i need to know why you copied the columns A & B to columns E & F. Why don't you do on the columns i have given.

I have tried in original columns it is not working. Will you please elaborate how can i proceed with that. Let me know if any issues if we do on the same columns.

Thanks

Sridhar Dasari

Riny_van_Eekelen

Platinum Contributor

Sep 13, 2020

SridharDasari When I worked on my initial answer I had some error messages form the original data. Can't remember exactly what. Didn't have much time so decided to just copy it to get a clean start, assuming you would be able to adopt my query to your own file.

Now, I had a chance to apply the same steps to your original data, called "Table5".