Xaashiyaha Google^{(Google Sheets)} waa beddelka wanaagsan ee bilaashka ah ee Microsoft Excel . Qaybta ugu fiican ee Google Sheets waa inaad ku rakibi karto waxyaabo kala duwan si kor loogu qaado socodka shaqada. Waxaad badbaadin kartaa waqti badan oo qiimo leh adiga oo isticmaalaya add-on. Waa kuwan qaar ka mid ah waxyaabaha lagu daro Google Sheets^{(add-ons for Google Sheets)} oo kaa caawin doona horumarinta wax soo saarkaaga.

Wax-ka-kordhinta Xaashiyaha Google-ka ugu Fiican

1] Qalabka Korontada^{(1] Power Tools)}

PowerTools waa wax aad waxtar u leh Google Sheets add-on kaas oo ka caawiya isticmaalayaasha sidii ay meesha uga saari lahaayeen dhammaan boosaska, hogaaminta/meelaha daba-galka ah, meelaha banaan ee u dhexeeya kelmado ilaa hal, qaybaha HTML^(HTML) , xadeeyayaasha, jilayaasha aan daabacin, xadhig-hoosaadka, jile ahaan boos ahaan, safaf/columnyo madhan, iwm. Marka laga reebo taas, waxaad u bedeli kartaa qoraalka lambar, qoraal si aad u saxiixdo, ku dar qaabab xisaabeed oo kala duwan, qaabeyn cad, iyo wax badan oo kale. Asal ahaan waxay caawisaa isticmaalayaasha marka qof khalad sameeyo, ama qof u baahan yahay inuu wax ka beddelo hal mar.

2] U keydi sidii Doc^{(2] Save As Doc)}

Marar badan, waxaan rabnaa inaan keydinno xaashida Excel oo leh qaab .docx ah. Haddii aad ka mid tahay iyaga, oo aad isticmaasho Google Sheets , waxaad si fudud ugu beddeli kartaa xaashi kasta oo Google Sheets samaysay faylka .docx kaas oo ku furmi kara Google Docs . Waxa kale oo aad ku kaydin kartaa feylkaas la gediyay dariiqa adag ee deegaankaaga sidoo kale. Si aad u bilowdo, soo deji SaveAsDoc^(SaveAsDoc) add-on Ka dib markaad bilowdo, waxaad arki doontaa bar-side. Hadda, dooro dhammaan safafka iyo tiirarka ku jira xaashida, magaca faylkaaga dukumeentiga ee dhinaca bar-side oo ku dhufo Keyd sida Doc^{(Save as Doc )} badhanka.

3] Hel oo Beddel Sare^{(3] Advanced Find and Replace)}

Inkasta oo Aaladaha Korantadu^{(Power Tools)} ay si fiican u qaban karaan shaqada, haddii aad rabto is-dhexgal isticmaale fudud oo leh hawlqabadyo fudud si aad u hesho oo aad u bedesho qiimeyaal ama qoraalo yar, waxaad dooran kartaa AdvancedFinandReplace^{(AdvancedFindandReplace)} add-on for Google Sheets . Waxaad hal mar heli kartaa oo bedeli kartaa qiyamyo badan, qaacido, qoraalo, hyperlinks, iwm. Qaybta ugu fiican ayaa ah inaad dooran karto inaad u baahan tahay inaad hawsha ku qabato dhammaan xaashida furan, ama xaashida hadda jirta.

4] Ciwaanka Iimayl-ka Soosaarayaasha^{(4] Email Address Extractor)}

Aynu ka soo qaadno inaad leedahay meherad onlayn ah oo aad u dirtay oo aad ka heshay imayl tiro badan macaamiishaada. Hadda waxaad rabtaa inaad soo saarto dhammaan ciwaannadaas iimaylka ujeeddo dhiirrigelin ah. U isticmaal wax -ku- kordhintan EmailAddressExtractor^{(EmailAddressExtractor)} ee Google Sheets - waxay kuu oggolaan doontaa inaad soo saarto dhammaan ciwaannada iimaylka hal mar. Si kastaba ha noqotee, xaddidaadda kaliya ayaa ah inaad soo saari karto kaliya 500 oo cinwaan ee iimaylka ugu horreeya adoo isticmaalaya isticmaale bilaash ah. Kadib marka aad rakibto ku-darkan, waxaad u baahan tahay inaad doorato calaamad Gmail ah ( Inbox , Spam , Sent , ama wax kasta), khadka mawduuca, erayada lagu daray, iyo meelaha. Waxa kale oo suurtogal ah in lagu daro filtarrada horumarsan - tusaale ahaan in laga soo saaro aqoonsiga^(IDs) emailka shirkad timid 30 maalmood ka hor.

5] Turjun xaashidayda^{(5] Translate My Sheet)}

Haddii aad inta badan u baahan tahay inaad qoraalka hal luqad u beddesho Google Sheets , waxaad isticmaali kartaa laba hab. Marka hore^(First) , waxaad nuqul ka samayn kartaa qoraalka xaashida, waxaad ku dhejin kartaa Google Translator , mar labaad ka nuqul ka samee oo ku dheji xaashida. Maadaama ay tahay shaqo wakhti badan qaadanaysa marka aad boqollaal saf ku haysato xaashida, waxaad dooran kartaa wax-ku-dar kaas oo kuu ogolaanaya inaad beddesho xaashida oo dhan hal mar. Waxaa loo yaqaan TranslateMySheet . Waxaad u rogi kartaa xaashida faafinta oo dhan ama kala duwanaansho kasta oo gaar ah oo laga bilaabo luqadda hadda jirta una beddelo luqad kale. Aad bay u dhakhso badan tahay waxayna si fiican u qabataa shaqada.

Waxaa jira boqolaal kale oo lagu daro Google Sheets, laakiin kuwani waxay u badan tahay inay yihiin aaladaha ugu faa'iidada badan halkaas.^{(There are hundreds of other add-ons for Google Sheets, but these are probably the most useful tools out there.)}

Best Google Sheets add-ons to improve productivity

Google Sheets is a good free alternative to Microsoft Excel. The best part of Google Sheets is that you can install various add-ons to enhance the workflow. You can save a lot of valuable time by making use of an add-on. Here are some add-ons for Google Sheets that will help improve your productivity.

Best Google Sheets add-ons

1] Power Tools

PowerTools is a very helpful Google Sheets add-on that helps users in removing all spaces, leading/trailing spaces, spaces between words to one, HTML entities, delimiters, non-printing characters, substring, character by position, empty rows/columns, etc. Apart from that, you can convert text to number, text to sign, include various mathematical formulas, clear formatting, and much more. It basically helps users when someone has made a mistake, or someone needs to change several things at once.

2] Save As Doc

Many times, we want to save an Excel sheet with a .docx format. If you are one of them, and you use Google Sheets, you can easily convert any spreadsheet made by Google Sheets into a .docx file that would open with Google Docs. You can save that converted file on your local hard drive as well. To get started, download the SaveAsDoc add-on. After starting it, you will see a sidebar. Now, select all the rows and columns in the spreadsheet, name your document file in the sidebar and hit the Save as Doc button.

3] Advanced Find and Replace

Although Power Tools can do the job pretty well, if you want a simple user interface with simple functionalities to find and replace a few values or notes, you can opt for AdvancedFindandReplace add-on for Google Sheets. You can find and replace multiple values, formulas, notes, hyperlinks, etc. at once. The best part is that you can choose whether you need to perform the task in all opened sheets, or current sheet.

4] Email Address Extractor

Let’s assume that you have an online business and you have sent and received tons of email to/from your customers. Now you want to extract all those email addresses for promotion purpose. Use this EmailAddressExtractor add-on for Google Sheets – it will let you extract all the email addresses at once. However, the only restriction is that you can extract only first 500 email addresses being a free user. After installing this add-on, you need to select a Gmail label (Inbox, Spam, Sent, or anything), subject line, included words, and fields. It is also possible to add advanced filters – eg to extract email IDs from a company which came before 30 days.

5] Translate My Sheet

If you often need to convert text from one language to another in Google Sheets, you can use two methods. First, you can copy the text from a spreadsheet, paste it in Google Translator, again copy it from there and paste it in the spreadsheet. As it is a time-consuming work when you have hundreds of rows in a sheet, you can opt for an add-on that will let you convert the whole sheet at once. It is called TranslateMySheet. You can convert the whole spreadsheet or any particular range from the current language to any other language. It is fast and does the job pretty well.

There are hundreds of other add-ons for Google Sheets, but these are probably the most useful tools out there.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

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

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

• Sida loogu isticmaalo Habka Madow gudaha Google Docs, Sheets, iyo Slides

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

• Qaababka shaqo ee ugu wanaagsan ee Google Docs si loo abuuro CV xirfad leh

• Sida loogu daro Google Keep Notes Google Docs

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

• Sida loo sameeyo Google Slides loop iyada oo aan la daabicin

• Sida loo soo celiyo Menu Toolbar ee maqan ee Google Docs

• U beddelo Word, PowerPoint, Excel Documents PDF adoo isticmaalaya Google Docs

• Sida loogu daro tixraacyada iyo tixraacyada Google Docs

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

• Sida loo sameeyo tiirar Google Docs ah

• Sida PDF loogu tafatiro Google Docs ee shabakada

• Wax-ku-darka Google Docs-ka ugu fiican ee qorayaasha madax-bannaan

• Sida loogu daro Nambarada bogga Google Docs

• Sideed ugu duubtaa qoraalka sawirka Google Docs

• Sida loo abuuro Indent Hang ee Microsoft Word iyo Google Docs