VERY HELPFUL. Microsoft does not help at all with this. This guy deserves a raise
@hatmeow
2 жыл бұрын
Amazingly Helpful. I cannot imagine what the MS Excel team was thinking when they were developing for the Mac... Thanks again
@waldifebrianda2723
Жыл бұрын
lols
@YG5531
11 ай бұрын
agree, my god, those iqy files being greyed out ... took me an hour to figure it with the help of this video
@nicx_lax3313
2 жыл бұрын
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
@fruitsalad08
3 жыл бұрын
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.
@MohammedAlhassan
3 жыл бұрын
Very useful and straightforward. Thanks for putting this together.
@anamariabazzani689
2 жыл бұрын
Thank you so much for being so descriptive! I was so frustrated and this helped a ton.
@Veectory
Жыл бұрын
TIP - Make sure to use List mode in your finder if you are having issues clicking to get the rename!
@prajnaj5450
3 жыл бұрын
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?
@linking2224
8 ай бұрын
I got the same one Any solution?
@olubukola107
2 жыл бұрын
Thank you so much, finally someone explains & does it in a way I am actually able to understand
@felipemelendezcarrillo8504
2 ай бұрын
Thank you so much! Extremely helpful!!
@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.
@kathyblakeney8410
Жыл бұрын
This tutorial helped me greatly with my Mac! I come from a pc background as well and there are quite a few differences!
@enriqueschroeder4056
2 жыл бұрын
Great demo Drew!!! You helped me a lot.
@keithwilliams2873
3 жыл бұрын
Incredibly helpful...thank you for posting.
@alfonsoalexander9740
2 жыл бұрын
Great! Not even my teachers at the university could solve this. Thanks!
@Hadoush86
3 жыл бұрын
Awesome Tutorial, Thanks Buddy!
@sultan2012ful
Жыл бұрын
Absolute legend! You my friend are awesome! Thank you
@georgemiyahara6576
Ай бұрын
You rock! Thank you so much for the content.
@lambui590
3 жыл бұрын
Incredible! Thank you so much!
@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!
@pabloricardoriveratejeda6635
2 жыл бұрын
Thank you very much, it works incredibly!!
@rajagopala67
2 жыл бұрын
Very well explained. Thank you
@josegonzalezlopez6920
11 ай бұрын
Excellent work! Thank you.
@matthewkisseih7866
2 жыл бұрын
Really helpful, thank you!!
@mawulilotsu9972
3 жыл бұрын
This is beautiful. many thanks...
@ashleyann4333
2 жыл бұрын
Thank you, thank you, thank you, it’s the only thing that’s worked for me 👏🏾
@wesguild7804
2 жыл бұрын
Dude that was amazing, thank you
@kamalgrover758
Жыл бұрын
Thanks man, this was great!
@marcusasare7753
11 ай бұрын
You the man. Thanks very much
@Jeff-yy5fe
2 жыл бұрын
EXCELLENT!!! Thank you so much!!!
@islandforgirls
Жыл бұрын
YOU JUST SAVED MY LIFE! TYSM 😭
@paulkelly6446
Жыл бұрын
Thanks, extremely helpful.
@Beabetterone
3 жыл бұрын
it helps a lot!!! thanks!!!
@jobrown3012
Жыл бұрын
Super helpful! 💪🏽👍🏻
@ucdang7433
2 жыл бұрын
Thank you so much, sir!
@linhphuong7535
Жыл бұрын
Amazing, thanks a lot 😊
@diegovalero8454
2 жыл бұрын
helped me a lot thank you very much
@carksa8196
2 жыл бұрын
You are my hero bro 💙💙💙
@stefanopuppi5787
2 жыл бұрын
maaaaan thank you very much really, you saved me
@haptik2742
2 жыл бұрын
Thank you so much!
@t1o2o3t4t5a6
Жыл бұрын
great demo
@sthasmn
2 жыл бұрын
Thank you so much. Have a g-day
@abdullaaljowder7074
3 жыл бұрын
You are the best, trick of double click to rename the file is unpriceable, believe me, thank you very much
@katiefleck1857
Жыл бұрын
Thank you!!!
@A-V
3 жыл бұрын
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
2 жыл бұрын
Thank you very much. This is actually very important step.
@investtradesave9527
2 жыл бұрын
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
11 ай бұрын
thank you very much !!! super helpful
@massimiliano_mattioli
9 ай бұрын
thank you so much
@erolkerem
2 жыл бұрын
excellent!
@LuongvpaTraining
Жыл бұрын
thanks so much
@jamesbhacka7868
2 жыл бұрын
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??
@dentfortune7271
2 жыл бұрын
Worked
@NikoMcHenry
2 жыл бұрын
This helped so much! What a pain though!! I don't understand why apple has to make it so hard
@denisforget5126
7 ай бұрын
Thanks
@jacobfox4756
3 жыл бұрын
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!
@johnnyribeiro7694
2 жыл бұрын
It's possible to share this sheet with a regular PC excel user, or will be some problem by doing this?
@felipemelendezcarrillo8504
2 ай бұрын
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?
@aamirashraf5297
Жыл бұрын
I don't seem to have the "Get external data" option
@CuneytO
5 ай бұрын
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.
@talaveralaser-sound-lighti8977
3 жыл бұрын
Hello I get the following message when trying to import the data from a website, how could I solve it?
@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
@user-vb9ex7zr1b
5 ай бұрын
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?
@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!
@angelicpapillon
Жыл бұрын
How could you compile data from different webpages into a single excel sheet? Ex) comparing 2 players stats against each other?
@paulmfti
2 жыл бұрын
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….
@zahl87
2 жыл бұрын
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?
@MrSupernova111
2 жыл бұрын
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?
@AnthonyStPeter-lj9gl
Жыл бұрын
all i got was This Web query returned no data. :(
@lifeoflesley
3 жыл бұрын
I did the same thing you did but on mine it says there's an error :( What did I do wrong?
@ranielbaltazar1323
3 жыл бұрын
What if the website that you are getting the data need a log in ?
@prajnaj5450
3 жыл бұрын
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
2 жыл бұрын
if you resolved this issue, please please share
@linking2224
8 ай бұрын
@@prajnaj5450 If you resolved the issue shareee
@skdmanohtoflyone
2 жыл бұрын
Can I set up to refresh data every 5 minutes?
@AG-hm1sp
Жыл бұрын
If I don’t have a “data”on the top ?? How to create it
@gargamela4552
2 жыл бұрын
What if there is an API key required?
@arthurmaniero917
2 жыл бұрын
Why is it not working with financial data? Worked when I did it on Yahoo sports, but not Yahoo finance...
@kikoy530
2 жыл бұрын
how can you let it do backround refresh? when i delete a row and refresh it, it restores all data.
@kikoy530
2 жыл бұрын
can you delete the saved .iqy file or do you have to keep it?
@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.
@97Andras
Жыл бұрын
This might be the single reason I am never buying Mac again. this is ridiculous.
Пікірлер: 95