Load Data from Ideaolo API into Excel

Question

Dear Developer Team,
	
	how can I load data from the Idealo API into Excel to further work with the pricing data?
	
	Many thanks for your support and best regards
	Globe

mhozic · Answer

You can create your own converter, use an external online tool (e.g. [https://data.page/json/csv](https://data.page/json/csv), or use excel data connections:
1. Load data file: Data / Get Data / From File / From JSON / open
2. Click results (List)
3. Click To Table / OK
4. Click Expand icon next to Column1 / OK
5. Click Expand icon for Column1.content / OK
6. Click Expand icon for Column1.content.offers / Expand To New Rows
7. Expand any other columns of type List or Record you need. For List select Extract Values and choose a separator
8. You can save and reuse this data connection for other records.

Idealo data

9 / 10

96ms

100%

N/A

Load Data from Ideaolo API into Excel