Idealo data

FREEMIUM
By 3B Data / @CRAWLER2API | Updated 5 days ago | eCommerce
Popularity

9.1 / 10

Latency

100ms

Service Level

100%

Health Check

N/A

Back to All Discussions

Load Data from Ideaolo API into Excel

Rapid account: Globemaster 2002
Globemaster2002
2 years ago
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
Rapid account: Mhozic
mhozic Commented 2 years ago

You can create your own converter, use an external online tool (e.g. 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.

Join in the discussion - add comment below:

Login / Signup to post new comments