json

  1. D

    Missing JSON file option

    Hi, I've recently got the office 365 package as I have JSON files which I want to use within excel. When I select data > new query > get file > there is no option for JSON yet when I Google it the option should be there. Does anyone know how to fix this as I've checked the ribbon to make sure...
  2. W

    Import JSON to Excel

    Hey guys! I am having an issue importing JSON into Excel. I am using the VBA-JASON converter from GitHub and I the parse command woks fine. However, I can't get the loop working... I get an error saying 'Object is required' for the loop command, but I can't figure it out.. Don't judge me too...
  3. L

    json to excel VBA??

    Hi everyone, May I know if there is a solution to convert my json file to excel format... below data extracts from json... I would like to show 1sr row:add_amount,available_amount,budget_account_code,budget_account_name... 2nd row:0,0,R13006,A123... 3rd row:0,0R13006,A1234...
  4. A

    JSON Converssion Question

    I can successfully parse the CA Agile Rally API to return information into a worksheet, but the information returned in the description field is full of HTML tags. Is there any way to pull or publish the data in that field without the HTML tags? Sample Code: URL =...
  5. N

    PQ - Building an api JSON query that needs headers

    Hi, I've had a google of how to do this and have gotten stuck :( I would like to use excel to dl and parse data from www.teamgate.com I have already used the api to connect to klipfolio so I just need to get power query to work ! My (edited for security) details are : GET...
  6. V

    Login website and parsing json

    Hi, I've a code to import a Json text to excel. There is a way to do a web request to login to the site (probably get cookies too) and parse directly the json url? Sub ConverterJsonEfatura() Dim jsonText As String Dim jsonObject As Object, item As Object Dim i As Long Dim ws As Worksheet Set...
  7. S

    Convert JSON data to time series data in excel

    For the last 10 years or so I have wanted to convert JSON data to time series data in Excel. I never found an easy solution. This has irritated me. Coinmarketcap has an API for crypto currencies and JSON data https://api.coinmarketcap.com/v2/ticker/ https://api.coinmarketcap.com/v2/ticker/ {...
  8. J

    JSON data to excel

    How can I convert the following JSON data to an excel table.
  9. S

    Excel VBA API POST JSON conversion

    I have a spreadsheet with tracking information on it that I am trying to send through a API to create a tracking event. The issue I have is making sure my body is in JSON format. I have managed to parse my excel cells to JSON but now I need to know how to actually save this as a string instead...
  10. H

    "Inversing" the output of a JSON-request

    Hi all, I would welcome some help with the following macro: Sub getPrices() Dim strURL As String, strJSON As String, strTicker As String, strCurrency As String, strLength As String Dim i As Integer Dim i2 As Integer Dim http As Object Dim JSON As Object, Item As Object Dim LastColumn As Long...
  11. B

    Json to Excel error 424

    below script runs fine and i also get output in message box. But i keep getting error 424 (Object required) I have used ONLY Microsoft Scripting Library. Sub Test() Set Myrequest = CreateObject("WinHttp.WinHttpRequest.5.1") Myrequest.Open "GET"...
  12. J

    Json and loop through each line

    Hello, i have json files (a few) like here: { "Test" : "VB_variable", "Test2" : true, "Test3": "http://google.com", "attributes":[ { "cell":"VB_answer", "property": "highAvailability" } ] } All what i want to get list all values starting from VB*. I am trying to build...
  13. D

    Can Excel 2007 import from JSON data in real-time?

    I'm trying to create a file that pulls in real-time golf scores -- the PGA tour site appears to provide data JSON format (which I've never worked with) here: https://statdata.pgatour.com/r/014/leaderboard-v2mini.json I don't quite know how to parse that wall of text for use in Excel 2007. Later...
  14. 32CARDS

    JSON WEB QUERY FROM EXCEL---WHERE DO i START PROGRESSION ?

    I been using the same excel dynamic web query for over 10 years, it becane the basis for almost everything I know ab out Excel VBA Soon, all my work will be useless as far as web query is concerned, when the web page in question is progressivly "shut down" The web page is still there, in JSON...
  15. B

    JSON to Excel using VBA

    Hi all I've been trying to do this for quite a while. I've used VBA to hit their API to get data, which comes back in JSON format. I'm looking to convert JSON data to something more useful in excel, but so far have been struggling. The JSON file is in this format: <tbody>...
  16. Y

    Excel VBA JSON array url import and parse

    Hi everyone, I'm trying to import and parse the JSON data from the following link into excel using VBA: https://www.alphavantage.co/query?function=SMA&interval=daily&time_period=90&series_type=close&apikey=ES1RXJ7VF1C1L9N5&symbol=MSFT Unfortunately, i'm not able to complete it as it keeps...
  17. P

    JSON parse

    Hi, I'm looking for a way to parse a REST API in JSON format without any external modules (like from GitHub). Similar to libraries "Microsoft WinHTTP Services, version 5.1" or "Microsoft XML, v6.0" to parse an XML response, what library contains methods to parse JSON format? And what would be a...
  18. V

    Hidden Characters?

    I am my wits' end about this issue. The following code steps through the Output Sheet and writes 24 columns of data into 24 separate files. The file names are in a 3x8 grid on the Temp sheet. The data is being output into .json files for upload into ArcGIS. The code works beautifully for me with...
  19. Y

    What can I do to enhance the speed of this macro?

    Hi, I have a spreadsheet that has a list of URLs on Sheet2. The macro pulls the JSON data from each URL and then pastes them in a certain order on another sheet. Since the data pull is huge, it keeps freezing when i try to do all 196 URLs at once. But if i do them 50 at a time, it works just...
  20. G

    How to format import JSON feeds into standardized numerical values in an excel sheet: DOT and COMMA

    I made a scraper in an excel sheet with many importJASON functions that fetch numerical datas from various APIs. The problem is that the format isn't uniform and messes up my VBA calculations. It throws a lot of #REF ! #ERRORS ! etc The reason is that some datas come with decimal separators...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top