This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to pull data from a URL and the only solution i am seeing is to use the "Get Data" "From Web" ribbon in the Data tab which i do not have. My Get data ribbon drop down looks different then everyone i am seeing online including the Microsoft tutorial. Please help.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
I am using a Mac. I don’t see what you are describing. No option in file
You can try the following steps to import webpage data into the workbook：
1.Open Word application and paste the URL which you want to query, save this document as .txt Plain Text, use MS-DOS coding.
2.Locate the txt file which we just created, right click on it > Get Info.
3.Under File Name & Extension, change the extension name from "txt" to "iqy".
4.Open Excel, on the top ribbon, click on Data > Get External Data > Run Web Query. And select the iqy file > OK.
Reference:
How to Import Web Data Into Excel on PC or Mac (with Pictures) (wikihow.com)
I don't have a "Get external Data" ribbon (see photo from before)
This is the easiest way to do the task?
There is no from web option when using a Mac?