Haddii aad haysato liis shay ah oo ku jira faylka qoraalka oo aad rabto inaad ka soo dejiso xogta faylka qoraalka Microsoft Excel^{(import data from a text file into Microsoft Excel)} , waxaad samayn kartaa taas adigoon gacanta ku qorin. Waxaa jira ikhtiyaar ku jira Excel kaas oo u oggolaanaya dadka isticmaala inay ka soo dejiyaan dhammaan qoraallada faylka .txt ee xaashida faafinta si dadka isticmaala ay si dhakhso ah u qabtaan shaqada.

Aynu ka soo qaadno inaad haysatid liiska alaabta ee Notepad ama faylka .txt , oo aad u baahan tahay inaad ku soo dejiso tiir ku jira xaashida Excel . Waxaa jira laba siyaabood oo taas loo sameeyo. Marka hore^(First) , waxaad gacanta ku koobi kartaa oo ku dhejin kartaa dhammaan qoraallada faylka .txt oo ku dheji xaashida. ^(.txt)Marka labaad^(Second) , waxaad isticmaali kartaa gudaha gudaha ee Microsoft Excel si aad u fududeyso. Habka labaad ayaa ku habboon marka aad haysato tiro badan oo qoraallo ah oo u baahan in la soo dejiyo.

Sida faylka qoraalka^(Text) loogu beddelo xaashida xaashida ee Excel

Aynu aragno sida looga soo dejiyo ama looga dhoofiyo xogta faylka qoraalka^(Text) si loogu beddelo qoraalka qoraalka (.txt ama ^(Text).csv^{(Microsoft Excel)} ) faylka Excel ( .xlsx ) si fudud hage-

1. Ku samee xaashi faaruq ah gudaha Excel
2. Tag tab xogta
3. Guji From Text/CSV
4. Dooro faylka qoraalka ee kombiyuutarkaaga oo guji badhanka soo dejinta
5. Dooro asalka faylka oo guji badhanka Xogta Wareejinta^{(Transfer Data)}
6. Dooro^(Select) tiirarka aad rabto inaad soo dejiso
7. Guji xidhid & badhanka

Furst , ku samee xaashida faaruqinta ee Microsoft Excel oo hubi in aad haysato faylka .txt ee kombayutarkaga. ^(.txt)Intaa ka dib, ka beddel tabka Home una beddel ^(Home)xogta^{(Data )} .

Halkan waxa aad ka heli kartaa doorasho la yidhaahdo From Text/CSV . Haddii aadan heli karin doorashadan, u tag Hel Xog^{(Get Data )} > Ka Faylka^{(From File )} > From Text/CSV .

Kadib, waa inaad doorataa faylka qoraalka meesha aad rabto inaad ka soo qaadato xogta. Kadib markaad gujiso badhanka Import , waxay ku waydiinaysaa inaad geliso asalka faylka^{(File Origin)} . Haddii aad abuurtay faylka, waxaad raaci kartaa Galbeedka Yurub (Windows)^{(Western European (Windows))} ama wax kasta oo u dhigma asalka. Ka dib markaad taas sameyso, dhagsii badhanka Transfer Data .

Waxay furi doontaa daaqada Tafatirka Query Query ^{(Power Query Editor)}Laga soo bilaabo halkan, waxaa suurtagal ah in la doorto tiirka aad rabto inaad hayso ama ka saarto. Waxaa jira laba ikhtiyaar oo lagu magacaabo Dooro Tiirarka^{(Choose Columns)} oo Ka saar Tiirarka^{(Remove Columns)} .

Sidoo kale, waxaad heli kartaa doorashooyin aad ku kaydsato oo aad tirtirto safafka sidoo kale. Isticmaal si aad xogtaada u habayso oo guji xidhid &^{(Close & Load)} badhan si aad u dhamaystirto soo dejinta.

That’s it!

Hadda, waa inaad ka heshaa xogta faylkaaga qoraalka xaashida.

How to convert a Text (TXT/CSV) file into an Excel file

If уou have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually. There is an option in Excel that allows users to import all the texts from .txt file into the spreadsheet so that users can do the job quickly.

Let’s assume that you have a product list in a Notepad or.txt file, and you need to import them in a column in an Excel spreadsheet. There are two ways to do that. First, you can manually copy and paste all the texts from the .txt file and paste it in the spreadsheet. Second, you can use the in-built option of Microsoft Excel to make it easier. The second method is convenient when you have a large number of texts that need to be imported.

How to convert a Text file into an Excel spreadsheet

Let us see how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily To import data from a text file into Microsoft Excel, follow this step by step guide-

1. Create a blank spreadsheet in Excel
2. Go to the Data tab
3. Click on From Text/CSV
4. Select text file in your computer and click the import button
5. Choose the file origin and click the Transfer Data button
6. Select which columns you want to import
7. Click the Close & Load button

Furst, create a blank spreadsheet in Microsoft Excel and make sure that you have the .txt file in your PC. After that, switch from the Home tab to the Data tab.

Here you can find an option called From Text/CSV. If you cannot find this option, go to Get Data > From File > From Text/CSV.

Then, you have to select the text file from where you want to fetch the data. After clicking the Import button, it asks you to enter the File Origin. If you have created the file, you can go with Western European (Windows) or anything that matches the origin. After doing that, click the Transfer Data button.

It will open the Power Query Editor window. From here, it is possible to choose the column that you want to keep or remove. There are two options named Choose Columns and Remove Columns.

Similarly, you can get options to save and delete rows as well. Use them to customize your data and click the Close & Load button to complete the importation.

That’s it!

Now, you should find your text file data in the spreadsheet.

Related posts

• Sida loo joojiyo ama loo qariyo qoraalka qulqulka ee Excel

• U qaabee qoraalka sidii Superscript ama Subscript ahaan Word, Excel, PowerPoint

• Sida loogu daro Multiple Formating qoraalkaaga hal unug oo Excel ah

• Sida qoraalka loogu qaybiyo tiirarka ku jira Excel iyo Google Sheets

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo Rept Function gudaha Excel