How to connect Google Sheets to Excel

[@FoulFiend113]

Very useful. Can this be done the other way around? From Excel to Sheets?

[@OTNAYITPES]

"hope you'll find this video usefull" the most humble expression i've heard for a while,,

[@ChrisBates-m5r]

Thank you, Thank you, Thank you. I had been trying all sorts of ways to do this, without success. Your solution was the simplest, AND IT WORKED BRILLIANTLY!

[@AjayAnandXLnCAD]

My pleasure 😀

[@oOoScarecrow31oOo]

Is it possible to do it the other way ? To link Excel with Google Sheets ! I want my Google Sheets to show my excel updates.

[@AjayAnandXLnCAD]

I haven't tried it until now. Will let you know if it works

[@MrBernacho]

@@AjayAnandXLnCAD Hi! did you manage to do it from excel to sheets?

[@Interstellar183]

Same question

[@BaselNadim]

short, smart and working... perfect thanks

[@LisbethLog]

Thank you for this. How about the other way around? I have an Excel sheet, and I want a Google sheet to read data from it & be updated automatically if the Excel is updated.

[@mirrrvelll5164]

This is amazing trick, it is revolution actually. For both parties, Excel and Sheet people.

[@troyelliott420]

Many thanks to you, sir! "export?format=xlsx" is what I was missing!

[@AjayAnandXLnCAD]

Glad it helped!

[@hazemali382]

Wow more than great Ajay

[@muhammadnurhakimmohdderis4201]

This is what I'm searching for... Google good for communicating information and excel good in processing data quicker and better....

[@AjayAnandXLnCAD]

Thank you :)

[@jaysee27]

Wow. This method actually works! :) Thank you so much.

[@marccrabbe3031]

Such a peaceful voice ! Thanks sir !

[@djannias]

This is brilliant and concise, thank you so much Ajay

[@vineshjain883]

Very nice speech. This video is very useful for me. I will be try.

[@pilgrimr]

Quality! Exactly what I've been after!

[@සින්දුලන්තය-ණ6ත]

Thanks sir from 🇱🇰

[@AnilSingh-gv5tx]

very useful boss..!!

[@nehaalone4848]

Thankyou Ajay.. Great information video..Liked and subscribed

[@qoolandz]

Nice trick that's help my job done, Thank you

[@nacchuful]

Hi Ajay, from my side after replace it into "export?format=xlsx" then run, in the end the list of "Navigator" not show me "Sheet 1" buat with name "Document". Do you know what I suppose to try?

[@kf6fzx]

That is the Google login page. Have not found a way past that yet.

[@vivekkumar-iv4jv]

Even I am facing same issues. If any one know this please help

[@otakusense]

Bump this

[@michaelhagerty4846]

not 100% sure how i fixed this but i believe I had the wrong google account open. when i logged out and into the other account i was able to proceed as in the video.

[@satyabansahoo1862]

because it cannot extract the data from private google sheet, u need to make it public by removing the restriction.

[@alavijayan1870]

Thank you so much ....

[@AjayAnandXLnCAD]

My pleasure 😀

[@IsHardynafthardynaft]

It works in 2022 awesome!

[@kc123photo123]

so helpful - thank you!!

[@AjayAnandXLnCAD]

Glad it was helpful!

[@parassingh7457]

thank you sooo much Sir this vdo really helpful for me.

[@AjayAnandXLnCAD]

My pleasure 😀

[@DevOpsMaestro]

if we add some new data in the local excel file, will it get saved to the google sheet ?

[@shankaelohor9102]

Thanks it helped

[@jackmiddlton4614]

good good explanation, cool

[@rrmontiel]

million thanks!

[@paolojoseespiridion8705]

very helpful. I am using excel 2010. i am on the page where i put in the google sheet URL, edited the last part. but after i click on Go icon, it prompts me to log in to my google account. after i put in my creds, the data exported to excel are those google text from the log in page and not those from my google sheet. how can I bypass the google login page? your help will be appreciated. thank you in advance.

[@aegeanorganicslemnos8311]

Thank you . Can you show us please how to do this from Excel to Google Sheets?

[@abdullanpm]

Superb

[@mcgalle699]

This is a so useful tutorial! But I have a problem...when I go to Get External Data > From web, I do not have the simple panel you have at 1:41, but a panel called New Web Query opens. How can I proceed? Please help me sir

[@SumitGupta07]

Did you get any solution for this, I am having same issue.

[@jimmyxrose]

that is a great tutorial! thank you very much, it helped a lot!

[@dukemanvillle]

Hi Thanks for the video.. I can link excel to a google sheet where I'm the owner, but can't link to a google sheet that is shared with me where I'm an editor. Do you have an idea why this doesn't work?

[@paddybapat87]

Did you get a work Around

[@bradfitton6998]

Amazing, this will save me so much time. 👍👍👍

[@mustakahmed363]

Thank you soo much 🤲🤲. It’s really helpful

[@AjayAnandXLnCAD]

You’re welcome 😊

[@mydsharetech8706]

Sir what version of office you used?

[@AjayAnandXLnCAD]

Office 365

[@fernandomgarin]

Easy. thanks.

[@dellawitt6430]

Which do you use Office version? is it office 365?

[@ArmanKhan-iq3ji]

Can it works on from one system to another system in different location. Pls tell me.

[@AjayAnandXLnCAD]

Can you please explain the requirement with an example?

[@rosscoen5227]

Is there a way to make the edits work each way? So, any changes made in excel, will be represented in sheets?

[@historic-newspapers]

same here! this is what i would like to be able to do!

[@srikaramanaganti1285]

is reverse possible changes made in excel reflected in sheets

[@cepv16]

Hey bro, do you know how to do it for Mac? i dont have that "from web" option, can you help me

[@AjayAnandXLnCAD]

Actually, I don't have Mac system to check that. I suggest posting this question on Quora.

[@cepv16]

@@AjayAnandXLnCAD Ok bro, anyway thanks for answering👌🏽

[@shubhamcreation337]

Not working properly. Data preview not showing This is what exactly I'm looking for. Thank a lot for making this useful video

[@AjayAnandXLnCAD]

👍

[@MrEla123]

Sir, this can do in 2007 ms excel...

[@AjayAnandXLnCAD]

No. Power Query is available from Excel 2010. Moreover, It has been 13 years since the release of Excel 2007 and 5 versions (2010, 2013, 2016, 2019 and Excel with Office 365 Subscription) of Excel came after that. So, I suggest you to get a copy of Excel 2016 or Excel 2019. Otherwise you will be missing a lot of awesome features and most importantly wasting your valuable time.

[@marge5738]

There's no "from web" option for my spreadsheet. There is an HTML option, and it just opens file finder. I'm on a MAC, so maybe its yet another glitch in their software setup?

[@axelgrind]

That's also what I'm seeing. (Also on a mac)

[@jbhomestore]

is possible in ms 2007 ver. ??

[@johnseuntiens4651]

If you start filtering the values will move... is there a function that will avoid that your values in the rows will change?

[@sakibshadman1448]

try Copy the values and past values in the range.

[@tlananthu]

Is there a way to do the vice versa? Modify excel in local and data save to google sheets?

[@ansermehmood521]

I have same question

[@shamailajaved8027]

All steps are okay however I dont seem to get my sheet in Navigator . Can you suggest what seems to be the problem. thanks

[@amitmandal4367]

Sir,my sheet is view only mode but can I enable without live streaming

[@AjayAnandXLnCAD]

What do you want to enable?

[@amitmandal4367]

@@AjayAnandXLnCAD when I entered some data than showing live data with another person how to stop it.

[@elenakkorzilova1338]

thank you

[@mlt3105]

Very precise. But, what will happen to the excel data if the Google sheets is deleted?

[@MrEla123]

Sir this can be do in excel 2007 ??

[@AjayAnandXLnCAD]

As you can see, we have used Power Query for importing data. Power Query is only available in Excel 2010 and later versions.

[@abdulsajjadgalib]

Sir aap esay excel sheet to google sheet me text type kar ke dikhayen ki ye data change hote hain ya nahi hote hain

[@jokermig131]

sos un capo , me salvaste la vida crack :D

[@alexandercleary2854]

Doesn't work, i get the same HTML errors as others

[@Cesarpiano2008]

Thanks for the video. I was able to connect, but the problem is that im getting only 356 rows, and I need more than 1.000 how can I solve that? Thanks for your help

[@pradipbirla9047]

Very helpful this trick but this not working in 2013 excel pls help

[@AjayAnandXLnCAD]

I suggest the latest the version of Excel (Office 365)

[@superskill9582]

i want change in excel and should be update in google sheet

[@khalifirgi]

How about importing from google drive folder ?

[@ArunKumar-mz5db]

Super trick but we enter data in Google sheets once never edit automatically lock cell how to do please explain

[@BPGAUR]

but in my excel, when i click from web then different popup show how i will fix it

[@samihakhenaka3845]

HI, IS IT SAFE WAY FOR BUSINESS DATA

[@mustakahmed363]

When I click From Web , I am not getting the same tab which is coming on your screen. How to get that tab pls suggest. Bcz for me some other tab is coming and it’s showing to import data. When i click import there is save and open option is coming

[@Erasedbrain]

How to connect file with restricted access to some defined users only ?

[@sheritatrading9212]

not getting dialog box, its showing msn search bar how to clear it

[@AjayAnandXLnCAD]

Which version of Excel are you using?

[@aamm5096]

Nice

[@suryabattula3799]

suppose I'm migrating Gsheet to Excel. what problems users faces in Excel..?? can u explain..?

[@AjayAnandXLnCAD]

Why are you migrating from Gsheet to Excel?

[@CChoak]

1:41 Edit excel format

[@guiga_melo]

Thank you!!!!!!!

[@ZakHussain-m5d]

How to connect online excel data to google sheet?

[@mustakahmed363]

How we can create one template in Google sheet which can save the data’s in Google sheet? I mean I want make one template for my competitors informations so that Whenever we feed information it can save in Google sheet

[@AjayAnandXLnCAD]

What kind of information, Where are you feeding it? Please explain.

[@AbdelrahmanRefaat]

HOW TO CONNECT EXCEL TO GOOGLE SHEET

[@prajwalshetty2047]

❤

[@julielee6989]

If you have multiple tabs in Google Sheets, how do you connect to only one specific tab?

[@jaysee27]

Once you are successful in connecting to the Google Sheet you will see a list of the names of the various sheet/tab names in your Google Sheet. Select the specific tab that you want to import. I have found that it is very important to have the Google Sheet tab in standard columns and rows (a standard data set format) with no blank column headers.

[@mauquouraquourahalla9982]

How to connect excel and Java Script?

[@sakibshadman1448]

Excel is not recognizing fraction values from Google sheet. for 2.02 it just gives 2. How to fix this? TIA

[@AymanMamdouh]

there is an error when i press connect we couldn't authenticate with the credentials provided

[@sairam8280]

very goo

[@nicklogan24]

I’m receiving the error relationship tag contains incorrect attribute. Line 2, position 86

[@TaretoMC]

What about the opposite? Excel to Sheets?

[@Beautymovesindia]

and how to connect Excel sheet to google. i mean vise versa

[@supriyobarman9067]

The following occurs

[@apostolos55goulandris97]

This is connect Excel to GoogleSheet, the opposite of what I was searching :(

[@MobileGamerDude]

This is exactly what I was looking for, and then it failed to sync after I had to re-create it. Very annoying

[@susmitasahoo8037]

Not working properly

[@rayzhu8368]

i failed

[@AjayAnandXLnCAD]

What happened?

[@medrelaxationmusicvideo8749]

I have not been able to link it