Effortlessly Import Data into Excel for Mac & Google Sheets: No Coding Needed!
HTML-код
- Опубликовано: 17 авг 2020
- Struggling to automatically import data into Excel for Mac or Google Sheets? Look no further! In this tutorial, I'll guide you through simple techniques to pull in data for sports betting models, trading analysis, and even homework stats - no coding required for two of the methods!
Importing data on MacOS and Microsoft Excel can be quite different from Windows, but don't worry, I've got you covered.
🔹 Key Points:
- Learn easy data import methods for Excel on Mac & Google Sheets
- No coding experience necessary for two of the techniques
- Overcome MacOS data import challenges
Ready to level up your sports betting game or kickstart your betting journey? Join us at actionbackers.com and use code WELCOME20 to enjoy $20 off your first month! Let's turn your passion for sports into profitable insights. 🚀 
Развлечения
Really wish they would release the full version of Power Query in macOS.
Dude, I love you. You saved me a trip to buy a pc
Hey man! Super informative. If I'm importing from multiple web-based csv files will it still work?
Thank you
Hi this video is really helpful and I was gonna ask the same question as @Andreea Nitescu because I'm having the same issue. Could you help out with the web scrapper you mentioned in the third option? Thank you so much
thankx
hi i'm trying to scrape some data from a website and I couldn't understand why I couldn't load the web query in excel, but I think it's being dynamically generated as you mentioned in the 3rd option but I have no coding skills and can't build or even copy and edit the web scrapper you did. Is there any hope for people like me? thank so much
Awesome
Hi, your video is one of the most informative on the subject of importing external data into excel for mac. However, following everything carefully I get a Unable to open [url]. Cannot locate the Internet server or proxy server (I'm trying to import from a REST API, the link works fine in browser and directly from word or excel). Any ideas why your method seems to error out? Excel for Mac is v16.43, 2019
Not sure, sorry. Never encountered. You might consider getting your API data via python and putting it into a data frame, which can then be saved/ imported as a CSV might solve the issue
@@ActionBackers thanks so much! I actually found the issue after spending an entire day searching for answers, and I'll mention it here just in case anyone needs it. What Excel does is it sends empty Accept headers (in its Request Headers) when it performs a web query. That is to say "give me any content-type and I'll accept it". Now some servers allow empty Accept headers as valid, but others raise a 406 errors when they see Accept = ' '. So the solution would actually be making the backend accept empty Accept headers. Thanks once again
@@andreeanitescu9026 this is useful to know! Sorry it took you a day of time to solve but helpful for others going forward :)
@@andreeanitescu9026 Hi I'm so glad you mentioned this here because I'm getting this error a lot. However could you explain more about this "backend accept empty Accept headers" I have no idea how to address this. Thank you
Could I use this same method for NHL? Best place to get the data would just be the NHL site?
Definitely can use it. Natural stat trick is best for NHL stats, in my opinion
this works for pulling data from other webpages, but it did not work when i want to import from kobo to excel in mac. please help
You’d have to google that... not really the point of the video. I’d imagine there’s some sort of API you could use
I keep getting an error message. Epic fail. What am I missing?
whats going on bud? Can you please show how to make a power ranking for NFL. I tried making it through your NHL power raking video but it doesn't come out like the NHL
I build my Nfl power ratings the exact same way I build my nhl ones so not sure what the issue is but I’m not going to make a separate video as it’s the exact same process
@@ActionBackers How did you get all the visitors on the same column, on pro football reference it has them mixed within the same column.
When I send this file to another person uses Windows OS, will it work?
It should, yep!
i used =IMPORTHTML("url","table",0) but it didn't work and now it just says "Error, Imported content is empty." :( what do i do?
try to use ; instead of , / =IMPORTHTML("url";"table";0)
How to import live data to mac
Will this work for current stats that I need to update daily?
Yes, why wouldn’t it? That’s the whole point of the video
@@ActionBackers well I wrote the code in python, it saved as a CSV in excel, but didn't update with the website
If you’re writing code to get stats using Python then you need to re-run the Python code each day... the video shows how to get stats in using importHTML function in Google sheets or from web query in excel. Completely different situation than scraping web with Python
@@ActionBackers Is there a way to automatically re-run the Python code?
@@masonmccullar3274 that’s not at all within the scope of this video, but yes you can set up a cron job to run a script daily. This isn’t a Python tutorial video