json parse

  1. E

    Json Excel Square Brackets within Square Brackets Run-Time Error '1004'

    Hello, I have a json file which I am parsing to excel, but one of the fields I need to pull doesn't work. The only difference I can see between this field any all other fields, is that this field is within square brackets, whereas all my other fields are not. I get an error Application Defined...
  2. T

    Excel - Using jSON file in excel with customization

    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...
  3. L

    How to VBA Json parse an output with same name value on multiple levels

    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...
  4. W

    Above my ability level :-( (JSON Parsing/ Editing with VBA)-- I have attached my attempt

    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...
  5. A

    Converting json date time format

    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.
  6. S

    Transforming json with power query (mix of list and Text in a single column)

    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...
  7. A

    JSON into excel from vb string

    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...
  8. G

    Get a value from Json object

    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...
  9. O

    Parse JSON in Excel VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top