from web

What is 'MoreQuery for Mac' add-in? Starting in early 2023, we finally have a more powerful Power Query on Mac. However, there are some missing Get Data options which are essential for almost everyday use. I personally don’t understand why the development team didn’t include these essential...

I would like to set up a workbook so that I can retrieve the front pages of various news websites, and am curious what the quickest way to do that would be, if it is possible. As a pilot run, I have been using the Data tab to try and retrieve the headlines from www.cnn.com, and have not had...

The end goal is to have an Excel Table with a refreshable data connection to a web table. The reason to have an Excel Table is to use that Table as a reference point on other sheets, to perform calculations on other sheets, and to create summaries on other sheets. All of this is made much...

Hi Everyone, I'm drawing data from a website that requires login credentials to access. When I initially set up the queries I navigated through the portal that appears when you select the From Web option under Data, inputting my username and password to get onto the site and then navigating to...

Hi guys, I am trying to download (publically available) data from the website: Phelix Futures I am using the web query method in excel: Data-> from Web For some reason it doesn't import the table with numbers in excel, just some text (which I don't require.) Can anybody help me to get...

Dear Fellow Excel Users, I need help with getting data externally from web and also keeping the previous data prior to the refresh. My external table/data has 10 rows reporting values per day (10 days data table). I can link the table to my sheet, however what I can not do is to create an...

I have a small challenge for one of the sheets I am working on that I need the assistance of my fellow excel users. I am getting an external data from the web and the table (external data) has 10 rows always reporting for the last ten days. I want to roll this across to my sheet as a 'to date'...