Macos Excel Functions

Question

Hello,

I am quite newby. I need really help. I installed Microsoft 365. I try to use Excel, especially Get Data Function, but I have could not achieve yet.

I have two different questions to all of you.

Firstly, I upload two different screenshots ( Picture 1 and Picture 2 ). Picture 1 is my macos Excel's view. Picture 2 is from a youtube video. I am not sure what is the operation system but there are more functions then mine. Are they different because of the fact that he uses Windows and I use macos or there is another reason ?

Picture 1 : https://ibb.co/n0qstkr

Picture 2: https://ibb.co/4Tn0tG2

Secondly, I try to get data from my macos excel. I clicked Import or Get Data then choose From HTML but I could not go any further then this ( The hyperlink refers to this ).

https://ibb.co/Br8HYh9

Answer 1

Get Data > From HTML opens a file browser that expects you to locate an HTML file having an HTML table that has been saved somewhere in your file system.

This is not the same thing as the HTML Power Query connector found in Windows Excel. That connector has not yet been made for Mac.

Answer 2

Hi Ahmet A!

Thank you for the feedback.

I'm sorry, unfortunately, I don't have any further troubleshooting to offer.

There are many knowledgeable users active on the forum and I hope that someone else can offer further insight into your issue.

Kind Regards, Shakiru

Answer 3

I totally understand but when I follow the directions which you wrote I reach to screenshot whose link is here https://ibb.co/Br8HYh9

Answer 4

Hi Ahmet A!

I used both Excel for Windows and Mac.

Yes, there may be some differences in the Excel functions and features available between Windows and macOS versions of Microsoft Excel. While Microsoft aims to maintain feature parity across platforms, certain functionalities or options might vary due to differences in the underlying operating systems. some extra features cos

2. Getting data from macOS Excel using "From HTML": To import data from HTML into Excel on macOS, you can follow these steps: a. Open Excel on your macOS. b. Click on the "Data" tab in the top menu. c. Select "Get Data" or "Get External Data" (the exact wording may differ depending on your Excel version). d. Choose "From Web" or "From Web Page" to import data from an HTML source. e. Enter the URL of the HTML page you want to import from and click "OK." f. Excel will load the data from the HTML page and provide options for data transformation and formatting. g. Follow the on-screen prompts to select and shape the data as desired. h. Once you're satisfied with the data import settings, choose the destination where you want to load the data (e.g., a new worksheet) and click "Load" or "Import."

Kindly let me know, if you require additional assistance, I will be glad to help further.

Best Regards, Shakiru