Haddii aad ku shaqaynaysay xogta Excel oo aad xaqiiqsatay inaad rabto inaad isticmaasho hawlaha xaashida Google^{(Google Sheets)} ama qoraalka, way fududahay inaad u beddesho faylasha Excel una beddelo Google Sheets .

Si kastaba ha ahaatee, waxaa jira siyaabo badan oo aad taas ku sameyn karto iyadoo ku xiran qaabka xogta asalka ah^{(format of the original data)} . Nidaamku wuxuu ku xiran yahay haddii xaashida xaashida ee Excel lagu keydiyay qaabka CSV , qaabka caadiga ah ee Excel , ama ay ku jirto qoraal kasta oo horeyba.

Maqaalkan waxaan ku eegi doonaa afar siyaabood oo aad ugu bedeli karto faylasha Excel xaashida xaashida Google^{(Google Sheets)} .

1. Ugu Fudud: U beddel Excel^{(Convert Excel)} una beddel Google Sheets oo wata koobi^(Copy) iyo Paste

Haddii aad u baahan tahay oo kaliya inaad xogta ka beddesho Excel una beddesho Google Sheets oo aadan haysan hawlo adag ama qoraallo xagga dambe ah, koobiga fudud iyo dhejiska xogta ayaa sameyn doona.

1. Si tan loo sameeyo, kaliya calaamadee dhammaan unugyada aad rabto inaad ku daabacdo Excel^(Excel) . Midig^(Right) ku dhufo meel kasta oo ka mid ah xadka la doortay oo dooro Nuqul^(Copy) .

2. Midig ku dhufo unugga bidix ee sare ee xaashida xaashida Google^{(Google Sheets)} -ka halkaas oo aad rabto inaad xogta dhigto. Dooro Ku dheji^(Paste) .

Tani waxay ku buuxin doontaa xaashida dhammaan xogta aad ka guurisay xaashida xaashida ee Excel . Way fududahay taas.

2. Laga soo bilaabo Excel File : Kaliya si toos ah u fur faylka Excel^{(Excel File Directly)}

Waxaad si toos ah u furi kartaa faylka  Excel (*.XLSX), laakiin waxaad u baahan doontaa inaad marto tallaabo aad marka hore galeyso.^(Excel)

Gudaha Google Sheets , raac talaabooyinkan si aad si toos ah ugu furto faylka Excel .

1. Ka dooro Faylka^(File) menu-ka, oo dooro Fur^(Open) ama Soo Dejin^(Import) .

1. Daaqadda soo muuqata, dooro tab Upload ka dibna dooro faylka ka dooro badhanka qalabkaaga^{(Select a file from your device)} .

1. Ka^(Browse) dhex raadi faylka Excel ee ku kaydsan kombayutarkaaga, dooro oo dooro badhanka Furan^(Open) . 

1. Tani waxay soo gelin doontaa faylka Excel ka dibna waxay ku furi doontaa Google Sheets . 

Waxaad ogaan doontaa dhowr waxyaalood oo dhacaya markaad isticmaasho habkan si aad Excel ugu beddesho Google Sheets .

• Faylka Excel wuxuu si toos ah u beddelaa qaabka Google Sheets .
• Waxay ku furmaysaa xaashi cusub oo lagu sameeyay akoonkaaga Google Sheets .
• Habayntu waxay u dhigantaa tan xaashida asalka ah ee Excel intii suurtogal ah.

3. Ka Soo Dejinta CSV : Si Toos Ah^{(Import Directly)} Uga Soo Dejiya Faylka CSV

Waxaad si toos ah uga soo dejisan kartaa faylka Excel kaas oo ku kaydsan ^(Excel)qaabka CSV^{(CSV format)} . Si kastaba ha ahaatee, waxaad u baahan doontaa inaad ogaato sida faylka loo xaddiday; haddii ay tahay tab ama comma xaddidan tahay, ama leh dabeecad kale.

Isticmaalka Muuqaalka Soo Dejinta^{(Using the Import Feature)}

Raac isla nidaamka kore, laakiin marka aad doorato faylka CSV , waxaad arki doontaa daaqad aad ku doorato waxa qaabaynta faylka, iyo sida aad u rabto inaad xogta xaashida ugu beddelato xaashida Google Sheet .

Waxa kale oo aad habayn kartaa haddii aad rabto in aad xogta ku furto xaashi cusub, si aad u beddesho xaashida hadda, ama aad ku lifaaqdo xaashida hadda. Sidoo kale habee in aad rabto in qoraalka faylka CSV loo rogo nooca xogta ku habboon (lambarada, taariikhaha, iyo qaaciidooyinka).

Markaad samaysato ikhtiyaarada beddelka, dooro soo dejinta^(Import) xogta si aad u keento xogta faylka CSV xaashidaada Google^{(Google Sheets)} -ka .

Isticmaalka Shaqada IMPORTDATA^{(Using the IMPORTDATA Function)}

Hab kale oo lagu keeno xogta feylka Excel ee lagu kaydiyay qaabka ^(Excel)CSV waa iyadoo la isticmaalayo shaqada IMPORTDATA ee Google Sheets .

Waxaa jira hal qabsasho habkan. Faylka wuxuu u baahan yahay in lagu keydiyo server-ka shabakadda internetka, oo laga heli karo xiriir toos ah. Tusaale ahaan, Xafiiska Tirakoobku^{(Census Bureau)} wuxuu bixiyaa faylal badan oo xog ah oo qaabka CSV ah, sida wadarta guud ee dadweynaha gobol ahaan xiriirka soo socda: 

https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv

Waxaad si toos ah uga soo dejisan kartaa xogta faylka CSV sida ^(CSV)xaashida xaashida Google^{(Google Sheets)} -ka adiga oo isticmaalaya shaqada IMPORTDATA .

1. Fur xaashida xaashida Google^{(Google Sheets)} -ka cusub . Guji^(Click) qolka aad rabto in xogta la keeno ay tagto. Unuggaas , ku qor: 

=IMPORTDATA(“https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv”)

2. Markaad riixdo Gelida^(Enter) , waxaad arki doontaa heerka loading dhowr ilbiriqsi. Markaa xogta oo dhami waxay ka muuqan doontaa xaashida faafinta.

3. Haddii aad rabto in aad sawir ka qaadatid xogta oo aad geliso xaashi cusub si aanay dib u cusboonaysiin wakhti kasta oo xogta CSV -ga ee internetka is beddesho, kaliya muuji dhammaan unugyada xaashida asalka ah oo koobiyi iyaga. Kadib fur xaashi cusub, ku dhufo midigta qolka aad rabto in xogtaadu tagto oo dooro Paste special , ka dibna ku dheji qiyamka kaliya^{(Paste values only)} .

Tani waxay koobiyn doontaa dhammaan xogta asalka ah oo geli doonta xaashi cusub oo taagan oo ku jirta Google Sheets .

4. Ku Fur: Faylka Fur^{(Open File)} Kadib Uploading

Waxaa jirta hal farsamo oo kale oo Excel loogu badali karo Google Sheets . Tani waxay shaqaynaysaa haddii faylka lagu kaydiyay qaabka CSV ama XLSX . 

1. Si toos ah ugu soo rar faylka koontadaada Google Drive gudaha gal kasta.

2. Midig ku dhufo faylka oo dooro ku fur^{(Open with)} , ka dibna dooro Google Sheets .

3. Haddii kani yahay faylka CSV , wuxuu si toos ah ugu furmi doonaa qaabka ^(CSV)Google Sheets . Hadii ay tahay qaabka XLSX waxa ay ku furmi doontaa Google Docs oo ah qaabka XLSX . Waxa aad arki doontaa tan oo lagu soo bandhigay xagga sare. Si aad ugu bedesho qaabka Google Sheets , ka dooro Faylka^(File) liiska ka dibna dooro Save as Google Sheets . 

Tani waxay u rogi doontaa xaashida faafinta oo u furi doonta xaashi cusub oo Google^{(Google Sheets)} -ka ah .

U beddelashada Excel una beddelo Google Sheets

Sida aad arki karto waxaa jira wax ka badan hal hab oo lagu helo xogta xaashida Excel ee ^(Excel)Google Sheets . Habka aad dooratay waxay ku xiran tahay qaabka faylka asalka ah^{(format of the original file)} , iyo habraaca ku dareemaya midka kuugu habboon.

4 Ways to Convert Excel to Google Sheets

If you’vе been working with data in Excel and you’ve realized you want to use Google Shеets functions or scripting, it’s fairly easу to conνert files from Excel to Google Sheets.

However, there are multiple ways you can do this depending on the format of the original data. The process depends on whether the Excel spreadsheet is saved in CSV format, standard Excel format, or includes any scripting already.

In this article we’ll look at four ways you can convert Excel files to a Google Sheets spreadsheet.

1. Simplest: Convert Excel to Google Sheets with Copy and Paste

If you only need to convert data from Excel to Google Sheets and you don’t have any complicated functions or scripts in the background, a simple copy and paste of the data will do.

1. To do this, just highlight all of the cells you want to copy in Excel. Right click anywhere in the selected range and select Copy.

2. Right-click in the upper left cell in the Google Sheets spreadsheet where you’d like to place the data. Select Paste.

This will fill in the sheet with all of the data you’ve copied from the Excel spreadsheet. It’s as simple as that.

2. From Excel File: Just Open the Excel File Directly

You can open an Excel file (*.XLSX) directly, but you’ll need to go through a step to upload the file first. 

In Google Sheets, just follow these steps to open an Excel file directly.

1. Select File from the menu, and select Open or Import.

1. In the window that appears, select the Upload tab and then select the Select a file from your device button.

1. Browse to the Excel file that’s stored on your computer, select it, and select the Open button. 

1. This will upload the Excel file and then open it in Google Sheets. 

You will notice several things happen when you use this approach to convert Excel to Google Sheets.

• The Excel file automatically converts to Google Sheets format.
• It opens in a newly created spreadsheet in your Google Sheets account.
• The formatting matches that of the original Excel spreadsheet as much as possible.

3. Importing CSV: Import Directly From an CSV File

You can import directly from an Excel file that’s saved in CSV format. However, you’ll need to know how the file is delimited; whether it’s tab or comma delimited, or with some other character.

Using the Import Feature

Follow the same procedure above, but when you select the CSV file, you’ll see a window to select what the formatting of the file is, and how you want to convert the spreadsheet data into a Google Sheet spreadsheet.

You can also configure whether you want to open the data in a new spreadsheet, to replace the current sheet, or append to the current sheet. Also configure whether you want the text from the CSV file converted to the appropriate data type (numbers, dates, and formulas).

Once you’ve made your conversion options, select Import data to bring the CSV file data into your Google Sheets spreadsheet.

Using the IMPORTDATA Function

Another approach to bringing in data from an Excel file saved in CSV format is by using the IMPORTDATA function in Google Sheets.

There is one catch to this approach. The file needs to be stored on a web server online, and accessible via a direct link. For example, the Census Bureau provides lots of data files in CSV format, such as population totals by state at the following link: 

https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv

You can import the data directly from such a CSV file into your Google Sheets spreadsheet using the IMPORTDATA function.

1. Open a new Google Sheets spreadsheet. Click on the cell where you want the imported data to go. In that cell, type: 

=IMPORTDATA(“https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv”)

2. When you press Enter, you’ll see a loading status for a few seconds. Then all of the data will show up in the spreadsheet.

3. If you want to take a snapshot of the data and put it into a new spreadsheet so that it doesn’t update any time the source CSV data changes online, just highlight all of the cells of the original sheet and copy them. Then open a new sheet, right-click in the cell where you want the data to go and select Paste special, then Paste values only.

This will copy all of the original data into a new, static spreadsheet in Google Sheets.

4. Open With: Open File After Uploading

There is one more technique to convert Excel to Google Sheets. This works whether the file is saved in CSV or XLSX format. 

1. Upload the file directly to your Google Drive account inside any folder.

2. Right-click the file and choose Open with, then choose Google Sheets.

3. If this is a CSV file, it’ll open directly in Google Sheets format. If it’s in XLSX format it will open in Google Docs in XLSX format. You’ll see this displayed at the top. To convert it to Google Sheets format, select File from the menu and then select Save as Google Sheets. 

This will convert the spreadsheet and open it into a new spreadsheet in Google Sheets.

Converting Excel to Google Sheets

As you can see there’s more than just one way to get Excel spreadsheet data into Google Sheets. The approach you choose depends on the format of the original file, and which procedure feels the most convenient to you.

Related posts

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

• Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel iyo Google Sheets

• Waa maxay sababta ay tahay inaad u isticmaasho safafka la magacaabay ee Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Sida loo Geliyo Watermark gudaha Word iyo Google Docs

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida Loo Wadaago Faylka Excel Si Fudud Layskula Shaqeeyo

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Sida loo Hagaajiyo #N/A Khaladaadka gudaha Foomamka Excel sida VLOOKUP

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida loo isticmaalo Excel's What-If Analysis

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel