Import Live Data From Google Sheets to Excel | Strength Coach Tutorials #39

how did you delete the columns i tried ctrl + shift + end or - and it didnt work

Perfect! just what I need. Thank you!

Nice tutorial.. thanks

Not working if Google Sheets cells has formula.

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

Thanks a billion for your help. God bless you on all sides 🙏🏾

thank you very much! it helped a lot!

I don't have the Get data from the web option. It only prompts to get data from html, which opens file finder.

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.

Sir Publish to web i didn't find in Google sheet file tab let me know plz....

How about the changes in Excel? Are those changes will reflect in Google Sheets? Or is it one way?

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 ?

What if I only want to copy 1 row at a time?

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.

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.

💯👌

Explained excellently

Many thanks for the clear presentation. Very useful! 5/5

Very good video ❤️

Thanks you - this is very useful!

great video! thank you

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 !!!!!!

This is great, can you make a video sent data other way? Excel to google sheet automatically or press a button.

how do i do this for mac?

How to import data by function for example importxml and SAVE data automatically?

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..

hi @DSMStrength Thanks for sharing this video..

how to export information from your emails to a Google Sheets?

Is there any way to import the links in the sheets table to? it imports only values

Can this be done in Excel for Mac? if so how?

Can u do this with images

Could you show a video that way?

how about the other way Excel to Google sheets!??

Thanks for this

how about you add it from excel then refresh? did it go to google sheets?

Many many thanks. Your video solved my problem. Thanks once again.

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

imported data is added at the bottom rows in one of the worksheet, is there any way to correct it

Very nice. Thanks. but I noticed that there is a delay in updating in Excel. Not sure if others experience that too.

May I please ask how do I set so that it only pulls data of the latest entries and not the whole worksheet?

what if the owner (my company) of the google sheet doesnt allow publish to the web?

Any idea how to perform this in MAC with excel 365?

So you are saying you don't need 5 minutes to wait?

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.

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?

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 so much

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?

Getting an error "relationship ta contauns incorrect attribute. Line 2, poaition 86." What is the next step

I want automatically merge the google sheets and then import to excel. Please help me to this