Import Live Data From Google Sheets to Excel | Strength Coach Tutorials #39
ฝัง
- เผยแพร่เมื่อ 29 ส.ค. 2024
- In this video I will show you how to import live data from google sheets into excel. This will be really useful in keeping your data saved in the cloud but being able to access it through excel.
►Purchase the Set & Rep Planner HERE: bit.ly/35PfOhz
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength...
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength
Thank you so much. Very clearly and precisely explained. I have been searching for this but gone through many examples in TH-cam, but none explained it like the way you did. Appreciate it. Keep the good work up.
thank you so much!
A big HELLO from COLOMBIA. Am a beginner on this Google Sheet and Excel synchronization issue but with your explanations I will impress to my boss !!!!!.....and the best part was after the minute 12 because is possible to refresh it by itself!!!!!
GRACIAS MIL !!!!!!
So happy to find an easy (very well explained) way to do this without having to use VBA (which alot of videos show), Thank you very much sir
Explained excellently
many thanks. this video has saved me alot
Many many thanks. Your video solved my problem. Thanks once again.
How To Create A Real-Time Sync Between Excel Online & Google Sheets? For instance, We as staff working on Excel online and whenever we add any new records or delete anything from the data, then I need the same reflection of the new records or delete of the data within the google sheet. In a nutshell, I want to transfer the real-time sync data into the google sheet. Many thanks for your amazing videos and I don't skip any of your videos. I wish you can help me in this regard as well. Thanks in advance.
Hey I currently do not know of a way to achieve this easily. I am sure you could create an integration through something like microsoft power apps but I have never had this use case.
If i figure it out I will do a video
Thanks a billion for your help. God bless you on all sides 🙏🏾
thank you very much for watching
This is great, can you make a video sent data other way? Excel to google sheet automatically or press a button.
Thanks for watching, I do not know of a good way to accomplish this task.
Thank you
Many thanks for the clear presentation. Very useful! 5/5
Hello thanks a lot for all the helpful videos ! How would you organize to host up to date data for one same athlete to monitor progress in time ?
Perfect! just what I need. Thank you!
Thanks you - this is very useful!
Glad it was helpful!
Hello, thanks for the tutorial, but mine get stuck after i click on the 'Data, - from web' then a windows of like a web msn comes. on the above bar it says web query. if i click go, it will want to download the sheets to my pc. it doesnt shows the table view as you show in this video. Please help, Thanks.
Thank you
Cheers mate! Keep it up with the good stuff, really appreciate it 🙏
Thanks for the support Luis!
Thank you so much
Very nice. Thanks. but I noticed that there is a delay in updating in Excel. Not sure if others experience that too.
Yes because the data is being downloaded it will be delayed, there is however a setting where you can change how often the data refreshes.
Thanks for this
thanks for watching
Very nice but how can we do it vise versa from online excel to Google sheet? Is there any ways, thanks in advance.
I do not know of a way to do this easily right now
Oh reaaaally thanks for this !! 😁
Thank you for checking it out!!
thank you very much this helps me a lot. i have a question that in google sheet why doesn't it provide option to insert footer with total page count though it gives current page number like page 1. my goal is to achieve page 1 of 5, in 2nd page 2 of 5 and so on..
Thank for the video...it may helps a lot...could it be the same if i add data from sheet will update to google?
I am not completely sure what you mean?
thank you very much! it helped a lot!
no problem thanks for watching
hi @DSMStrength Thanks for sharing this video..
how to export information from your emails to a Google Sheets?
I dont know I'm sorry
Nice tutorial.. thanks
how about you add it from excel then refresh? did it go to google sheets?
Ooohhhhh great idea!! Thank you! 😻
Very useful content👏
thanks so much!
wow that's great thanks 👍🏼👏🏼😍
very useful
Thank you very much
great video! thank you
you are welcome
is there a way to do the other way around? after syncing from Google Sheet, update the data from excel and push those update to Google Sheets?
yes but it is much more complicated.. and I am not sure why your usecase would require you to do that
Go to 6:50 for the actual importing.
Thank you. It amazes me that he stretched it out to a 15 minute video. Grateful nonetheless though.
certain things take some explanation
Wow this great! Is it possible to do this vice versa? When you update the data in excel then it will be updated also in google sheet?
thanks for checking out the channel and videos! you are doing some awesome stuff too it looks like
@@DSMStrength I have just Subscribed. I think your channel is the one that i'm looking for. I have discovered already how to make installer for different workbook files. I have been searching for a way on how to create a database online using google drive without using API. The closest method that I am thinking is excel to google sheet. I have just found out your method. Do you have a tutorial on how to add data in excel that will update it to google sheet also?
it seems you don't have a video to do the opposite...
@@grincon I found already the way in other youtube channel and it was great. Maybe someday if my schedule is no longer busy I will create a video on how to create a database online without showing any browser in the back. And i will make that database file executable also.
@@MyAudioBookCompilation easy way?
I don't have the Get data from the web option. It only prompts to get data from html, which opens file finder.
sounds like you need a newer version of excel
What if I only want to copy 1 row at a time?
at that point I would probably just copy & paste
Very good video ❤️
Thank you for watching
I am referencing few columns from Sheet 1 to sheet 2 in google forms. Then when I connect sheet 2 with excel and import it, for some reason it imports words "Column 1, column 2, column 3 etc.." how to avoid importing those names.
you have not defined your headers
Video starts at 6:49
how did you delete the columns i tried ctrl + shift + end or - and it didnt work
I have problem to do this with Excel 2007, "The command you selected is not available from this shortcut menu"
Hey to my knowledge this will not work with excel 2007. It would be worth your while to upgrade to excel 365. Thanks for watching
I would like to import data from zerodas console or holding statement figure to google drive spreadsheet or Google sheets automatically LTP change every day. Please guide us ASAP
I am sorry but I am not completely sure what you are asking for?
@@DSMStrength I want to transfer Excel worksheet xlxs data to google drive spreadsheet automatically
Hi. I had have problems with the date format when I imported from google sheet. Its changed to a number and show thats instead tha date. Thanks.
imported data is added at the bottom rows in one of the worksheet, is there any way to correct it
I believe you can in the settings of power query but not sure
May I please ask how do I set so that it only pulls data of the latest entries and not the whole worksheet?
I believe an easy way to do this would be to set up a pull from another google sheet that is filtering the data based on the max date.
I am not sure of your use case though
So you are saying you don't need 5 minutes to wait?
you can set the refresh length yourself
Not working if Google Sheets cells has formula.
Any idea how to perform this in MAC with excel 365?
Unfortunately to my knowledge mac does not support power query
I don't have a "Get Data from Web" option (mac)
Unfortunately I've been informed that this does not work on mac as it does not have power query
How to import data by function for example importxml and SAVE data automatically?
what if the owner (my company) of the google sheet doesnt allow publish to the web?
than i do not think you will be able to use this feature
I want automatically merge the google sheets and then import to excel. Please help me to this
if you combine this with my other video on importing data from another google sheet that should get the desired outcome for you.
thanks for watching
Is there any way to import the links in the sheets table to? it imports only values
I truthfully do not know
Can this be done in Excel for Mac? if so how?
I do not know a way to do this right now on excel for mac.
It may be possible though
How about the changes in Excel? Are those changes will reflect in Google Sheets? Or is it one way?
as of right now.. one way
Good!!! Could we do the same with microsoft forms?
Yes thats alot easier to do!
Super helpful.
also shared :)
Thank you very much!
what about auto sync from excell to google sheets
unfortunately I do not have a good way to do it the other way around yet without some specific coding.
That was a great video and will help me a lot!
Thanks a lot!
thank you very much
Does anyone know why I might not be seeing the table option whenever I try to bring my link from google docs to excel? I keep on getting just the document option and will not populate my table with data. I appreciate any help.
Mac Excel does not have the option to click "from the web".
correct power query which is the software that we are using within excel is not available on mac yet to my knowledge.
Sir Publish to web i didn't find in Google sheet file tab let me know plz....
it seems to have moved go to file - share - publish to web
I dont know....i have trying his for HhhhhOuuuuurssssssa.......dammmm .....aint getting it.
I want to convert excel xlsx file to google sheet keep live functions there is check and uncheck round points..help me?
you should be able to just upload the sheet to your google drive and most things should still work
DSMStrength but checkboxes doesn’t work but I added it manually and now problem is automatization when check one box doesn’t unchecking other,I can share you via gmail and you will see
@@jorikaish sure send me an email if you want. The checkbox functionality in google sheets and excel do not work the same way so you may have trouble trying to get this to work.
@@DSMStrength you send me your email and I will share google shit doc
how do i do this for mac?
to my knowledge this is exclusively for PC at this time
Can u do this with images
💯👌
Could you show a video that way?
Looks like this will work only in Office 365
sir wanna ask, please help
firstone, i already follow u and done (refresh 2times still oke and update),
but after that, i refresh the data for 3 times, the data no update, and wait 5 minutes the data can update.
how to for realtime update sir?please help
change the settings in excel for the refresh period to set it to a shorter interval
ran into a problem here. when i did this, excel added tons of extra rows that were not in my google sheet document. how do i fix this?
it obviously thought that there was some sort of data in them.. i would suggest cleaning the google sheet first
how about the other way Excel to Google sheets!??
Sorry to my knowledge there is no EASY way to do that.
I have seen someone do it with expensive software, or elaborate coding though
Is this possible to do on a Mac?
I have no tried it because I do not have a Mac but I don't know why it wouldn't be
Its not working bro I think there is a problem with g suite
Where are you getting stuck
it is not working on excel 10 why ?
plz answer....
Make sure you have excel 365
Getting an error "relationship ta contauns incorrect attribute. Line 2, poaition 86." What is the next step
not sure without seeing your data / sheets
Same happened to me. THe problem was I selected all document (sheets) which had a pivot table and that was the reason for the error. Then only selected 1 sheet and worked fine........But still for some reason when synching is adding 2 columns to the left and cannot find the reason.
Doesn't work with Excel 2010 at all. Nothing but errors.
Yes i do not think that power query was available in excel 2010, I would recomend upgrading your excel to excel 365.
@@DSMStrength Sadly, on a tight budget so that's not in the cards.
it seems you don't have a video to do the opposite...
I am not familiar with a good way to go from excel to Google yet.. when I figure that out I will for sure create that video
I like the video and appreciate it. But this video didn't have to be 13 minutes. It should have been 2-3 minutes.
thank you for watching, you can turn off the video whenever you want.
@@DSMStrength lmao, what's with the attitude... don't be so defensive when people are trying to provide constructive opinion bro. yikes... 😂
Looks like this will work only in Office 365