Dhammaan codsiyada shabakadda G Suite^{(G Suite web applications)} , Google Sheets ayaa laga yaabaa inay tahay tan ugu wanagsan. La sii daayay 2006, waxay si dhakhso ah u noqotay tartame adag si ay uga hortagto Microsoft Excel oo ah tifaftiraha xaashida faafinta ee soo socda iyo soo socda.

Maanta, Google Sheets waxaa ku jira waxyaabo badan oo tafatirka iyo iskaashiga ah oo malaayiin arday, shaqaale ah, iyo kuwa hiwaayadda ku jira ay isticmaalaan maalin kasta.

Mid ka mid ah sifada Google-ka ee aadka loo mahdiyo ayaa ah hawlaheeda ugu adag. Shaqaaluhu waa xudunta u ah waxa ka dhigaya xaashida mid aad u xoog badan, iyo goob kasta oo wax lagu daabaco xaashida faafinta ahi waxay leedahay dhawr hawlood oo gaar ah.

Hawsha MUHIIMKA AH ee Sheetka^{(IMPORTRANGE)} Google waxa ay ogolaataa heer isku xidhid aan toos ahayn oo u dhexeeya laba xaashiyaha xaashida ama wax ka badan, taas oo awood u siinaysa fursado badan oo xiiso leh. Waxay kuu ogolaanaysaa inaad xogta soo geliso Google Sheets .

Waa maxay ^{(What Is )}MUHIIM ^{(IMPORTRANGE)}?

IIMPORTRANGE waa mid ka mid ah hawlaha badan ee ay taageerto Google Sheets^{(functions supported by Google Sheets)} . Functions waxa loo isticmaalaa in lagu abuuro qaacido wax ka beddeli kara xogtaada xaashida, samaynta xisaabinta, iyo in ka badan.

Qaar ka mid ah in ka badan 100 hawlood oo la taageeray waxaa ka mid ah TAARIIKHDA^(DATE) , si loogu beddelo xadhig taariikh, COS , soo celinta xagalka xagasha ee lagu bixiyo iftiinka, iyo ROUND , taas oo u oggolaanaysa jajab tobanle in lagu soo koobo meel jajab tobanle ah.

Waxa ku jira liiskan dheer ee hawlaha waa MUHIIM^{(IMPORTRANGE)} . MUHIIMEYN^{(IMPORTRANGE)} waxay awood u siinaysaa qaab isdhexgalka xaashida isdhaafsiga ah, taasoo u ogolaanaysa unugyo kala duwan oo xaashi kale ah (ama warqad shaqo oo isla xaashi ah) in la soo dejiyo.

Tani waxay u ogolaanaysaa isticmaalayaasha Google Sheets inay u qaybiyaan xogtooda xaashiyo kala duwan iyagoo wali awood u leh inay daawadaan iyagoo isticmaalaya qaacido fudud. Si gaar ah, waxa ay sidoo kale ogolaataa heerka wada shaqaynta halkaas oo aad xogta ka soo dejisan karto xaashida dhinac saddexaad (haddii la oggol yahay) adiga oo iska leh.

Sida Loo Isticmaalo ^{(How To Use )}MUHIIMKA^{(IMPORTRANGE)}

Tallaabada ugu horreysa ee isticmaalka shaqadan xoogga badan waa inaad haysato xaashida faafinta oo aad rabto inaad xogta ka soo dejiso Google Sheets . Ama hel mid ama, sida aan ku samayn doono tusaalahan, samee xaashi dhumuc ah oo leh dhawr saf oo xog ah.

Halkan, waxaan ku haynaa xaashi fudud oo ka kooban laba tiir iyo saddex saf. Hadafkayagu waa inaan qaadano xogtan oo aan ku soo dejinno xaashi kale oo aan isticmaaleyno. Samee xaashi cusub ama gal xaashi hore oo aan dhigno.

Waxaad ku bilaabi doontaa isla habka aad samayn lahayd marka aad isticmaalayso hawl kasta—guji unug maran si aad u gasho barta shaqada. Ku qor =IMPORTRANGE . Tani waa ereyga muhiimka ah ee shaqada ee aan u isticmaali karno soo dejinta xogta xaashida.

Shaqada IIMPORTRANGE^{(IMPORTRANGE)} waxay isticmaashaa laba halbeeg oo isku xidhkeeda aasaasiga ah: IMPORTRANGE (spreadsheet_url, range_string). Aan labada dhinac u gudubno.

spreadsheet_url waa sida uu u eg yahay- URL ee xaashida xaashida ee aad isku dayayso inaad ka soo dejiso xog kala duwan. Waxaad si fudud u koobi kartaa oo dhejisaa URL^(URL) -ka xaashida iyo halkan. Xitaa ka sahlan, waxaad si ikhtiyaar ah u isticmaali kartaa xargaha aqoonsiga xaashida, sidoo kale laga helay URL- ka .

Aqoonsigani waa xardhanka dheer ee qoraalka laga helo inta u dhaxaysa " xaashiyaha/d/" iyo "/wax ka beddel" URL xaashida . Tusaalahan, waa “1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI” .

Qiyaasta_string_string waa sida ugu fudud. Halkii aad ka daabacan lahayd dhammaan xogta xaashida xaashida ee xaashi kale, waxaad soo celin kartaa kala duwanaansho gaar ah. Si loo soo dejiyo xogta lagu muujiyay dhammaan xaashida tusaalaheena, kala duwanaanshiyaha ayaa noqon doona A1:B4 . 

Tan waxa loo fududayn karaa oo keliya A:B haddii aanu ku wanaagsannahay ka soo dejinta dhammaan xogta mustaqbalka ee tiirarkan. Haddi aan rabno in aan soo dajino xogta madax la'aan, taasi waxay noqonaysaa A2:B4 .

Aan isku soo wada duubno qaacidadayada oo dhan: = MUHIIM("1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI", "A:B")

Waxaad ogaan doontaa in isku dayga isticmaalka qaaciidadan, adigoo u malaynaya inaad si habboon u bedeshay spreadsheet_url, waxay marka hore muujin doontaa cilad tixraaceed. Waxaad u baahan doontaa inaad gujiso unugga si aad ugu xidhid labadan xaashi.

Haddii wax walba si sax ah loo sameeyay, waa inaad hadda aragto xogta lagu soo geliyay xaashida hadda jirta.

Fudud, sax? Waxaa xusid mudan in qaabaynta aan la ilaalin doonin inta lagu jiro soo dejintan, sida aad kor ku arki karto, laakiin dhammaan xogta qoraalka cad ayaa ahaan doona.

Waa maxay sababta loo isticmaalo ^{(Why Use )}MUHIIMKA ^{(IMPORTRANGE)}?

Hadda oo aad aragto sida ay u fududahay isticmaalka MUHIIMKA AH^{(IMPORTRANGE)} , maxaad waligaa u isticmaali lahayd? Aynu ka gudubno dhawr tusaale oo degdeg ah oo la isticmaalo kiisaska.

Ururka Wanaagsan^{(Better Organization)}

Waxaa laga yaabaa inaad isku aragto inaad ku lug leedahay xaashi aad u adag oo leh doorsoomayaal dhaqaaqa oo aad rabto inaad gabi ahaanba ka soocdo qaybaha kale ee xogtaada. MUHIIMAHA^{(IMPORTRANGE)} ayaa ku fiican tan, maadaama ay kuu ogolaaneyso inaad sidaas sameyso.

Mar haddii ay IIMPORTRANGE^{(IMPORTRANGE)} si fudud kuu ogolaato inaad xogta ka soo dejiso xaashi kale oo ku jirta isla xaashida faafinta, waxaad samayn kartaa xaashi shaqo oo “Variables” ah oo aad ku kaydin karto wax kasta oo leh qaybo dhaqaaqa. Isku darka MUHIIMAHA^{(IMPORTRANGE)} , QUERY , iyo CONCATENATE ayaa markaa loo isticmaali karaa in la isku keeno wax walba.

La shaqaynta Saaxiibka^{(Collaborating With a Friend)}

Laba madax ayaa ka fiican hal, IMPORTRANGE xitaa wuxuu kuu ogolaanayaa inaad ku xidho xaashida akoonkaagu aanu lahayn, ilaa inta ay kula wadaagto. Haddii aad ka shaqaynayso mashruuc iskaashi, shaqada laba qof ama in ka badan ayaa si firfircoon loogu ururin karaa hal xaashi iyadoo la isticmaalayo MUHIIM^{(IMPORTRANGE)} .

Qarinta Xogta Xasaasiga ah^{(Hiding Sensitive Data)}

Haddii aad haysato xaashi gaar ah oo leh saf ama tiirar aad rabto inaad si guud u muujiso, IIMPORTRANGE^{(IMPORTRANGE)} ayaa taas ku fiican.

Hal tusaale ayaa noqon lahaa haddii aad samayn lahayd foom leh foomamka Google^{(Google Forms)} -ka . Gudaha dhexdiisa, waxaa laga yaabaa inaad weydiiso qaar ka mid ah macluumaadka shakhsiyeed ee jawaab-bixiyeyaasha - sida iska cad ma rabtid inaad bixiso taas, sax? Si kastaba ha ahaatee, foomku waxa kale oo laga yaabaa inuu ku weydiiyo su'aalo gaar ah oo ka yar oo aad rabto inaad ku muujiso xiriirka dadweynaha ee la wadaago. Markaad dejiso xadka_string si habboon oo isku xidha xaashida jawaabta foomka, tan waa la gaadhi karaa.

IMPORTRANGE waa qalab awood badan oo Google^{(Google Sheets)} -ka ah kaas oo si fiican ugu adeega xaalado kala duwan oo kala duwan halkaas oo aad u baahan tahay inaad xogta ku soo geliso Google Sheets . Waa mid ka mid ah dookheyga kala duwanaanshaha^{(differences between Google Sheets and Microsoft Excel)} ugu muhiimsan ee Google Sheets iyo Microsoft Excel . 

Ma qabtaa wax su'aalo ah oo ku saabsan sida aad u isticmaali karto shaqadan, ama waxaad rabtaa inaad nala wadaagto mid la mid ah? Hoosta faallooyinka ku rid waan hubin doonnaa!

How To Import Data Into Google Sheets From Another Sheet

Of all of the G Suite web applications, Google Sheets may be the most impressive. Released in 2006, it quickly became a fierce competitor to stand up against Microsoft Excel as an up-and-coming spreadsheet editor.

Today, Google Sheets includes a wealth of editing and collaboration features that millions of students, workers, and hobbyists use on a daily basis.

One of Google Sheets’ most appreciated features is its robust set of functions. Functions are a core component to what makes spreadsheets so powerful, and each spreadsheet editing platform usually has several of its own unique functions.

Google Sheet’s IMPORTRANGE function allows a level of seamless connectivity between two or more spreadsheets, enabling many interesting possibilities. It allows you to import data into Google Sheets.

What Is IMPORTRANGE?

IMPORTRANGE is one of the many functions supported by Google Sheets. Functions are used to create formulas that can manipulate your spreadsheet data, make calculations, and more.

Some of the more than 100 supported functions include DATE, to convert a string into a date, COS, to return the cosine of an angle provided in radiances, and ROUND, allowing decimals to be rounded to a certain decimal place.

Included in this long list of functions is IMPORTRANGE. IMPORTRANGE enables a form of cross-spreadsheet integration, allowing a range of cells from another spreadsheet (or worksheet within the same sheet) to be imported.

This allows Google Sheets users to split up their data into multiple different sheets while still being able to view it using a simple formula. Uniquely, it also allows a level of collaboration where you can import data from a third-party sheet (if permitted) into your own.

How To Use IMPORTRANGE

The first step to making use of this powerful function is to have a spreadsheet that you want to import data from into Google Sheets. Either locate one or, as I’ll do in this example, create a dummy sheet with a few rows of data.

Here, we have a simple sheet of two columns and three rows. Our goal is to take this data and import it into another spreadsheet that we’re using. Create a new sheet or go into an existing sheet and let’s set it up.

You’ll begin with the same process as you would when using any function—click a blank cell so that you can access the function bar. In it, type =IMPORTRANGE. This is the function keyword we can use for importing sheet data.

The IMPORTRANGE function uses two parameters in its basic syntax: IMPORTRANGE(spreadsheet_url, range_string). Let’s go over both.

spreadsheet_url is exactly what it sounds like—the URL of the spreadsheet that you’re attempting to import a range of data from. You simply copy and paste the spreadsheet’s URL and here. Even easier, you can optionally just use the spreadsheet’s identifier string, also found in the URL.

This identifier is the long string of text found between “spreadsheets/d/” and “/edit” in the sheet’s URL. In this example, it’s “1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI”.

The range_string parameter is just as simple. Instead of printing all of the spreadsheet data from another sheet, you can return a specific range. To import the data shown in the entire sheet of our example, the range would be A1:B4. 

This can be simplified to just A:B if we’re fine with importing all future data from these columns. If we wanted to import the data without headers, that’d be A2:B4.

Let’s put together our full formula: =IMPORTRANGE(“1bHbpbisrzaLF34r91UD1SLdDCpx7gD4v_4RnFBvgbfI”, “A:B”)

You’ll notice that attempting to use this formula, assuming you’ve properly replaced spreadsheet_url, will initially show a reference error. You’ll need to then click on the cell to connect these two sheets.

If everything has been done correctly, you should now see the data imported into your current sheet.

Simple, right? It’s worth noting that formatting will not be preserved during this import, as you can see above, but all of the plaintext data will be.

Why Use IMPORTRANGE?

Now that you see how easy it is to use IMPORTRANGE, why would you ever use it? Let’s go over a few quick example use cases.

Better Organization

You may find yourself involved in a very complex sheet that has moving variables that you want to separate completely from other parts of your data. IMPORTRANGE is perfect for this, as it allows you to do just that.

Since IMPORTRANGE easily allows you to import data from another worksheet within the same spreadsheet, you can create a “Variables” worksheet where you can store anything with moving parts. A combination of IMPORTRANGE, QUERY, and CONCATENATE could then be used to bring everything together.

Collaborating With a Friend

Two heads are better than one, and IMPORTRANGE will even allow you to connect to sheets that your account doesn’t own, as long as it’s shared with you. If you’re working on a collaborative project, the work of two or more people can be dynamically consolidated into a single sheet using IMPORTRANGE.

Hiding Sensitive Data

If you have a private spreadsheet with rows or columns that you want to show publicly, IMPORTRANGE is great for that.

One example would be if you were to create a form with Google Forms. In it, you may ask for some of the respondents’ personal information—you obviously don’t want to give that out, right? However, the form may also ask less personal questions that you want to display in a public shared link. By setting the range_string accordingly and connecting the form’s response sheet, this can be achieved.

IMPORTRANGE is a powerful Google Sheets tool that serves well in a variety of different situations where you need to import data into Google Sheets. It’s one of my picks for the most important differences between Google Sheets and Microsoft Excel. 

Do you have any questions on how you can use this function, or want to share one like it with us? Drop a comment below and we’ll check it out!

Related posts

• Sida Xogtaga Shakhsiyeed looga soo dejiyo Google

• Sida Si Toos ah Loogu Soo Celiyo Faylasha Google Drive ama OneDrive si Looga Hortago Luminta Xogta

• Sida loo soo dejiyo Google Chrome Offline (Standalone) Rakibaye

• Sida Muusiga loogu daro Google Slides

• Sida Loo Sameeyo Foomka Dukumentiga Google-ka La Buuxin Karo

• Sida loo habeeyo oo loo maamulo xasuusiyayaasha Google

• Sida Fiidiyowga Loogu Geli karo Slides Google

• Sida loo furo HTML File Google Chrome

• Sida Loo Sameeyo Xaqiijinta Jawaabta Foomamka Google

• Sida loo dejiyo ciwaanka gurigaaga khariidadaha Google

• Sida Animation loogu daro Google Slides

• Sida Loo Damiyo OK Google-ka Aaladaada Android

• Sida Loogu Wareejiyo Xogta Taleefanka Cusub ee Android

• Sida Loo Helo nuqul ka mid ah Safafka iyo Unugyada Xaashiyaha Google-ka

• Sida Loo Isticmaalo Kaabaynta Google Iyo Isku-xidhka Si Aad Hard Drive-kaaga U Samayso

• Sida Loola Xidhiidho Google Calendar Iyo Muuqaalka

• Sida loo beddelo Margins gudaha Google Docs

• Beddel Goobta Faylka ee Google Chrome ka soo dejinta

• Sida loo xannibo mareegaha Google Chrome

• Sida loo Isticmaalo If iyo Nsted Haddii ku jira Google Sheets