Forum Discussion

Cyssou's avatar
Cyssou
Copper Contributor
Jul 27, 2021
Solved

Retrieveing INSEE data in Excel via Power query

Hi I'm looking a way to connect INSEE data in Excel using Power Query but I don't understand how to connect Power Query   If I use VB code I correctly get data in imported in an excel sheet but I w...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 01, 2021

    Cyssou Perhaps the attached file helps you to get started with PowerQuery.

     

    Connecting to the site with the specified Idbank-code produces a list of indices for the past 17.5 years, but perhaps I didn't find all the data "hidden" in the XML source. Enter an Idbank-code on the first sheet. On the data ribbon, press Refresh All and the data will be updated in the table on the Data sheet.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 01, 2021

Cyssou Perhaps the attached file helps you to get started with PowerQuery.

 

Connecting to the site with the specified Idbank-code produces a list of indices for the past 17.5 years, but perhaps I didn't find all the data "hidden" in the XML source. Enter an Idbank-code on the first sheet. On the data ribbon, press Refresh All and the data will be updated in the table on the Data sheet.

  • Cyssou's avatar
    Cyssou
    Copper Contributor
    Aug 02, 2021

    Riny_van_Eekelen thanks this is really helpfull !!

Resources