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

[@scottjones1474]

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

[@agroasesor1]

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

[@AmitPatel-if1bu]

Explained excellently

[@nishantgola139]

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

[@skywaysmail]

Thank you so much. Very clearly and precisely explained. I have been searching for this but gone through many examples in KZbin, but none explained it like the way you did. Appreciate it. Keep the good work up.

[@DSMStrength]

thank you so much!

[@findthetruth3021]

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.

[@DSMStrength]

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

[@aremuoluwatoyin6806]

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

[@DSMStrength]

thank you very much for watching

[@jakeliujakeliu]

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

[@DSMStrength]

Thanks for watching, I do not know of a good way to accomplish this task.

[@jakeliujakeliu]

Thank you

[@allanodero1658]

many thanks. this video has saved me alot

[@haronnjiru8122]

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

[@dyransanudop8436]

Perfect! just what I need. Thank you!

[@lucianabousader7680]

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 ?

[@sajidsherif7773]

Thanks you - this is very useful!

[@DSMStrength]

Glad it was helpful!

[@HassanHijazi1995]

Go to 6:50 for the actual importing.

[@superawesomecaptainmcfluff9506]

Thank you. It amazes me that he stretched it out to a 15 minute video. Grateful nonetheless though.

[@DSMStrength]

certain things take some explanation

[@maktabrendahsainsmarabatup6948]

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.

[@findthetruth3021]

Very nice but how can we do it vise versa from online excel to Google sheet? Is there any ways, thanks in advance.

[@DSMStrength]

I do not know of a way to do this easily right now

[@morsheddld]

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

[@bernlabs2047]

Thank for the video...it may helps a lot...could it be the same if i add data from sheet will update to google?

[@DSMStrength]

I am not completely sure what you mean?

[@ronelarinal1865]

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

[@knockuptrader55]

Nice tutorial.. thanks

[@kemmahoutlets1484]

hi @DSMStrength Thanks for sharing this video.. how to export information from your emails to a Google Sheets?

[@DSMStrength]

I dont know I'm sorry

[@beabeeeee]

thank you very much! it helped a lot!

[@DSMStrength]

no problem thanks for watching

[@naveensreekumari5847]

Thanks for this

[@DSMStrength]

thanks for watching

[@enzo2653]

Oh reaaaally thanks for this !! 😁

[@DSMStrength]

Thank you for checking it out!!

[@milemen7539]

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

[@DSMStrength]

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.

[@MyAudioBookCompilation]

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?

[@DSMStrength]

thanks for checking out the channel and videos! you are doing some awesome stuff too it looks like

[@MyAudioBookCompilation]

@@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?

[@grincon]

it seems you don't have a video to do the opposite...

[@MyAudioBookCompilation]

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

[@grincon]

@@MyAudioBookCompilation easy way?

[@janitziolazcano2226]

great video! thank you

[@DSMStrength]

you are welcome

[@IamRobertMTV]

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?

[@DSMStrength]

yes but it is much more complicated.. and I am not sure why your usecase would require you to do that

[@ankitwadhwa89]

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

[@DSMStrength]

Unfortunately to my knowledge mac does not support power query

[@fragrenceful]

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

[@DSMStrength]

I am sorry but I am not completely sure what you are asking for?

[@fragrenceful]

@@DSMStrength I want to transfer Excel worksheet xlxs data to google drive spreadsheet automatically

[@ahtalukdar09]

Thank you

[@speedfreakpsycho]

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.

[@DSMStrength]

you have not defined your headers

[@leowouters1191]

is it also possible for MAC. Data insect" FROM web" is not on my MAC

[@wesleybarini4212]

Very useful content👏

[@DSMStrength]

thanks so much!

[@MrLwin12]

Thank you so much

[@rofiqulislam7544]

Very good video ❤️

[@DSMStrength]

Thank you for watching

[@abedj1220]

very cool thanks.

[@sukichildrenshospital8007]

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

[@DSMStrength]

I believe you can in the settings of power query but not sure

[@fernandomgarin]

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.

[@5Rassel5]

Good!!! Could we do the same with microsoft forms?

[@DSMStrength]

Yes thats alot easier to do!

[@jasminqiao1591]

very useful

[@DSMStrength]

Thank you very much

[@lisabruce2665]

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

[@DSMStrength]

I do not know a way to do this right now on excel for mac. It may be possible though

[@Lui290]

Cheers mate! Keep it up with the good stuff, really appreciate it 🙏

[@DSMStrength]

Thanks for the support Luis!

[@idalau2920]

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

[@DSMStrength]

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

[@MK-jn9uu]

Ooohhhhh great idea!! Thank you! 😻

[@kevinoktaprima9672]

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

[@DSMStrength]

than i do not think you will be able to use this feature

[@finalz22]

I have problem to do this with Excel 2007, "The command you selected is not available from this shortcut menu"

[@DSMStrength]

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

[@KennethDevens]

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.

[@blackspell9890]

Video starts at 6:49

[@akhik5902]

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

[@DSMStrength]

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

[@tomspallone1868]

I don't have a "Get Data from Web" option (mac)

[@DSMStrength]

Unfortunately I've been informed that this does not work on mac as it does not have power query

[@adamstansbie36]

Can u do this with images

[@jorikaish]

I want to convert excel xlsx file to google sheet keep live functions there is check and uncheck round points..help me?

[@DSMStrength]

you should be able to just upload the sheet to your google drive and most things should still work

[@jorikaish]

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

[@DSMStrength]

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

[@jorikaish]

@@DSMStrength you send me your email and I will share google shit doc

[@Pedro_Israel]

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

[@DSMStrength]

I truthfully do not know

[@jennifersantaana5668]

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

[@DSMStrength]

at that point I would probably just copy & paste

[@yimiy_v]

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

[@DSMStrength]

as of right now.. one way

[@louism.6263]

That was a great video and will help me a lot! Thanks a lot!

[@DSMStrength]

thank you very much

[@loganfletcher4846]

Is this possible to do on a Mac?

[@DSMStrength]

I have no tried it because I do not have a Mac but I don't know why it wouldn't be

[@AppFanUAE]

wow that's great thanks 👍🏼👏🏼😍

[@simpanajoeb9267]

what about auto sync from excell to google sheets

[@DSMStrength]

unfortunately I do not have a good way to do it the other way around yet without some specific coding.

[@zeedzeel138]

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

[@DSMStrength]

change the settings in excel for the refresh period to set it to a shorter interval

[@marge5738]

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

[@DSMStrength]

sounds like you need a newer version of excel

[@andyyumol1554]

Super helpful.

[@andyyumol1554]

also shared :)

[@DSMStrength]

Thank you very much!

[@lmodric19]

how do i do this for mac?

[@DSMStrength]

to my knowledge this is exclusively for PC at this time

[@engrshahidiqbal1974]

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

[@DSMStrength]

it seems to have moved go to file - share - publish to web

[@MehmetPerdeci]

Not working if Google Sheets cells has formula.

[@willhadley5723]

Could you show a video that way?

[@militcyanosamuelsapulette1930]

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?

[@DSMStrength]

it obviously thought that there was some sort of data in them.. i would suggest cleaning the google sheet first

[@pawanjha4839]

it is not working on excel 10 why ? plz answer....

[@DSMStrength]

Make sure you have excel 365

[@kaidishi9422]

Mac Excel does not have the option to click "from the web".

[@DSMStrength]

correct power query which is the software that we are using within excel is not available on mac yet to my knowledge.

[@ahmedabdiguure4386]

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

[@DSMStrength]

you can set the refresh length yourself

[@annmendoza953]

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

[@DSMStrength]

not sure without seeing your data / sheets

[@palomma612]

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.

[@willhadley5723]

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

[@DSMStrength]

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

[@mazaruddin9261]

Its not working bro I think there is a problem with g suite

[@DSMStrength]

Where are you getting stuck

[@johnkimotho3906]

💯👌

[@njc11275]

Doesn't work with Excel 2010 at all. Nothing but errors.

[@DSMStrength]

Yes i do not think that power query was available in excel 2010, I would recomend upgrading your excel to excel 365.

[@njc11275]

@@DSMStrength Sadly, on a tight budget so that's not in the cards.

[@WorkMail-bn9sm]

I dont know....i have trying his for HhhhhOuuuuurssssssa.......dammmm .....aint getting it.

[@2615Prasad]

Looks like this will work only in Office 365

[@superawesomecaptainmcfluff9506]

I like the video and appreciate it. But this video didn't have to be 13 minutes. It should have been 2-3 minutes.

[@DSMStrength]

thank you for watching, you can turn off the video whenever you want.

[@superawesomecaptainmcfluff9506]

@@DSMStrength lmao, what's with the attitude... don't be so defensive when people are trying to provide constructive opinion bro. yikes... 😂

[@grincon]

it seems you don't have a video to do the opposite...

[@DSMStrength]

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

[@joshuasamuelraj5442]

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

[@sajmosajmon5774]

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

[@2615Prasad]

Looks like this will work only in Office 365