Zofewa

Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv?

Yesani Chida Chathu Chothetsa Mavuto





Adalemba paKusinthidwa komaliza: February 17, 2021

Kodi fayilo ya CSV ndi chiyani komanso momwe mungatsegule fayilo ya .csv? Makompyuta, mafoni, ndi zina zambiri ndi zabwino posungira mitundu yosiyanasiyana ya mafayilo omwe ali m'mawonekedwe osiyanasiyana malinga ndi ntchito yawo.Mwachitsanzo: Mafayilo omwe mungasinthire nawo ali mumtundu wa .docx, mafayilo omwe mungawerenge komanso osaloledwa kusintha ali mu .pdf format, ngati muli ndi deta ya tabular, mafayilo oterowo ali mu .csv mtundu, ngati muli ndi wothinikizidwa wapamwamba adzakhala mu mtundu .zip, etc. Onsewa akamagwiritsa osiyana owona kutsegula mu njira zosiyanasiyana.M'nkhaniyi, mudziwa kuti fayilo ya CSV ndi chiyani komanso momwe mungatsegule fayilo yomwe ili mumtundu wa .csv.



Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv

Zamkatimu[ kubisa ]



Fayilo ya CSV ndi chiyani?

CSV imayimira Makhalidwe Osiyanitsidwa ndi Koma. Mafayilo a CSV ndi mafayilo osavuta olekanitsidwa ndi koma ndipo amakhala ndi manambala ndi zilembo zokha. Deta yonse yomwe ili mkati mwa fayilo ya CSV ilipo mu tabular kapena mawonekedwe a tebulo. Mzere uliwonse wa fayilo umatchedwa rekodi ya data. Rekodi iliyonse ili ndi gawo limodzi kapena angapo omwe ali osavuta kumva komanso olekanitsidwa ndi koma.

CSV ndi mtundu wamba wosinthira deta womwe umagwiritsidwa ntchito kusinthanitsa deta nthawi zambiri pakakhala kuchuluka kwa data. Pafupifupi ma database onse ndi ogula, bizinesi ndi ntchito zasayansi zomwe zimasunga zambiri zimathandizira mtundu wa CSV. Kugwiritsiridwa ntchito kwake bwino pakati pa ntchito zonse ndikusuntha deta pakati pa mapulogalamu mu mawonekedwe a tabular. Mwachitsanzo: Ngati wogwiritsa ntchito akufuna kuchotsa deta kuchokera ku database yomwe ili mumtundu wa eni ake ndipo akufuna kuitumiza ku pulogalamu ina yomwe ingavomereze spreadsheet yomwe imagwiritsa ntchito mawonekedwe osiyana kwambiri, ndiye kuti malo osungirako zinthu amatha kutumiza deta yake mumtundu wa CSV womwe zitha kutumizidwa kunja mosavuta ndi spreadsheet ndipo zitha kugwiritsidwa ntchito mu pulogalamu kulikonse komwe mungafune.



Mafayilo awa nthawi zina amatha kuyimba Makhalidwe Osiyanitsidwa ndi Makhalidwe kapena Mafayilo Otsitsidwa ndi Koma koma chimene aitanidwa, alimo nthawi zonse Mtundu wa CSV . Nthawi zambiri amagwiritsa ntchito koma kuti alekanitse mfundozo, koma nthawi zina amagwiritsanso ntchito zilembo zina monga semicolons kuti alekanitse mfundozo. Lingaliro kumbuyo ndikuti mutha kutumiza zovuta kuchokera ku fayilo imodzi yofunsira kupita ku fayilo ya CSV ndiyeno mutha kuyitanitsa fayilo ya CSV mu pulogalamu ina komwe mukufuna zovutazo.Pansipa pali chitsanzo cha fayilo ya CSV yomwe imatsegulidwa pogwiritsa ntchito Notepad.

Chitsanzo cha fayilo ya CSV itatsegulidwa mu Notepad



Fayilo ya CSV yomwe ili pamwambapa ndi yosavuta komanso imakhala ndi mtengo wocheperako. Zitha kukhala zovuta kwambiri kuposa izi ndipo zimatha kukhala ndi mizere masauzande.

Fayilo ya CSV imatha kutsegulidwa mu pulogalamu iliyonse koma kuti mumvetsetse bwino komanso kwa ogwiritsa ntchito ambiri, fayilo ya CSV imawoneka bwino kudzera mu pulogalamu yamasamba monga Microsoft Excel, OpenOffice Calc, ndi Google Docs.

Momwe mungatsegule fayilo ya CSV?

Fayilo ya CSV imatha kuwonedwa kudzera mu Notepad monga mwawonera pamwambapa. Koma mu notepad, zikhalidwe zimasiyanitsidwa ndi ma comma omwe ndi ovuta kuwerenga. Kotero, pali njira ina yotsegula fayilo ya .csv pogwiritsa ntchito pulogalamu ya spreadsheet yomwe idzatsegule fayilo ya CSV mu mawonekedwe a tabular ndi kumene mungathe kuwawerenga mosavuta. Pali mapulogalamu atatu a spreadsheet omwe mungagwiritse ntchito kutsegula fayilo ya .csv. Izi ndi:

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

Njira 1: Tsegulani fayilo ya CSV pogwiritsa ntchito Microsoft Excel

Ngati muli ndi Microsoft Excel yoyika pa kompyuta yanu, ndiye kuti mwachisawawa fayilo iliyonse ya CSV imatsegulidwa mu Microsoft Excel mukadina kawiri.

Kuti mutsegule fayilo ya CSV pogwiritsa ntchito Microsoft Excel tsatirani izi:

1. Dinani pomwepo pa Fayilo ya CSV mukufuna kutsegula.

Dinani kumanja pa fayilo ya CSV yomwe mukufuna kutsegula

2.Sankhani Tsegulani ndi kuchokera pa menyu kapamwamba kuwonekera.

Dinani Open ndi kuchokera kumanja-kumanja kwa menyu

3.Kuchokera pa Open with context menu, sankhani Microsoft Excel ndipo alemba pa izo.

Pansi Open with, sankhani Microsoft Excel ndikudina pa izo

Zinayi. Fayilo yanu ya CSV idzatsegulidwa mu mawonekedwe a tabular zomwe ndi zosavuta kuwerenga.

Fayilo ya CSV idzatsegulidwa mu mawonekedwe a tabular | Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv?

Pali njira ina yotsegulira fayilo ya .csv pogwiritsa ntchito Microsoft Excel:

1.Otsegula Microsoft Excel pofufuza pogwiritsa ntchito Windows Search bar.

Tsegulani Microsoft Excel pogwiritsa ntchito bar yofufuzira

2. Dinani pa Microsoft Excel zotsatira zosaka ndipo zidzatsegula.

Kuchokera pazotsatira zosaka dinani Microsoft Excel kuti mutsegule

3.Dinani Fayilo njira likupezeka pamwamba kumanzere ngodya.

Dinani pa Fayilo njira yomwe ikupezeka pamwamba kumanzere

4.Dinani Tsegulani kupezeka pamwamba gulu.

Dinani pa batani lotseguka lomwe likupezeka pagulu lapamwamba

5. Yendetsani ku chikwatu yomwe ili ndi fayilo yomwe mukufuna kutsegula.

Sakatulani chikwatu chomwe chili ndi fayilo

6.Kamodzi mufoda yomwe mukufuna, sankhani fayilo podina.

Mukafika pafayiloyo, sankhani ndikudina

7. Kenako, alemba pa Tsegulani batani.

Dinani pa Open batani

8.Fayilo yanu ya CSV idzatsegulidwa mu tabular ndi mawonekedwe owerengeka.

Fayilo ya CSV idzatsegulidwa mu mawonekedwe a tabular | Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv?

Chifukwa chake, pogwiritsa ntchito njira iliyonse yomwe ili pamwambapa, mutha kutsegula fayilo ya CSV pogwiritsa ntchito Microsoft Excel.

Njira 2: Momwe mungatsegule fayilo ya CSV pogwiritsa ntchito OpenOffice Calc

Ngati muli ndi OpenOffice pa kompyuta yanu, mukhoza kutsegula mafayilo a .csv pogwiritsa ntchito OpenOffice Calc. Ngati palibe gwero lina limene laikidwa pa kompyuta yanu ndiye kuti fayilo yanu ya .csv idzatseguke mu OpenOffice.

1. Dinani pomwepo pa .csv wapamwamba mukufuna kutsegula.

Dinani kumanja pa fayilo ya CSV yomwe mukufuna kutsegula

2.Sankhani Tsegulani ndi kuchokera kudina kumanja kwa menyu.

Dinani Open ndi kuchokera pa menyu kapamwamba kuwonekera

3.Under Open ndi, sankhani OpenOffice Calc ndipo alemba pa izo.

Pansi Tsegulani ndi, sankhani Open Office Calc ndikudina

Zinayi. Fayilo yanu ya CSV itsegulidwa.

Fayilo yanu ya CSV idzatsegulidwa | Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv?

5.Pali njira zambiri zomwe mungagwiritse ntchito zomwe mungasinthe momwe mukufuna kuwona mafayilo a .csv mwachitsanzo monga kugwiritsa ntchito koma, malo, tabu, ndi zina.

Njira 3: Momwe Mungatsegule fayilo ya CSV pogwiritsa ntchito Google Docs

Ngati mulibe pulogalamu yoyika pa kompyuta yanu kuti mutsegule mafayilo a .csv, mutha kugwiritsa ntchito Google Docs pa intaneti kuti mutsegule mafayilo a csv.

1.Tsegulani Google Drive pogwiritsa ntchito ulalo uwu: www.google.com/drive

Tsegulani Google Drive pogwiritsa ntchito ulalo

2.Dinani Pitani ku Google Drive.

3.Mudzatumizidwa kutsamba lolowera. Lowetsani yanu Adilesi ya imelo ya Gmail ndi mawu achinsinsi.

Zindikirani: Ngati akaunti yanu ya Gmail idalowetsedwa kale ndiye kuti simudzatumizidwa patsamba lolowera.

4.After adalowa mu, inu adzatumizidwa kwa tsamba langa loyendetsa.

Mukalowa, mudzatumizidwa ku tsamba langa lagalimoto

5.Dinani Drive wanga.

Dinani pa Drive yanga

6.A menyu dropdown adzaoneka. Dinani pa Kwezani mafayilo kuchokera ku menyu yotsitsa.

Dinani pa Kwezani mafayilo kuchokera pamenyu yotsitsa

7. Yendetsani ku chikwatu yomwe ili ndi fayilo yanu ya CSV.

Sakatulani chikwatu chomwe chili ndi fayilo yanu ya CSV

8.Kamodzi mkati mwa chikwatu chomwe mukufuna, sankhani fayilo ya .csv ndi kumadula pa Tsegulani batani.

Sankhani wapamwamba ndikudina pa Open batani

9.Fayilo yanu ikatsitsidwa pa Drive, mudzawona bokosi lotsimikizira lidzawonekera pakona yakumanzere yakumanzere.

Bokosi lotsimikizira lidzawonekera pakona yakumanzere

10. Mukamaliza kukweza, dinani kawiri pa fayilo ya .csv mwangotsitsa kuti mutsegule.

Dinani kawiri pa fayilo ya CSV yomwe mwakweza kumene kuti mutsegule | Kodi mungatsegule bwanji fayilo ya .csv?

11. Kuchokera ku Tsegulani ndi menyu yotsitsa, sankhani Google Mapepala.

Kuchokera pamwamba Tsegulani ndi menyu yotsitsa, sankhani Mapepala a Google

12. Fayilo yanu ya CSV idzatsegulidwa mu mawonekedwe a tabular kuchokera komwe mungawerenge mosavuta komanso momveka bwino.

Fayilo ya CSV idzatsegulidwa mu mawonekedwe a tabular | Kodi fayilo ya CSV ndi chiyani & Momwe mungatsegule fayilo ya .csv?

Alangizidwa:

Ndikukhulupirira kuti nkhaniyi inali yothandiza ndipo mukhoza tsopano mosavuta Tsegulani fayilo iliyonse ya .csv pogwiritsa ntchito njira iliyonse yomwe ili pamwambayi, koma ngati mukadali ndi mafunso okhudzana ndi phunziroli khalani omasuka kuwafunsa mu gawo la ndemanga.

Aditya Farrad

Aditya ndi katswiri waukadaulo wodzilimbikitsa yekha ndipo wakhala akulemba zaukadaulo kwa zaka 7 zapitazi. Amagwira ntchito pa intaneti, mafoni, Windows, mapulogalamu, ndi maupangiri amomwe mungachitire.