35 thoughts on “Import JSON Data Into Excel 2016 Using a Get & Transform Query

  1. I have a Mac version 16.26 and there is not Json format. Only HTML, Text and ODBC format. I tried the txt format but it doesn't work.
    I'm goint to search again.

  2. if we import data in this way to excel, will it refresh automatically once the web source has any new data? If if we add something to this sheet, like an additional column, will it affect refreshment automation? thanks a lot

  3. do you have the same thing opposite? i have jason code in one cell in excell and i whant to export it into json file . pls help

  4. How do I add more rows? My Column is limited to 100 rows when trying to import ticker information from coinmarketcap.


  5. Hey there, nice video! But I have this "Details: "We found extra characters at the end of JSON input." Can you also help me out with that?

  6. First of all i want to say thank you.. was trying to figure this out for an hour until you gave me the last puzzle piece. I got a quite specific question though. so i got my json data from an API-Request and if it comes in a List object with records in it everthing is fine, but i hav another request and it Returns me a List with Child-List objects … now i tried to expose these in every possible way but i still cant figure it out correctly – any advice on this particular issue?

Leave a Reply

Your email address will not be published. Required fields are marked *