Connect to API in Excel Part 2/2: Read API JSON Response

In the previous video we have seen how to connect to a web API in Excel using VBA macros. In this video we will see how to read the API JSON response in Excel and retrieve the data of interest. In this macro example, the data is the list of universities for a given country. The web API is public and does not require any API key to be used. There are different ways to read a JSON file in Excel. We will use a simple method of string manipulation to get the name of each university for a given country.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:

[geronimoyerena]

Very good. How could the Unicode codes in the response be replaced by the original character or letter they represent? For example, the university's name is "Göteborg University" but in the response the university's name is "G\u00f6teborg University". What can be done to show "Göteborg University" (for example) in column "A". Is there a function or way to replace all the Unicode codes in the response and show the real names of the universities in column A?

[minakshideb]

I am not getting the data in Excel. However my code is running