Forum Discussion

Antoine Berjoan's avatar
Antoine Berjoan
Copper Contributor
Dec 17, 2017

no "from the web"

Hello everyone
I can not import data from the web on my excel because I do not have the section from the web
how to do ?
Thanks

1 Reply

  • Hello,

    What is your Excel version?

     

    In the latest version of Excel, the default tools to get data is the Get and Transform group, i.e. Power Query. The old ways of getting external data still exist but are not showing in the ribbon. You can bring them back.  

     

    Go to File > Options > Data  where you can see a section for the "legacy data import wizards". Tick the ones you want to show. After that, you can click the "Get Data" dropdown in the ribbon the will see the Legacy Wizards sub menu with the options you ticked. 

Resources