Forum Discussion
Json to excel
Hi Experts,
I have interesting question to convert Json data to excel tabs.
Attached is the json data to convert in excel
below is the attached format of excel data is required.
| Domain | Country | Redirect type | Path | tracking code | Activation | startDate | endDate: | options: | type: | creationUser: | creationTime: | |
Hi rahul_oberoi
The file you attached doesn't seem to represent a valid Json document. Parsing the attached one with Power Query gives:
If you're interested please attach a valid Json document as a plain text file
=filterxml(webservice("http://e.anyoupin.cn/eh3/?preg_match_all~""domains"": \[\s*""(.*)""~" & A2),"/document/items[2]/items")
Dear Expert,
Thanks for your reply, But when I open the attached excel I can see value as below .
Please help!
- Yes,because I edit the formula on my Android Excel App which not support webservice.
So you 'd better edit it and press enter or mannually input or copy the formula to the cell on your desktop PC which will make it work.
