Labada Google Sheets iyo Microsoft Excel labaduba waa software faafin oo awood leh. Inta aad ku jirto Excel waxaad ka shaqayn kartaa offline, Google Sheets wuxuu kuu ogolaanayaa inaad abuurto oo aad maamusho xaashida khadka internetka. Xaashiyaha Google^{(Google Sheets)} sidoo kale waxay si toos ah u kaydisaa isbeddel kasta. Faa'iidada isticmaalka Google Sheets waa in aad ka maareyn karto xaashida xaashida meel kasta oo qalab kasta ah adiga oo si fudud u saxeexaya akoonkaaga Google .

Waxaad ku soo dejisan kartaa Google Sheets xlsx iyo qaabab kale waxaadna kombuyutarkaaga ku samayn kartaa kayd^{(backup on your PC)} . Laakiin mar kasta oo aad isbeddel ku samayso Google Sheets , waa inaad soo dejiso oo aad bedeshaa faylka kaydinta hore. Hadda, qiyaas haddii aad ku jirto boos sare oo urur, waa inaad maareysaa xog aad u badan. Xaaladdan oo kale, waxay kugu adkaan doontaa inaad ku hayso dhammaan faylasha kaydinta si la mid ah Google Sheets gacanta. Ma jiraa hab ay dhammaan faylasha la soo dejiyey si toos ah loogu cusboonaysiin doono? Haa, way jirtaa. Maqaalkan, waxaynu ku arki doonaa habka isku xidhka ama isku xidhka Google Sheets iyo MS Excelsi isbeddel kasta oo lagu sameeyo Google Sheets uu si toos ah uga dhex muuqan doono faylka MS Excel ee kala duwan.^{(MS Excel)}

Akhri^(Read) : Sida loogu isticmaalo mawduuca mugdiga ah ee Google Docs, Sheets, iyo Slides^{(How to use Dark theme in Google Docs, Sheets, and Slides)} .

Sida loogu xidho Google Sheets iyo Excel

1] Ku fur^(Open) faylka Google Sheets oo aad rabto in aad la shaqeyso MS Excel . Waxaan diyaariyey xogta muunad ee heerkulka gobolada kala duwan ee Hindiya^(India) .

2] Hadda u tag " File > Publish to the web " Google Sheets.

3] " Dhammaan dukumeenti^{(Entire Document)} " liiska hoos-u-dhaca, waxaad haysataa ikhtiyaar aad ku daabacdo dukumeentiga oo dhan ama kaliya xaashida gaarka ah ee dukumeentiga.

Guji qaybta " La daabacay Content & settings^{(Published content & settings)} " si aad u ballaariso oo aad u aragto in qaybta " Si toos ah dib ugu daabac marka isbeddellada la sameeyo^{(Automatically republish when the changes are made)} " ay karti u leedahay iyo in kale. Haddii kale, awood Hadda dhagsii badhanka " Daabac^(Publish) " oo dooro OK ee soo baxay.

Akhri^(Read) : Sida loo bilaabo Word, Excel, PowerPoint in Mode Safe^{(How to start Word, Excel, PowerPoint in Safe Mode)} .

4] Kadib daabacaadda dukumeentiga, waxaad heli doontaa xiriiriye. Waa inaad ku dhejisaa xiriirkan dukumeentiga MS Excel kaas oo aad rabto inaad ku xirto Google Sheets . Haddii aad ku dhejiso xiriirkan shabakada internetka, waxaad arki doontaa in loo heli karo bog shabakad ahaan.

Hadda, bilow MS Excel oo ku dhex samee dukumeenti maran cusub. Tag " Data > New Query > From Other Sources > From Web ."

5] Waxaad heli doontaa daaqad popup ah, halkaas oo aad ku dhejinayso isku xirka la koobiyeeyay oo guji OK. Haddii aad halkan ka hesho laba doorasho, Aasaaska^(Basic) iyo Sare^(Advanced) , dooro aasaasiga ah^(Basic) .

6] Dhammaan xogta xaashida Google^{(Google Sheet)} -ka waxa lagu heli doonaa Excel qaab miis ah. Hadda, daaqadda " Navigator ", marka hore, dhagsii " Dooro shay badan^{(Select multiple items)} " calaamadee sanduuqa ka dibna dooro " Table 0. " Aragtida shayga la doortay ayaa laga helayaa dhinaca midigta.

Sawirka hoose waxaad ka arki kartaa in tiirka 1 uu faaruq yahay oo tiirka 2 uu taxayo tirooyinka taxanaha ah, xogtayada dhabta ahi waxay ku taxan yihiin tiirarka 3 iyo 4. Sababtoo ah uma baahnin tiirarka 1 iyo 2, waa inaan tirtirnaa. Taas awgeed, dhagsii badhanka " Edit " ee ku yaal xagga hoose ee daaqada Navigator . Qaarkiin ayaa laga yaabaa in ay haystaan ​​" Beddel Xogta^{(Transform Data)} " oo ku jira " Tafatirka^(Edit) " doorashada taas oo ku xidhan nooca MS Excel . Waxay furi doontaa " Tifaftiraha weydiinta^{(Query Editor)} ."

Akhri^(Read) : Talooyinka Excel si aad u badbaadiso wakhtiga oo aad si dhakhso leh u shaqeyso .

7] Waxaan rabnaa inaan safkayaga koowaad ka dhigno madaxa. Taas awgeed, dhagsii geeska bidix ee sare oo dooro " Isticmaal safka kowaad sida madax^{(Use first row as headers)} ."

8] Si aad u tirtirto tiirarka aan la rabin, dhagsii geeska bidix ee sare oo dooro " Dooro tiirarka^{(Choose columns)} ." Intaa ka dib, ka saar sanduuqyada tiirarka aanad rabin oo guji OK.

9] Hadda, dhagsii " Xir & Raro^{(Close & Load)} " si aad ugu shubto xogta Google Sheet gudaha Excel .

Waxaad ku xidhay xaashida Google-^{(Google Sheet)} ka iyo Excel . Mar kasta oo aad wax isbeddel ah ku samayso Google Sheet , waa inaad sugtaa 5 daqiiqo si aad u hesho isbeddeladaas lagu daabaco shabakadda. Taas ka dib, waa inaad dib u cusbooneysiisaa faylka Excel si aad u hesho isbeddeladan ka muuqda faylka Excel . Taas awgeed, u tag " Data > Refresh All ."

Akhri^(Read) : Furayaasha fallaadha oo aan ku shaqayn Excel .

Haddii aad rabto in Excel uu iskiis u cusboonaysiiyo mar kasta oo aad isbeddel ku samayso Google Sheet , waa inaad samaysaa tillaabooyin dheeraad ah.

1] Dooro miiska oo tag " Data > Connections ." Tani waxay furi doontaa daaqad ay tahay inaad doorato " Properties ."

2] Hadda, dhagsii " Refresh kasta^{(Refresh every)} " sanduuqa hubinta oo geli wakhtiga ka dib markaad rabto in Excel si toos ah u cusbooneysiiyo. Waxaan galay 5 daqiiqo Haddii aad awood u yeelatid " Xogta dib u cusbooneysii markaad fureyso faylka^{(Refresh data when opening the file)} ", Excel wuxuu hubin doonaa wixii cusbooneysiin ah mar kasta oo aad furto. Markaad dhammayso, dhagsii OK oo xidh daaqadii hore.

Waa kaas. Tani waa sida aad Google Sheets^{(Google Sheets)} ugu xidhi karto MS Excel^{(MS Excel)} .

Akhri soo socda^{(Read next)} : Talooyin iyo tabaha sare ee Excel .

How to connect Google Sheets with Excel

Both Google Sheetѕ and Microsoft Excel are powerful spreadsheet software. While in Excel you can work offline, Google Sheets lets you create and manage spreadsheets online. Google Sheets also saves every single change automatically. The benefit of using Google Sheets is that you can manage spreadsheets from anywhere on any device simply by signing into your Google account.

You can download Google Sheets in xlsx and other formats and create a backup on your PC. But every time you make a change to the Google Sheets, you have to download it and replace the previous backup file. Now, imagine if you at a higher post in an organization, you have to manage a significant amount of data. In such a condition, it will become hectic for you to keep all the backup files in synchronization with Google Sheets manually. Is there any method by which all the downloaded files will be updated automatically? Yes, there is. In this article, we will see the method of connecting or synchronizing Google Sheets with MS Excel so that every change made in Google Sheets will be reflected automatically in the respective MS Excel file.

Read: How to use Dark theme in Google Docs, Sheets, and Slides.

How to connect Google Sheets with Excel

1] Open the file in Google Sheets which you want to synchronize with MS Excel. I have prepared sample data of temperatures of different states of India.

2] Now go to “File > Publish to the web” in Google Sheets.

3] In the “Entire Document” drop-down menu, you have an option to publish either the entire document or only the particular sheet of the document.

Click “Published content & settings” part to expand it and see whether the “Automatically republish when the changes are made” part is enabled or not. If not, enable it. Now click on the “Publish” button and select OK in the popup.

Read: How to start Word, Excel, PowerPoint in Safe Mode.

4] After publishing the document, you will get a link. You have to paste this link in the MS Excel document which you want to connect with Google Sheets. If you paste this link in your web browser, you will see that it is available as a web page.

Now, launch MS Excel and create a new blank document in it. Go to “Data > New Query > From Other Sources > From Web.”

5] You will get a popup window, where you have to paste the copied link and click OK. If you get here two options, Basic and Advanced, select Basic.

6] The entire Google Sheet data will be available in Excel in the form of a table. Now, in the “Navigator” window, first, click “Select multiple items” check box and then select “Table 0.” A preview of the selected item is available on the right panel.

You can see in the below screenshot that column 1 is empty and column 2 lists serial numbers, and our actual data is listed in columns 3 and 4. Because we do not need columns 1 and 2, we have to delete them. For this, click on the “Edit” button at the bottom of the Navigator window. Some of you may have “Transform Data” in place of the “Edit” option depending on your MS Excel version. It will open the “Query Editor.”

Read: Excel Tips to Save Time and Work Faster.

7] We want to make our first row the header. For this, click on the top left corner and select “Use first row as headers.”

8] To delete unwanted columns, click the top left corner and select “Choose columns.” After that, uncheck the boxes of the columns that you do not want and click OK.

9] Now, click “Close & Load” to load the data of Google Sheet in Excel.

You have connected your Google Sheet with Excel. Whenever you make any changes to Google Sheet, you have to wait for 5 minutes to get those changes publish on the web. After that, you can have to refresh the excel file to get these changes reflected in the Excel file. For this, go to “Data > Refresh All.”

Read: Arrow keys not working in Excel.

If you want Excel to update by itself whenever you make changes to the Google Sheet, you have to do some more steps.

1] Select the table and go to “Data > Connections.” This will open a window in which you have to select “Properties.”

2] Now, click the “Refresh every” checkbox and enter the time after which you want the Excel to update automatically. I have entered 5 minutes. If you enable the “Refresh data when opening the file” option, Excel will check for updates every time you open it. When you are done, click OK and close the previous window.

That’s it. This is how you can connect Google Sheets with MS Excel.

Read next: Advanced Excel Tips and Tricks.

Related posts

• Xaashiyaha Google ee ugu Fiican iyo Hababka Jadwalka Kalandarka ee Excel Online

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo geliyo Shaxda Tusmada Google Docs

• Sida Loo Isticmaalo Qaabka Bilaashka Ah ee Kala-reebista ee Google Docs iyo Google Slides

• Sida si toos ah loogu soo saaro jaantusyada iyo sawirada Google Sheets

• Sida Documents loogu badalo PDF iyadoo Google Docs la isticmaalayo browser ah

• Sida loo dejiyo xadka Character ee Excel iyo Google Sheets

• Sida loogu daro Nambarada bogga Google Docs

• Sida loo beddelo hanuuninta bogga Google Docs

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Qaababka qaan-sheegga ugu fiican ee Google Docs ee Freelancers, Ganacsiga Yaryar

• Cilad browserka ayaa ka dhacday fariin - Google Docs on Chrome

• Sida loo rakibo oo looga saaro add-ons gudaha Google Docs

• Sida looga saaro Gridlines dukumeenti xaashida Google

• Sida loo midoobo oo loo kala saaro unugyada Google Doc Table