Ngenisa zviri mukati mefaira reCSV muExcel. Maitiro ekuvhura CSV faira muExcel

CSV izita rechimiro chegwaro remavara rinoshandiswa kuratidza tabular data. Mafaira ane chiwedzerwa ichi anoshandiswa kuchinjana mamwe mashoko pakati pezvirongwa zvekombuta. Kuti uone kana kugadzirisa CSV faira, hazvisi zvese zvinoshandiswa zvakakodzera. Iyo yakajairika kudzvanya kaviri kazhinji inotungamira kune isiriyo kuratidzwa kwedata. Kuti uwane data chaiyo uye kugona kuita shanduko, unogona kushandisa Excel.

Nzira dzekuvhura CSV mafaera muExcel

Usati waedza kuvhura magwaro nekuwedzera kwakadaro, unofanirwa kunzwisisa kuti chii. Comma-Separated Values ​​​​(CSV) - kubva kuChirungu "comma-separated values". Gwaro pacharo rinoshandisa marudzi maviri evapatsanuri, zvichienderana neshanduro yemutauro wechirongwa:

1. Kumutauro - semicolon.
2. Kushanduro yeChirungu - comma.

Paunenge uchichengetedza CSV mafaera, imwe encoding inoshandiswa, nekuda kwekuti, panguva yekuvhura kwavo, panogona kunge paine matambudziko ane chekuita nekuratidzwa kusiri kweruzivo. Kuvhura gwaro ne Excel ine yakajairwa kudzvanya kaviri, ichasarudza inopokana encoding ye decryption. Kana isingaenderane neiyo yakavharidzira ruzivo mufaira, iyo data inozoratidzwa mumavara asingaverengeke. Rimwe dambudziko rinogona kuitika nderokukanganisa kusawirirana, semuenzaniso, kana iyo faira yakachengetwa mushanduro yeChirungu yechirongwa, asi yakavhurwa mukati, kana zvinopesana.

Kuti udzivise matambudziko aya, unofanirwa kuziva nzira yekuvhura mafaera eCSV nemaExcel. Pane nzira nhatu dzinoda kutariswa zvakadzama.

Kushandisa Text Wizard

Excel ine akawanda maturusi akabatanidzwa, imwe yacho iText Wizard. Inogona kushandiswa kuvhura CSV mafaera. Maitiro:

1. Unofanira kuvhura purogiramu. Ita basa rekugadzira pepa idzva.
2. Enda kune "Data" tab.
3. Dzvanya bhatani rekuti "Tora data rekunze". Pakati pezvisarudzo zviripo, sarudza "Kubva pane zvinyorwa".
4. Kuburikidza nehwindo rinovhura, unofanirwa kutsvaga faira inodiwa, tinya bhatani re "Import".
5. Hwindo idzva richavhura neiyo Text Wizard setting. Pane iyo data format editing tab, tarisa bhokisi riri pedyo ne "Delimited". Iwe unofanirwa kusarudza iyo fomati pachayo zvichienderana neiyo encoding yakashandiswa pakukodha gwaro. Mafomati anonyanya kufarirwa ndeye Unicode, Cyrillic.
6. Usati wadzvanya bhatani re "Next", pazasi peji, unogona kuita preview kuti uone kuti nenzira kwayo fomati yakasarudzwa sei, kuti data inoratidzwa sei.
7. Mushure mekutarisa nekudzvanya bhatani re "Next", peji rinovhurika raunoda kuseta rudzi rwekuparadzanisa (commas kana semicolons). Dzvanya bhatani re "Next" zvakare.
8. Muhwindo rinoonekwa, unofanirwa kusarudza nzira yekutumira ruzivo, tinya "OK".

Zvinokosha! Iyi nzira yekuvhura CSV faira inobvumidza iwe kuchengetedza hupamhi hwemakoramu ega, zvichienderana neruzivo rwavanozadzwa narwo.

Nekudzvanya kaviri kana kusarudza application kubva pakombuta

Nzira dziri nyore dzekuvhura CSV mafaera. Izvo zvakakodzera kushandiswa chete kana zviito zvese negwaro (kusika, kuchengetedza, kuvhura) zvichiitwa neshanduro imwechete yechirongwa. Kana Excel yakatanga kuiswa sechirongwa chinovhura mafaera ese efomati iyi, ingodzvanya kaviri pagwaro. Kana iyo purogiramu isina kupihwa nekukasira, unofanirwa kuita akati wandei zviito:

1. Tinya-kurudyi pane gwaro uye sarudza "Vhura Na" kubva pane menyu inooneka.
2. Iyo yakajairwa sarudzo icharatidzwa. Kana pasina chakakodzera chekushandisa, uchafanirwa kuwana Excel mu "Sarudza imwe application" tab.

Kunyatsoratidza data kunogoneka chete nereshiyo ye encodings, shanduro dzepurogiramu.

Kwete nguva dzose kuwanikwa Excel mu "Sarudza imwe application" tab. Muchiitiko ichi, unofanirwa kudzvanya pakanzi "Tsvaga imwe application pane iyi komputa". Mushure meizvozvo, iwe unofanirwa kutsvaga chirongwa chinodiwa nenzvimbo yayo, tinya bhatani "OK".

Faira menyu

Imwe nzira inoshanda yekuvhura CSV mafaera. Maitiro:

1. Vhura Excel.
2. Dzvanya bhatani rekuti "Vhura".
3. Shandisa muongorori kuburikidza ne "Browse" basa.
4. Sarudza "Mafaira ese" fomati.
5. Dzvanya bhatani rekuti "Vhura".

Pakarepo mushure meizvozvo, iyo "Text Import Wizard" ichavhura. Inofanira kugadzirwa sezvakatsanangurwa kare.

mhedziso

Hazvina mhosva kuti mafomati emafaira eCSV akaoma sei, ane encoding chaiyo uye purogiramu yepurogiramu, anogona kuvhurwa neExcel. Kana, mushure mekuvhura nekudzvanya kaviri, hwindo rinoonekwa rine akawanda mavara asingaverengeki, zvinokurudzirwa kushandisa iyo Text Wizard.