Forum Discussion
Get external data from web not showing
Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea ...
pdramorim may be way late but I took the following steps on mac
Downloaded the Google Sheet file as Excel on mac
In Excel, selected data, then launch power query editor
In power query editor, get data and import the workbook you need
Then follow the same steps as here https://www.youtube.com/watch?v=hhfaOZUbrqw
Hope this helps!
solution: 2 links
https://support.microsoft.com/en-gb/office/import-and-shape-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
https://www.youtube.com/watch?v=REFpDiL80CU
good luck guys!
