Insert External Data (Website) In Excel Using MAC (Apple)

[@coinman1324]

VERY HELPFUL. Microsoft does not help at all with this. This guy deserves a raise

[@hatmeow]

Amazingly Helpful. I cannot imagine what the MS Excel team was thinking when they were developing for the Mac... Thanks again

[@waldifebrianda2723]

lols

[@YG5531]

agree, my god, those iqy files being greyed out ... took me an hour to figure it with the help of this video

[@nicx_lax3313]

I have been trying to put live gold prices in my portfolio on excel for the past week and haven’t found a single video that helped until yours. You are awesome man !

[@indraakshi]

just been a whole day of searching this [99.99 % windows solution] for basic analysis & i found you.......many thanks for this simple solution for mac

[@prajnaj5450]

Error when doing so "This Web query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection and then click Edit Query."

[@angelicpapillon]

I’m guessing it’s because we are trying to compile data from a password protected site.

[@roshansapkota498]

I got the same one. Any solution?

[@Aetrash]

I got the same one Any solution?

[@misterwill3625]

Excellent work! Thank you. The directions for the PC are super easy and I had no idea what to do on a MacBook, but I found your very concise video. I just tried it and it worked.

[@GloriaRobles-e1o]

This is incredibly helpful! Other videos assume we have the web browser import option automatically available. I did not. This allowed me to get the data I needed! Thank you!

[@Veectory]

TIP - Make sure to use List mode in your finder if you are having issues clicking to get the rename!

[@anamariabazzani689]

Thank you so much for being so descriptive! I was so frustrated and this helped a ton.

[@kathyblakeney8410]

This tutorial helped me greatly with my Mac! I come from a pc background as well and there are quite a few differences!

[@A-V]

Great demo - worked perfectly... except in my case I knew that the .iqy file had an invisible ".txt" extension appended to its filename (that is the MacOS's typical default for hiding file extensions) - so I added one step. I adjusted the Finder preferences momentarily to "Show all filename extensions" enabling me to delete it - leaving only .iqy at the end. I think that the one difference between your video & another one I watched earlier - which would not work for me - was the DOS formatting of the text / iqy file. The other tutorial did not specify the need to make it DOS & maybe that's why it didn't work for me. In your case, I suspect that maybe you can skip the right clicking and renaming of the greyed out file steps. For me it was not greyed out & was pickable without needing to use the right-click/rename trick. This might be because of my changing its invisible extension from txt to iqy. Question: If I give the spreadsheet to someone without including the iqy file, then do you know if the web connection will still continue to work? Or does the .iqy file need to always remain accompanied with the Excel file?

[@vasilvn]

Thank you very much. This is actually very important step.

[@investtradesave9527]

It still added .txt after i click save every time... so frustrating

[@370ferrari]

You're an amazing person. Thanks to you I figured out my problem.

[@YG5531]

thank you very much !!! super helpful

[@olubukola107]

Thank you so much, finally someone explains & does it in a way I am actually able to understand

[@JewellDWilliams]

Thank you one trillion times! I have been searching all over the web to find the solution. I am learning financial queries in the MBA program and using a Mac. All the school videos are on a PC. You ROCK. I subscribed and liked it. 🤩 PS I also shared this with all my classmates.

[@drewblazsik]

Thank you!

[@aamirashraf5297]

I don't seem to have the "Get external data" option

[@enriqueschroeder4056]

Great demo Drew!!! You helped me a lot.

[@jamesbhacka7868]

Thank you very much..worked.. Now that i have the excel sheet with the data in it do i have to save the word document for it to keep updating data the next day??

[@alfonsoalexander9740]

Great! Not even my teachers at the university could solve this. Thanks!

[@MohammedAlhassan]

Very useful and straightforward. Thanks for putting this together.

[@fruitsalad08]

Thank you SO MUCH! This was easy to understand. I viewed multiple other videos but none of them worked for me. I will use this for my family history searching. I go to a page like Ancestry, run my query, copy the link and follow your instructions and I have the results in Excel. And I can refresh to see if there is anything new. Very Sweet. I'm so happy.

[@felipemelendezcarrillo8504]

If I do it this way and then open the document in a different computer will it still work? Or does the computer where I open it needs to have the .iqy documents?

[@felipemelendezcarrillo8504]

Thank you so much! Extremely helpful!!

[@sultan2012ful]

Absolute legend! You my friend are awesome! Thank you

[@josegonzalezlopez6920]

Excellent work! Thank you.

[@FaisalLaljee]

How do you select a specific piece of information from the website. I mean, if you want the batting average of 10 people from last season, how would you do it?

[@talaveralaser-sound-lighti8977]

Hello I get the following message when trying to import the data from a website, how could I solve it?

[@simonmillns]

That's amazing!, so helpful, thank you

[@murataksu6496]

Hi. I have a mac but don't have Excel nor Word. I have Numbers. Here is what I need. I want to add some online information to Numbers. For instance bet results or any online information(Kinda scraping info from web to Excel, Google spreadsheet). When these informations are changing I want to see update in Number spreadsheet too. Is it possible??? TIA!

[@ranielbaltazar1323]

What if the website that you are getting the data need a log in ?

[@prajnaj5450]

I have the same error. The error I get is "This Web query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection and then click Edit Query."

[@estherchoi2638]

if you resolved this issue, please please share

[@Aetrash]

@@prajnaj5450 If you resolved the issue shareee

[@georgemiyahara6576]

You rock! Thank you so much for the content.

[@WilliamSully-l5q]

Extremely helpful, thank you!

[@johnnyribeiro7694]

It's possible to share this sheet with a regular PC excel user, or will be some problem by doing this?

[@islandforgirls]

YOU JUST SAVED MY LIFE! TYSM 😭

[@angelicpapillon]

How could you compile data from different webpages into a single excel sheet? Ex) comparing 2 players stats against each other?

[@HisseDegerlemeVeAnalizSistemi]

Hello friends, I have a question. It is a good method to extract data from a single page. What should someone like me who wants to extract data from 540 separate pages do? Can anyone help me on this issue? I THANK YOU VERY MUCH TO OUR VALUABLE FRIEND FOR THE VIDEO.

[@rajagopala67]

Very well explained. Thank you

[@zahl87]

Im creating a Excel Fantasy-premier league table for my friends, combiding to different leagues. Tried this, everything went smooth the Excel-file said it was importing data. Got an error message saying it couldnt open the website. Didnt find the internet or Proxy-server. What is wrong?

[@kamalgrover758]

Thanks man, this was great!

[@MrSupernova111]

I have a new Macbook with the M1 chip and Office 365. I don't have "Run Web Query." How can I import data using my Mac?

[@AG-hm1sp]

If I don’t have a “data”on the top ?? How to create it

[@skdmanohtoflyone]

Can I set up to refresh data every 5 minutes?

[@AnthonyStPeter-lj9gl]

all i got was This Web query returned no data. :(

[@ashleyann4333]

Thank you, thank you, thank you, it’s the only thing that’s worked for me 👏🏾

[@kikoy530]

how can you let it do backround refresh? when i delete a row and refresh it, it restores all data.

[@kikoy530]

can you delete the saved .iqy file or do you have to keep it?

[@marcusasare7753]

You the man. Thanks very much

[@keithwilliams2873]

Incredibly helpful...thank you for posting.

[@paulkelly6446]

Thanks, extremely helpful.

[@paulmfti]

Thanks..yeah used excel on windows for years…Mac is a bit clunky..no keyboard shortcuts…and not as many features as windows version…Mac environment is so much nicer though…power query I think is now available on Mac….

[@t1o2o3t4t5a6]

great demo

[@jacobfox4756]

Hey Drew, this is a great video but I need your help. I am trying to create a spreadsheet with advanced batting stats for my fantasy baseball team. Every time I do what your video and others say it does not import the entire sheet. I am not interested in the standard batting, I am more interested in the advanced hitting. I have used multiple websites now and it has not worked. Can you help me? Thank you!

[@arthurmaniero917]

Why is it not working with financial data? Worked when I did it on Yahoo sports, but not Yahoo finance...

[@gargamela4552]

What if there is an API key required?

[@pabloricardoriveratejeda6635]

Thank you very much, it works incredibly!!

[@lifeoflesley]

I did the same thing you did but on mine it says there's an error :( What did I do wrong?

[@NikoMcHenry]

This helped so much! What a pain though!! I don't understand why apple has to make it so hard

[@Hadoush86]

Awesome Tutorial, Thanks Buddy!

[@abdullaaljowder7074]

You are the best, trick of double click to rename the file is unpriceable, believe me, thank you very much

[@diegovalero8454]

helped me a lot thank you very much

[@LuongvpaTraining]

thanks so much

[@EntyFu]

Thanks! that was very helpful :)

[@wesguild7804]

Dude that was amazing, thank you

[@stefanopuppi5787]

maaaaan thank you very much really, you saved me

[@mawulilotsu9972]

This is beautiful. many thanks...

[@sthasmn]

Thank you so much. Have a g-day

[@lambui590]

Incredible! Thank you so much!

[@jobrown3012]

Super helpful! 💪🏽👍🏻

[@linhphuong7535]

Amazing, thanks a lot 😊

[@nicoleagod2324]

Didn't work on mine. I followed every step but I couldn't rename the file I saved :(

[@lagsapa11]

I got stuck there too. Were you able to figure it out? If yes, please share how you did it. Thank you.

[@Jeff-yy5fe]

EXCELLENT!!! Thank you so much!!!

[@ucdang7433]

Thank you so much, sir!

[@carksa8196]

You are my hero bro 💙💙💙

[@m.ksplendid]

Really helpful, thank you!!

[@Beabetterone]

it helps a lot!!! thanks!!!

[@katiefleck1857]

Thank you!!!

[@haptik2742]

Thank you so much!

[@erolkerem]

excellent!

[@denisforget5126]

Thanks

[@TheJonnyHazard]

Big legend

[@dentfortune7271]

Worked

[@97Andras]

This might be the single reason I am never buying Mac again. this is ridiculous.

[@Sonic_animations5]

how do you select the .iqy file on the mac it wont let you right click on it to rename

[@safwan6975]

I'm not getting this in MacBook while doing same from Google spreadsheet to excel. I copied the link from spreadsheet and did the same to excel, but datas were not added to excel

[@GabrielHarrison-eq5bp]

Thank you so much !

[@massimiliano_mattioli]

thank you so much