Chii chinonzi CSV faira?Excel neGoogle Sheets ndidzo dzakanakisa sarudzo dzekuvhura nekugadzirisa mafaera eCSV
Ichi chinyorwa chinotsanangura kuti CSV faira chii, nzira yekuivhura kana kuishandura, uye kuti ungaishandura sei kune imwe fomati.
Chii chinonzi CSV faira?
A CSV faira icomma yakakamurwa tsika faira. zviri a plain text file Inogona kunge iine nhamba chete uye mavara, uye inovaka iyo data mukati mayo kuita tabular kana tafura fomu.
Mafaira anopera basa anoshandiswa faira rekuwedzera CSV kazhinji ndeyekuchinjana data, kazhinji kana paine yakawanda, pakati pemaapplication akasiyana. Zvirongwa zveDatabhesi, analytics software, uye mamwe maapplication anochengeta huwandu hukuru hweruzivo (sevanobatika uye data revatengi) anowanzo tsigira iyi fomati.
Iyo comma yakapatsanurwa faira faira dzimwe nguva inogona kunzi comma yakapatsanurwa tsika faira monogrammed kana comma delimited file ، Asi zvisinei nekuti mumwe munhu azvitaura sei, ivo vari kutaura nezvemhando imwechete.
CSV zvakare chidimbu Kusimbisa software yekombuta, mutsara wakapatsanurwa nemakoma ، Uye akavhota kushandura denderedzwa ، uye kukosha kwakaparadzaniswa nekoroni .
Maitiro ekuvhura csv faira
Spreadsheet software inoshandiswa Kazhinji kuvhura uye kugadzirisa CSV mafaera, akadai seExcel kana OpenOfficeCalc أو WPS Hofisi Spreadsheets Freebies. Zvishandiso zveSpreadsheet zvakanakira mafaera eCSV nekuti data riri mufaira rinopepetwa kana kushandurwa neimwe nzira.
Kuona uye/kana kugadzirisa CSV faira pamhepo, unogona kushandisa Google Mapepa . Kuti uite kudaro, shanyira iyo peji uye sarudza iyo folda icon yekutarisa komputa yako kana Google Drive yefaira.
Iwe unogona zvakare kushandisa chinyorwa chinyorwa, asi hombe mupepeti ichave yakaoma kwazvo kushanda nayo mumhando idzi dzezvirongwa. Kana iwe uchida kuita izvi, ona zvatinoda mune runyorwa Iwo akanakisa emahara mavara edhita .
Sezvambotaurwa pamusoro, Excel inotsigira CSV mafaera zvakare, asi chirongwa hachina mahara kushandisa. Nekudaro, ingangove ndiyo inonyanya kushandiswa software yekuona uye kugadzirisa CSV mafaera.
Tichifunga nezvehuwandu hwezvirongwa kunze uko zvinotsigira zvakarongeka, zvinyorwa-zvakavakirwa data seCSV, unogona kunge uine zvinopfuura chirongwa chimwe chakaiswa chinogona kuvhura aya marudzi emafaira. Kana zvirizvo, iyo faira inovhura nekusarudzika paunodzvanya-kaviri kana kudzvanya kaviri CSV mafaera muWindows harisi iro faira raunoda kushandisa navo, ipapo. Kuchinja chirongwa ichi muWindows kuri nyore kwazvo .
Imwe nzira yeku "kuvhura" iyo CSV faira ndeye import it . Iwe waizoita izvi kana iwe uchida kushandisa iyo data kubva mufaira mune application isina kunyatsogadzirirwa kugadzirisa, asi yekuona / kushandisa zvirimo.
Ruzivo rwekusangana ndiyo muenzaniso wakajeka; unogona Tumira mazita muakaundi yako yeGoogle , semuenzaniso, kuwiriranisa zvinyorwa zvematanho kubva kufaira reCSV neGmail. Muchokwadi, akawanda eemail vatengi vanotsigira kutumira kunze uye kutumira ruzivo rwekufonera kuburikidza neCSV fomati, kusanganisira Outlook, Yahoo, uye Windows Mail.
Maitiro ekushandura csv faira
Nekuti mafaera eCSV anochengeta ruzivo mune zvinyorwa-chete fomu, rutsigiro rwekuchengetedza faira mune imwe fomati inosanganisirwa mune akawanda akasiyana masevhisi epamhepo uye software inodhawunirodha.
Zvese zviri pamusoro apa desktop zvirongwa zvinogona kushandura CSV faira kuita Excel mafomati akadai XLSX و xls , pamwe neTXT uye XML Uye SQL uye HTML uye ODS nevamwe. Iyi nzira yekushandura inowanzoitwa kuburikidza nemenyu faira > Save as .
Iwe unogona zvakare kushandisa Google Sheets. kubva pamazita faira > Download , sarudza XLSX, ODS, kana PDF kana chero imwe fomati inotsigirwa.
Kunewo zvimwe Free file converters iyo inomhanya muwebhu browser yako, semuenzaniso Zamzar Semuenzaniso, iyo inogona kushandura CSV mafaera kune mamwe epamusoro mafomati pamwe nePDF uye RTF .
tool based csvjson (Fungidzira...) Inoshandura CSV data kuita JSON, iyo inobatsira zvikuru kana iwe uchiunza huwandu hukuru hweruzivo kubva kune yechinyakare application kuita yewebhu-based project.
Iwe kazhinji haugone kushandura yekuwedzera faira (yakadai seCSV) kune iyo iyo komputa yako inozoziva uye kutarisira iyo ichangobva kupihwa zita faira kuti ishandiswe. Iyo chaiyo faira fomati shanduko inofanirwa kuitwa uchishandisa imwe yenzira dzinotsanangurwa pamusoro apa kazhinji. Nekudaro, sezvo mafaera aya achingove nemavara chete, unogona kupa zita rekuti chero CSV faira kune chero mamwe mavara mafomati uye inofanira kuvhurwa, zvisinei nenzira isinga batsire pane kana iwe wakaisiya muCSV.
Uchiri kusakwanisa kuivhura?
CSV mafaera ari nyore nyore. Kunyangwe zviri pachena pekutanga kuona, kupotsa kushoma kwecomma, kana nyonganiso seyakurukurwa pazasi, inogona kuita kuti vanzwe senge sainzi yeroketi.
Ramba uchifunga kuti haugone kuvhura faira kana kuverenga zvinyorwa mukati maro, nechikonzero chiri nyore kuti uri kuvhiringa imwe faira ine CSV faira. Mamwe mafaera anogovana mamwe emamwe faira ekuwedzera mavara asi asiri iwo akafanana, kana kunyange kure akafanana, fomati.
CVS uye CVX و CV Ingori mienzaniso mishoma iyo mafaera anogona kusakwanisa kuvhurwa muchirongwa chespredishiti kunyangwe iyo suffix ichitaridzika zvakanyanya seCSV. Kana zviri izvo nefaira rako, tsvaga iyo chaiyo faira yekuwedzera paGoogle, kana pano paLifewire, kuti uone kuti ndeapi anovhura kana adapter anowirirana.
Ruzivo rwakakosha nezvekugadzirisa CSV mafaera
Iwe ungangosangana ne CSV faira chete kana iwe uchitumira kunze ruzivo kubva kuchirongwa kuenda kune faira, uye wozoshandisa iyo yakafanana faira kuendesa iyo data muchirongwa. Different , kunyanya kana uchibata nemaapplication akatarisana netafura.
Nekudaro, iwe dzimwe nguva unogona kuzviwana uchigadzirisa CSV faira, kana kugadzira imwe kubva kutanga, mune iyo kesi iwe unofanirwa kufunga zvinotevera:
Chirongwa chakakurumbira chinoshandiswa kuvhura nekugadzirisa mafaira eCSV iExcel. Chinhu chakakosha kunzwisisa nezve kushandisa Excel, kana chero imwe yakafanana spredishiti chirongwa, ndechekuti kunyangwe zvirongwa izvi tarisa Ivo vanopa rutsigiro rwemapepa akawanda kana uchigadzirisa CSV faira, iyo CSV fomati haitsigire "mashiti" kana "matabhu," saka data raunogadzira munzvimbo idzi dzekuwedzera harizonyorwa kufaira reCSV paunenge uchichengeta.
Semuenzaniso, ngatiti iwe unogadzirisa iyo data mupepa rekutanga regwaro uye wozochengeta faira muCSV - iyo data iri mupepa rekutanga ndiyo inochengetwa. Zvisinei, kana ndikashandura kune rimwe pepa uye kuwedzera data uko , uye wozochengeta faira zvakare, ruzivo rwuri mubepa rekupedzisira rakagadziridzwa rwunozochengetwa. Iyo data iri mushizha rekutanga haigone kuwanikwa mushure mekudzima chirongwa chespredishiti.
Ndiwo hunhu hwespredishiti software inoita kuti chiitiko ichi chivhiringike. Maturusi mazhinji emaspredishiti anotsigira zvinhu zvakaita semachati, mafomula, marongerwo emitsara, mifananidzo, nezvimwe zvinhu zvisingangogone kuchengetwa mu CSV fomati.
Hapana dambudziko, chero bedzi iwe uchinzwisisa ichi chinogumira. Ichi ndicho chikonzero kune mamwe, mamwe mafomati espredishiti epamberi, akadai seXLSX. Mune mamwe mazwi, kana iwe uchida kuchengetedza chero basa rinopfuura rekutanga data shanduko kune CSV faira, usashandise CSV zvakare-ichengetedze kana kuitumira kune imwe yepamusoro fomati pane.
Mafaira eCSV anorongwa sei
Zviri nyore kugadzira yako CSV faira. Ingo rongedza data rako nenzira yaunoda mune imwe yezvishandiso zviri pamusoro, wobva wachengeta zvaunazvo mu CSV fomati.
Iwe unogona zvakare kugadzira imwe nemaoko, hongu - kubva pakutanga, uchishandisa chero chinyorwa chinyorwa.
Heino muenzaniso mumwe:
Name,Address,NumberJohn Doe,10th Street,555
Mafaira ese eCSV anotevera mafomati akafanana: koramu yega yega inopatsanurwa nedelimiter (senge comma), uye mutsara mutsva wega wega unoreva mutsara mutsva. Zvimwe zvirongwa zvinotumira data kune CSV faira zvinogona kushandisa chimiro chakasiyana kuparadzanisa maitiro, setabhu, semicolon, kana nzvimbo.
Zvaunoona mumuenzaniso uri pamusoro ndezvokuti iyo data ichaonekwa sei kana iyo CSV faira yakavhurwa mune yemavara edhita. Nekudaro, sezvo zvirongwa zvespredishiti zvakaita seExcel neOpenOffice Calc zvinogona kuvhura mafaera eCSV, uye zvirongwa izvi zvine maseru ekuratidza ruzivo, kukosha kuchaiswa. Zita muchitokisi chekutanga ne John Doe Mumutsara mutsva pazasi payo, mamwe anotevera maitiro akafanana.
Kana iwe uchisanganisira koma kana kushandisa makotesheni mufaira rako reCSV, verenga zvinyorwa zvedu zveCSV edoceo و csvReader.com kuti udzidze kuzviita.
