+ Reply to Thread
Results 1 to 2 of 2

Power Query/VBA JSON Extraction

  1. #1
    Registered User
    Join Date
    12-28-2017
    Location
    North Carolina
    MS-Off Ver
    2016
    Posts
    13

    Power Query/VBA JSON Extraction

    I have a large JSON file which produces 300,000+ lines of data in an Excel file. Unfortunately, using VBA to clean up the data to how I've got it formatted in the link provided appears to take too long. I can share my VBA coding if someone is willing to see if they provide efficiencies there. Otherwise, I was turning my attention to Power Query to pull the data from the web page containing the JSON directly. My issue is that I have no been able to figure out to get the data to show all the details similar to that of in the link as well. For the sake of making things easier this data set can be used to imitate the spreadsheet I'm providing as well.

    https://www.smogon.com/stats/2020-11-H1/chaos/gen3ou-0.json - Sample data.

    https://www.smogon.com/stats/2020-11-H1/chaos/gen8vgc2021-1760.json - Data I'm truly wanting to use, but follows basically the same format of that of the sample data.

    Porygon-Z 1760+ Usage - Google Sheet showing off how I want the data to be imported into Excel after pulling the JSON with Power Query.

    Once the data gets to the formatting like in the Google Sheet, I was going to create VBA to do what I want with the data from there. I just need help finding a way to gather the LARGE amount of data from the 2nd JSON file to import into an Excel file.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Power Query/VBA JSON Extraction

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] 2 fields checker- Request for alternative option in Power Query or Power Pivot
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2020, 08:36 AM
  2. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  3. Power Query takes ages to load JSON data from web
    By rohanrao in forum Excel General
    Replies: 4
    Last Post: 05-21-2020, 10:34 PM
  4. [SOLVED] Power Query extraction of field in duplicated record
    By Stefj in forum Excel General
    Replies: 3
    Last Post: 05-11-2020, 08:40 PM
  5. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  6. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1