Waa maxay faylka CSV iyo sida loo furo faylka .csv? ^{(What is a CSV file and how to open .csv file? )}Kumbuyuutarrada, telefoonnada, iwm ayaa aad ugu fiican kaydinta noocyada kala duwan ee faylalka kuwaas oo u qaabaysan qaabab kala duwan sida loo isticmaalo. Tusaale ahaan: Faylasha aad wax ka bedeli karto waxay u samaysan yihiin qaabka .docx , faylasha aad akhrin karto oo kaliya oo aan loo ogolayn inaad wax ka beddesho waxay ku qoran yihiin qaabka .pdf , haddii aad haysatid xog tabular ah, faylasha noocaas ah waxay ku jiraan .csv . qaab, haddii aad haysatid wax fayl ah oo la tuujiyay waxa uu ahaan doonaa qaab .zip ah, iwm. Dhammaan noocyadan qaabab kala duwan waxay u furmaan siyaabo kala duwan. Maqaalkan, waxaad ku baran doontaa waxa uu yahay faylka CSV iyo sida loo furo faylka kaas oo ah qaabka .csv .

Waa maxay faylka CSV?^{(What is a CSV file?)}

CSV waxay u taagan tahay Comma Separated Values . Faylasha CSV^(CSV) waa faylal qoraal ah oo cad oo ay kala soocaan joodar waxayna ka kooban yihiin lambaro iyo xarfo keliya. Dhammaan xogta ku jirta gudaha faylka CSV waxay ku jirtaa shaxda ama qaabka miiska. Xariiq kasta oo faylka ah waxaa loo yaqaannaa diiwaanka xogta. Diiwaan kastaa waxa uu ka kooban yahay hal ama in ka badan oo qoraal ah oo ay kala soocaan hakadyo.

CSV waa qaab xog isweydaarsi caadi ah oo loo isticmaalo in lagu kala beddelo xogta inta badan marka ay jirto xog badan. Ku dhawaad^(Almost) ​​​​dhammaan xog-ururinta iyo macaamilka, ganacsiga iyo codsiyada sayniska ee kaydiya tiro badan oo macluumaad ah waxay taageeraan qaabkan CSV . Isticmaalkeeda ugu wanaagsan ee dhammaan adeegsiyada ka mid ah waa u wareejinta xogta u dhaxaysa barnaamijyada qaab shaxan ah. Tusaale ahaan: Haddii qof kasta oo isticmaala uu rabo inuu ka soo saaro xogta qaar ka mid ah database-ka kaas oo ah qaab gaar ah oo uu rabo inuu u diro barnaamij kale kaas oo aqbali kara xaashida oo isticmaalaya qaab gebi ahaanba ka duwan, markaa database-ku wuxuu u dhoofin karaa xogtiisa qaab CSV si fudud ayaa lagu soo dejin karaa xaashida faafinta waxaana lagu isticmaali karaa barnaamijka meel kasta oo aad rabto.

Faylashani waxay mararka qaarkood u yeedhaan faylal kala duwanaansho ah ama Comma Delimited files^{(Character Separated Values or Comma Delimited files)} laakiin wax kasta oo la yiraahdo, had iyo jeer waxay ku qoran yihiin qaabka CSV^{( CSV format)} . Inta badan waxay isticmaalaan comma si ay u kala soocaan qiyamka midba midka kale, laakiin mararka qaarkood waxay sidoo kale isticmaalaan jilayaal kale sida semicolons si ay u kala soocaan qiyamka. Fikradda ka dambeysa taas ayaa ah waxaad ka dhoofin kartaa xogta adag hal fayl codsi ah faylka CSV ka dibna waxaad ku soo dejisan kartaa faylka CSV codsi kale halkaasoo aad uga baahan tahay xogtaas adag. Hoos^(Below) waxaa ku yaal tusaale faylka CSV kaas oo la furay iyadoo la isticmaalayo Notepad .

Faylka Tafatiraha CSV^{(CSV Editor)} ee kore ee muuqda waa mid aad u fudud oo ka kooban qiimo aad u yar. Way ka dhib badnaan karaan taas waxayna ka koobnaan karaan kumanyaal xariiq.  

Faylka CSV waxaa lagu furi karaa barnaamij kasta laakiin si loo fahmo si fiican iyo inta badan isticmaalayaasha, faylka CSV waxaa sida ugu wanaagsan loo eegaa barnaamijka xisaabaadka sida Microsoft Excel, OpenOffice Calc,  iyo Google Docs.

Sida loo furo faylka CSV?^{(How to open a CSV file?)}

Faylka CSV^(CSV) waxa laga eegi karaa Notepad sida aad kor ku aragtay. Laakin qoraalka qoraalka, qiyamka waxaa lagu kala saaraa hakadyo taasoo aad u adag in la akhriyo. Haddaba, waxaa jirta hab kale oo lagu furto faylka .csv iyadoo la isticmaalayo barnaamij xisaabeed kaasoo furi doona faylka CSV qaab tabular ah oo aad si fudud ugu akhrin karto. Waxaa jira saddex barnaamij oo xaashida faafinta ah oo aad ku furi karto faylka .csv. Kuwani waa:

1. Microsoft Excel
2. OpenOffice Calc
3. Google Docs

Habka 1: Fur faylka CSV adoo isticmaalaya Microsoft Excel^{(Method 1: Open a CSV file using Microsoft Excel)}

Haddii aad ku rakiban tahay Microsoft Excel kombiyuutarkaaga, markaa sida caadiga ah fayl kasta oo CSV ah ayaa furmi doona Microsoft Excel marka aad laba jeer gujiso.

Si aad u furto faylka CSV adoo isticmaalaya ^(CSV)Microsoft Excel raac tillaabooyinka hoose:

1.Right-guji faylka CSV ee^{(CSV file)} aad rabto inaad furto.

2. Dooro Fur oo^{(Open with)} ka soo muuqda bar menu-ka.

3. Laga bilaabo " Open with" macnaha guud, dooro Microsoft Excel oo guji.

4. Faylkaaga CSV wuxuu ku furmayaa qaab tabular ah^{(Your CSV file will open up in a tabular form)} oo aad u sahlan in la akhriyo.

Waxaa jira hab kale oo lagu furo faylka .csv iyadoo la isticmaalayo Microsoft Excel :

1.Fur Microsoft Excel adiga oo ka raadinaaya Windows Search bar.

2. Guji natiijada raadinta Microsoft Excel wayna furmi doontaa.

3.guji ikhtiyaarka faylka^(File) ee laga heli karo geeska bidix ee sare.

4. Guji Open oo laga heli karo guddiga sare.

5. U gudub faylka^{(Navigate to the folder)} uu ku jiro faylka aad rabto inaad furto.

6.Marka aad gasho gal-ga aad rabto, dooro faylka adiga oo gujinaya.^{(select the file by clicking on it.)}

7.Marka xigta, dhagsii badhanka Furan.^{(Open button.)}

8.Faylkaaga CSV wuxuu ku furmayaa shaxda iyo foomka la akhriyi karo.

Marka, adoo isticmaalaya mid ka mid ah hababka kor ku xusan, waxaad furi kartaa faylka CSV adoo isticmaalaya ^(CSV)Microsoft Excel .

Habka 2: Sida loo furo faylka CSV iyadoo la isticmaalayo OpenOffice Calc ^{(Method 2: How to open a CSV file using OpenOffice Calc )}

Haddii aad ku rakiban tahay OpenOffice kombiyuutarkaaga, markaa waxaad furi kartaa faylasha .csv adoo isticmaalaya OpenOffice Calc . Haddii il kale lagu rakibin kombuyutarkaaga markaa faylkaaga csv waa inuu si toos ah u furmo OpenOffice .

1.Right-guji faylka .csv ee^{(.csv file)} aad rabto inaad furto.

2. Ka dooro " Fur with^{(Open with)} " ka midig-guji macnaha macnaha guud.

3. Under Open with, door OpenOffice Calc oo guji.

4. Faylkaaga CSV hadda wuu furmi doonaa.^{(Your CSV file will now open.)}

5.Waxaa jira xulashooyin badan oo isticmaalaya kuwaas oo aad ku bedeli karto sida aad rabto inaad u aragto macluumaadka faylka .csv tusaale ahaan isticmaalka comma, space, tab, iwm.

Habka 3: Sida loo furo faylka CSV adoo isticmaalaya Google Docs^{(Method 3: How to Open the CSV file using Google Docs)}

Haddii aadan haysan wax software ah oo lagu rakibay kombiyuutarkaaga si aad u furto faylasha .csv, markaa waxaad isticmaali kartaa Google Docs online si aad u furto faylasha csv.

1. Fur Google Drive adiga oo isticmaalaya xidhiidhkan:  www.google.com/drive

2. Guji Go Google Drive.^{(Go to Google Drive.)}

3.Waxaa laguu wareejin doonaa bogga gelitaanka. Geli ciwaanka emailkaaga iyo eraygaaga sirta ah ee Gmail^{(Gmail email address and password.)}

Fiiro gaar ah:^(Note:) Haddii akoonkaaga Gmail -ka uu horay u soo galay markaa looma wareejin doono bogga gelitaanka.

4.Marka aad gasho, waxaa laguu wareejin doonaa boggayga -drive.^{( my-drive page.)}

5. Guji My Drive.

6. menu hoos u dhac ayaa soo bixi doona. Guji^(Click) soo rar faylasha^{(Upload files)} ka menu-hoosaadka.

7. U gudub faylka^{(Navigate to the folder)} uu ka kooban yahay faylkaaga CSV.

8.Marka aad gasho galkaaga aad rabto, dooro faylka .csv^{( select the .csv file)} oo guji badhanka Furan^(Open) .

9.Once your file uploaded on the Drive ,  waxaad arki doontaa sanduuqa xaqiijinta ayaa ka soo muuqan^{(you will see a confirmation box will appear)} doona geeska bidix ee hoose.

10.Marka uploading-ku dhammaato, laba-guji faylka .csv ee^{( double-click on the .csv file)} aad hadda gelisay si aad u furto.

11. Laga bilaabo " Open with " dropdown menu, dooro Google Sheets.

12. Faylkaaga CSV wuxuu u furmi doonaa qaab tabular ah^{(Your CSV file will open up in tabular form)} oo aad si fudud oo cad ugu akhrin karto.

lagu taliyay:^{(Recommended:)}

• Can’t log in to Windows 10? Fix Windows Login Problems!
• Sida loo hubiyo qeexida PC-gaaga Windows 10^{(How to Check Your PC’s Specification on Windows 10)}
• Fix Startup Repair Infinite Loop on Windows 10/8/7
• Sida Looga Saxiixo Ama Looga Baxo Gmailka?^{(How to Sign Out or Log Out Of Gmail?)}

Waxaan rajeynayaa in maqaalkani uu waxtar lahaa oo aad hadda si fudud u furi karto  fayl kasta oo .csv ah adigoo isticmaalaya mid ka mid ah hababka kor ku xusan,^{( Open any .csv file using any one of the above methods,)}  laakiin haddii aad weli wax su'aalo ah ka qabto casharkan markaa xor u noqo inaad ku weydiiso qaybta faallooyinka.

What is a CSV file & How to open a .csv file?

What is a CSV file and how to open .csv file? Computers, phones, etc. are great for storing different types of files which are in different formats according to their use. For example: The files in which you can make changes are in .docx format, files which you can only read and not allowed to make any changes are in .pdf format, if you have any tabular data, such data files are in .csv format, if you have any compressed file it will be in .zip format, etc. All these different formats files open in different ways. In this article, you will get to know what is a CSV file and how to open a file which is in .csv format.

What is a CSV file?

CSV stands for Comma Separated Values. CSV files are plain text files separated by a comma and contain only numbers and letters. All the data present inside the CSV file is present in tabular or table form. Each line of the file is called a data record. Each record contains one or more fields which are plain text and separated by commas.

CSV is a common data exchange format that is used to exchange data usually when there is a large amount of data. Almost all the databases and consumer, business and scientific applications that store a large amount of information support this CSV format. Its best use among all the uses is moving data between programs in tabular form. For example: If any user wants to extract some data from database which is in proprietary format and want to send it to some other program which can accept a spreadsheet which uses a completely different format, then the database can export its data in CSV format which can be easily imported by the spreadsheet and can be used in the program wherever you want.

These files sometimes may call Character Separated Values or Comma Delimited files but whatever they are called, they are always in CSV format. They mostly use comma to separate values from each other, but sometimes also use other characters like semicolons to separate the values. The idea behind that is you can export complex data from one application file to CSV file and then you can import that CSV file in another application where you need that complex data. Below is given an example of a CSV file which is opened using Notepad.

The above shown CSV Editor file is very simple and contains very less value. They can be more complicated than that and can contain thousands of lines.  

A CSV file can be opened in any program but for better understanding and for most users, CSV file is best viewed through a spreadsheet program like Microsoft Excel, OpenOffice Calc, and Google Docs.

How to open a CSV file?

CSV file can be viewed through Notepad as you have seen above. But in notepad, the values are separated by commas which is very difficult to read. So, there is another way to open a .csv file using a spreadsheet program which will open the CSV file in tabular form and where you can easily read them. There are three spreadsheet programs using which you can open a .csv file. These are:

1. Microsoft Excel
2. OpenOffice Calc
3. Google Docs

Method 1: Open a CSV file using Microsoft Excel

If you have Microsoft Excel installed on your computer, then by default any CSV file will open in Microsoft Excel when you double-click on it.

To open CSV file using Microsoft Excel follow below steps:

1.Right-click on the CSV file you want to open.

2.Select Open with from the menu bar appear.

3.From the “Open with” context menu, choose Microsoft Excel and click on it.

4.Your CSV file will open up in a tabular form which is very easy to read.

There is another way to open a .csv file using Microsoft Excel:

1.Open Microsoft Excel by searching for it using the Windows Search bar.

2.Click on the Microsoft Excel search result and it will open up.

3.Click on File option available at the top left corner.

4.Click on Open available in the top panel.

5.Navigate to the folder which contains the file which you want to open.

6.Once in the desired folder, select the file by clicking on it.

7.Next, click on the Open button.

8.Your CSV file will open up in the tabular and readable form.

So, by using any of the above methods, you can open CSV file using Microsoft Excel.

Method 2: How to open a CSV file using OpenOffice Calc 

If you have OpenOffice installed on your computer, then you can open the .csv files using OpenOffice Calc. If no other source is installed on your computer then your .csv file should automatically open in OpenOffice.

1.Right-click on the .csv file you want to open.

2.Select “Open with” from the right-click context menu.

3.Under Open with, choose OpenOffice Calc and click on it.

4.Your CSV file will now open.

5.There are many options using which you can change how you want to view the .csv file content for example like using a comma, space, tab, etc.

Method 3: How to Open the CSV file using Google Docs

If you do not have any installed software on your computer to open the .csv files, then you can use online Google Docs to open the csv files.

1.Open Google Drive by using this link: www.google.com/drive

2.Click on Go to Google Drive.

3.You will be redirected to the login page. Enter your Gmail email address and password.

Note: If your Gmail account is already logged in then you will not redirected to the login page.

4.After logged in, you will be redirected to my-drive page.

5.Click on My Drive.

6.A dropdown menu will appear. Click on Upload files from dropdown menu.

7.Navigate to the folder which contains your CSV file.

8.Once inside your desired folder, select the .csv file and click on the Open button.

9.Once your file is uploaded on the Drive, you will see a confirmation box will appear on the lower left corner.

10.When the upload is completed, double-click on the .csv file you just uploaded to open it.

11.From the “Open with” dropdown menu, select Google Sheets.

12.Your CSV file will open up in tabular form from where you can read it easily and clearly.

Recommended:

• Can’t log in to Windows 10? Fix Windows Login Problems!
• How to Check Your PC’s Specification on Windows 10
• Fix Startup Repair Infinite Loop on Windows 10/8/7
• How to Sign Out or Log Out Of Gmail?

I hope this article was helpful and you can now easily Open any .csv file using any one of the above methods, but if you still have any questions regarding this tutorial then feel free to ask them in the comment’s section.

Related posts

• Sida Dropbox loogu daro Adeeg Cloud ahaan Microsoft Office

• 3 siyood oo erayga sirta ah loo ilaaliyo File Excel

• 3 siyaabood oo la isugu geeyo Faylasha Bandhigga PowerPoint ee badan

• Waa maxay qaar ka mid ah farta curisyada ugu fiican ee Microsoft Word?

• Sida loo Geliyo PDF Dukumeenti Word ah

• Sida loo dayactiro nooc kasta oo Microsoft Office ah

• Sida loo awoodo oo loo isticmaalo Panning Hand gudaha abka Microsoft Office

• Sida Loo Bilaabo Microsoft Word In Mode Safe

• U samee ama u abuur furaha-gaaban ee kiiboodhka ee Microsoft Office

• Sida Loo Sameeyo Margins 1 Inch gudaha Microsoft Word

• Microsoft Word wuu joojiyay Shaqadii [XALIYEY]

• Sida loo soo dejiyo noocyadii hore ee Microsoft Office

• Sida loo beddelo midabada mawduuca dukumeentiga ee barnaamijyada Microsoft Office

• 5 siyaabood oo loo Geli karo Calaamada Xididada Square ee Erayga

• 5 siyaabood oo looga saaro Hyperlinks Documents Microsoft Word

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Sida loo beddelo dejinta u gaarka ah Koontada gudaha Microsoft Office

• 4 Siyaabaha Loo Geliyo Calaamadda Degree ee Microsoft Word

• Soo deji Grammarly bilaash ah Firefox, Chrome, Microsoft Office

• Sida loo beddelo goobaha File Block ee barnaamijyada Microsoft Office