How to Connect Microsoft Excel with Google Sheets | Auto-Sync Google Sheets with Excel

[@technologiate]

Watch how to get data from Excel to Google Sheets *(auto-sync from Excel to Google Sheets)* : kzbin.info/www/bejne/nom2hJieeJ1_irs

[@abdullahusmani3430]

Multiple sheets

[@theladieclair]

So much valuable education in less than 5 minutes of content. Thank you!!!!

[@skarthik4]

Lovely . Well explained. Thanks a million . With Regards from India.

[@mauliardani7226]

very good. simple to use, thanks for sharing 👍

[@jinenderthakur8116]

I want the reverse excel sheet I change I want to changes on google sheet

[@satyam_2029]

This is really helpful, Thanks :)🤩

[@technologiate]

Glad it was helpful!

[@ppprismaaa]

excel changed, right? can't find the "from web" option.

[@ellapeterson1231]

Yeah, did you ever find a solution?

[@ppprismaaa]

never. asking a friend specialist on power bi i'll let you know@@ellapeterson1231

[@quietsp339]

you need to add it from the customize ribbons menu in the options.

[@MuhammadSafeer-u2g]

Interesting and informative. Thanks

[@technologiate]

You are welcome

[@quietsp339]

I did everything up to the 1:17 time of your video, but i cant select both of the sheets i want to add to the excel file. Is there something i missed?

[@lattebossku]

great video and thx for sharing it! may i ask can we use vba macro on the local connected file (which will need to search some files from the google drive source), for example "load value into cell A1 from "?

[@technologiate]

Yes you can!

[@sanjeevrajan7328]

Can we use vlookup in google sheet with ms excel(Normal excel sheet)

[@reginaldzakibelnevan5700]

hi does this work if we operate the excel on website not the app? and does it support complex formula like using dropdown or checkbox features for example? thanks

[@technologiate]

I haven't tried any complex formula. It may not work with the formulas that Google Sheets doesn't support. You can use Excel online instead of Google Sheets in that case.

[@aegeanorganicslemnos8311]

Can we do the reverse ? From excel to move data to a spreadsheet ? This is what I am trying to do but I don;t know how . Thank you

[@technologiate]

Here you go: kzbin.info/www/bejne/nom2hJieeJ1_irssi=gzVGUUQVGe7GF2L3

[@HakimahSyasya]

how to refresh without click refresh. mean auto generate data live

[@technologiate]

You can set auto-refresh for your desired time by following the instructions at 1:56.

[@abdulqoodooss9009]

Great... Will it do vice versa too? If I will work on excel and it will be updated in Google sheets ?

[@technologiate]

It doesn't work vice versa. Please watch this to sync data from Excel to Google Sheets: kzbin.info/www/bejne/nom2hJieeJ1_irs

[@ebimoghankelvin2466]

If I make a change in the excel file does it reflect in Google sheet too??

[@abdullahusmani3430]

How to add multiple tables/sheets in excel from google as in From web option only 1 table/sheet can be link.

[@Anon221BC]

which version of excel are you using?

[@technologiate]

I used the Excel that comes with Microsoft 365 Business Standard package.

[@IsharaLakmal-oe3cy]

Thank you so much❤❤❤❤

[@technologiate]

You are welcome

[@kamleshrana93]

If we can change any thing in excel sheet it be appear in Google sheet a???

[@technologiate]

Hi, this works only one way. Please watch this video for both wat synchronization: kzbin.info/www/bejne/nom2hJieeJ1_irs

[@حماده-ج9ي]

I want the opposite to work with an excel file and talk to the data in Google Sheet

[@technologiate]

Here is the video: kzbin.info/www/bejne/nom2hJieeJ1_irs

[@DarkEmPiResadow]

what if i just want specified cell intwo google sheet

[@punkboy3320]

Is that possible in not setting the privacy to public? and set it only in private?

[@technologiate]

It's private

[@arpitchokhani2549]

Can we save the Excel file in Google Drive instead of OneDrive?

[@technologiate]

Yes, in that case, you won't need any third-party service.

[@JDen4]

Can i hyperlink google sheet to excel cell by cell not a table?

[@technologiate]

When you import the Google Sheet data, it is imported as a table in the Excel file. Later, you can remove the table formatting, but I am not sure if the connection will still work. You can try it and let me know how it goes. Thanks.

[@et.sachin]

Will publishing to web put my data at risk?

[@technologiate]

When publishing the data, anyone can access the data with the link.

[@et.sachin]

@@technologiate What of we can keep the link without leaking

[@technologiate]

@@et.sachin In that case, it will be private. Google doesn't publish the link to the web.

[@bhagwangaur5697]

I didn't get the more options in properties for automate refresh the data

[@technologiate]

Select the table and select the Query tab, you will see the Properties option.

[@mpdunphy]

I’m trying to follow this, but am hitting a barrier when trying to import data from the web. There is a warning that my credentials could not be authenticated. Any ideas how to resolve this?

[@csmt7167]

how can I share this linked sheet with other Users

[@technologiate]

You can share the Google sheet. If you are trying to share the Excel sheet, keep the Excel file inside the OndeDrive folder, and then you can share it with other users.

[@girjeshchittora7318]

One permission error for useing refresh data

[@PremChauhanlegalpoint]

Nice

[@grootgroot582]

How to process muptiple sheets in GOOGLE SHEET ?

[@abdullahusmani3430]

Pls respond.

[@miguelros96]

1:55

[@mmrashid25]

nice video

[@technologiate]

Thanks