Excel - upload jSON file and apply customization

%3CLINGO-SUB%20id%3D%22lingo-sub-2520480%22%20slang%3D%22en-US%22%3EExcel%20-%20upload%20jSON%20file%20and%20apply%20customization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2520480%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20In%20my%20project%20i%20need%20to%20work%20on%20jSON%20file%20in%20excel.%26nbsp%3B%20Here%20is%20jSON%20file%20structure%20..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%22id%22%3A%20%22b9adce3c-2599-4b07-ac70-0d575a78b60e%22%2C%3CBR%20%2F%3E%22type%22%3A%203%2C%3CBR%20%2F%3E%22expression%22%3A%20%2201_ABCD%22%2C%3CBR%20%2F%3E%22aggregation%22%3A%200%2C%3CBR%20%2F%3E%22caption%22%3A%20%22COUNTRY_1%22%2C%3CBR%20%2F%3E%22description%22%3A%20%22%22%2C%3CBR%20%2F%3E%22category%22%3A%20%22GEOGRAPHY%22%2C%3CBR%20%2F%3E%22operators%22%3A%20%5B%3CBR%20%2F%3E0%2C%3CBR%20%2F%3E5%2C%3CBR%20%2F%3E8%2C%3CBR%20%2F%3E9%3CBR%20%2F%3E%5D%2C%3CBR%20%2F%3E%22tables%22%3A%20%5B%3CBR%20%2F%3E%22F_DOLLAR%22%3CBR%20%2F%3E%5D%2C%3CBR%20%2F%3E%22format%22%3A%20%22%22%2C%3CBR%20%2F%3E%22hidden%22%3A%20false%2C%3CBR%20%2F%3E%22cbattr%22%3A%20%22%22%2C%3CBR%20%2F%3E%22sensitiveFlag%22%3A%20false%3CBR%20%2F%3E%7D%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20objective%20is%20to%20convert%20it%20in%20rows%20and%20columns%20in%20excel%20like%20this%20..%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheTallman_0-1625594617846.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293822i2E13F1C07BD11AF0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22TheTallman_0-1625594617846.png%22%20alt%3D%22TheTallman_0-1625594617846.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20real%20json%20file%20here%20pls%20confirm%20how%20i%20can%20do%20this%20in%20excel.%20If%20we%20can%20do%20this%20through%20any%20command%20button%20that%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2520480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi, In my project i need to work on jSON file in excel.  Here is jSON file structure ..

 

{
"id": "b9adce3c-2599-4b07-ac70-0d575a78b60e",
"type": 3,
"expression": "01_ABCD",
"aggregation": 0,
"caption": "COUNTRY_1",
"description": "",
"category": "GEOGRAPHY",
"operators": [
0,
5,
8,
9
],
"tables": [
"F_DOLLAR"
],
"format": "",
"hidden": false,
"cbattr": "",
"sensitiveFlag": false
},

 

My objective is to convert it in rows and columns in excel like this ..

TheTallman_0-1625594617846.png

 

I attached real json file here pls confirm how i can do this in excel. If we can do this through any command button that would be great.

 

0 Replies