json parse

Hi All, In my one of the project, I need to use jSON file in excel in following manner so that I can tie up its columns with excel data. For example - In my workbook there is a TAB like this .. I want that User should be able to choose a particular json file from browse button in excel...

Hi I have a json outfile that looks like this. As you can see both the name "data" occurs twice in the structre, and below "stages" each stage "ID" have the same name "ID" - I am trying to get all the different stage "id"s into 10 different colums (and then go through all objects to fill those...

Hello All! Hope you can help because I think I'm in on more than I can handle on this one. I have linked 2 files. One is titled "xepg.json" and one titled "JSONCHANNELNUMBEREDIT.xlsm". My goal is to get a json file imported to excel as a table (columns and rows) that can be easily edited and...

Hi, I have a column full of json dates & times like this-> /Date(1457355600000). I need to convert this to 07/03/2016 1:00PM but am a bit bamboozled.

Hi anvg/all, I'm facing another issue in one of my feeds. ThI'm facing another issue in one of my feeds. This is also due to mix of list and text value in a single column. Please note that this is related to...

Good morning all, Im in a real pickle and in need of some help from some experts out there, Im trying to get a web API through vb(done) then get the data from it into cells. The data is returned in JSON, which is where im stuck. Its basically a Q&A database, each question has a ref no...

I dont know if this is possible in excel and need your advice. If I enter the below url in the browser,I get a Json object with a "is_verified" parameter either true or false. https://graph.facebook.com/fql?q=SELECT%20is_verified%20FROM%20page%20WHERE%20username=%22nokia%22 This is what i get...

Hello, I am trying to parse the google analytics api response text but I am having trouble. What I have been working on doing is extracting the profile information in my companies google analytics accounts. Here's a sample of what the data looks...