Ngenisa zviri mukati mefaira reCSV muExcel

CSV ndeye yakakurumbira faira yekuwedzera iyo inonyanya kushandiswa kuchinjanisa data pakati pezvirongwa zvekombuta zvakasiyana. Kazhinji kazhinji, hapana chikonzero chekuvhura uye kugadzirisa magwaro akadaro. Zvisinei, mune dzimwe nguva, vashandisi vanogona kutarisana nebasa rakadaro. Excel inokutendera kuti uite izvi, asi kusiyana nemafaira akajairwa mufomati xls и XLSX, kungovhura gwaro nekudzvanya kaviri mbeva hakuwanzopa mugumisiro wepamusoro-soro, izvo zvingaguma nekuratidzwa kusina kururama kwemashoko. Ngatione kuti ungavhura sei mafaira eCSV muExcel.

Kuvhura CSV mafaera

Kutanga, ngationei kuti ndeapi magwaro ari mufomati iyi.

CSV ichidimbu chinomirira "Comma-Separated Values" (in means "tsika dzakaparadzaniswa nemakoma").

Sezvinoratidzwa nezita, magwaro aya anoshandisa delimiters:

• koma - mushanduro dzeChirungu;
• semicolon – in versions of the program.

When opening a document in Excel, the main task (problem) is to choose the encoding method used when saving the file. If the wrong encoding is chosen, the user will most likely see a lot of unreadable characters, and the usefulness of the information will be minimized. In addition, the delimiter used is of key importance. For example, if a document was saved in the English version and then you try to open it in the version, the quality of the displayed information will most likely suffer. The reason, as we noted earlier, is that different versions use different delimiters. Let’s see how to avoid these problems and how to open CSV files correctly.

Method 1: Tinya kaviri kana kuburikidza nemenu yemukati

Tisati taenderera kune dzimwe nzira dzakaoma, ngatitarisei imwe yakapfava. Izvo zvinoshanda chete mumamiriro ezvinhu apo iyo faira yakagadzirwa / yakachengetedzwa uye yakavhurwa mune imwecheteyo vhezheni yechirongwa, izvo zvinoreva kuti hapafanirwe kuve nezvinetso ne encoding uye delimiters. Pane zvingasarudzwa zviviri, tichazvitsanangura pasi apa.

Excel inogadzwa sechirongwa chekuvhura CSV mafaera

Kana zvakadaro, unogona kuvhura gwaro senge chero rimwe faira - ingodzvanya kaviri pairi.

Chimwe chirongwa chinopihwa kuvhura CSV mafaera kana kusapihwa zvachose

Iyo algorithm yekuita mumamiriro ezvinhu akadaro ndeyotevera (uchishandisa Windows 10 semuenzaniso):

1. Isu tinya-kurudyi pane iyo faira uye mune yemukati menyu inovhura, tinomira pamurairo "Kuvhura nayo".
2. Mune yekubatsira menyu, iyo sisitimu inogona kupa ipapo iyo Excel chirongwa. Muchiitiko ichi, tinya pairi, semhedzisiro iyo faira ichavhura (sekunge nekudzvanya kaviri pairi). Kana chirongwa chatinoda chisiri muchirongwa, tinya pane icho chinhu "Sarudza imwe app".
3. Iwindo richaonekwa ratinogona kusarudza chirongwa (kuti uwedzere rondedzero yezvisarudzo zviripo, unofanirwa kudzvanya bhatani "Mamwe Mapurogiramu") yaunoda kuvhura nayo gwaro. Kutsvaga zvatinoda uye tinya OK. Kuita kuti Excel ive yakasarudzika application yerudzi urwu rwefaira, tanga watarisa bhokisi rakakodzera.
4. Mune zvimwe zviitiko, kana Excel isingawanikwe muhwindo iri, tinya bhatani "Tsvaga imwe app pakombuta iyi" pakupera kweiyo runyorwa.
5. Iwindo richaonekwa pachiratidziro chatinoenda kunzvimbo yechirongwa paPC, maka iyo faira inoteedzera nekuwedzera. ONA uye tinya bhatani "Vhura".

Zvisinei kuti ndeipi yenzira dzatsanangurwa pamusoro apa yakasarudzwa, mhedzisiro ichave yekuvhurwa kwefaira reCSV. Sezvatataura pamusoro, zvirimo zvicharatidzwa nenzira kwayo chete kana encoding uye vapatsanuri vachiwirirana.

Mune zvimwe zviitiko, zvinhu zvakadai zvinogona kuonekwa:

Nokudaro, nzira yakatsanangurwa haisi yakakodzera nguva dzose, uye tinopfuurira kune inotevera.

Method 2: Shandisa Text Wizard

Ngatishandisei chishandiso chakabatanidzwa muchirongwa - Text Master:

1. Mushure mekuvhura chirongwa uye kugadzira pepa nyowani, kuitira kuti uwane ese mabasa uye maturusi enzvimbo yekushanda, chinja kune tab. "Dhata"kwatinobaya bhatani "Kuwana data yekunze". Pakati pezvisarudzo zvinobuda, sarudza "Kubva mumashoko".
2. Hwindo rinozaruka ratinoda kufamba tichienda kunzvimbo yefaira yatinoda kuunza. Kana wazvimaka, tinya bhatani "Tumira".
3. The Text Master. Tarisa kana sarudzo yakasarudzwa "nevanoparadzanisa" kune parameter "Data format". Sarudzo yefomati inoenderana neiyo encoding yakashandiswa pakuichengeta. Pakati peanonyanya kufarirwa mafomati "Cyrillic (DOS)" и "Unicode (UTF-8)". Iwe unogona kunzwisisa kuti sarudzo yakanaka yakaitwa nekutarisa pane preview yezvinyorwa pazasi pehwindo. Inokodzera kwatiri "Unicode (UTF-8)". Iwo asara maparamita kazhinji haadi kugadziridzwa, saka tinya bhatani "Dalee".
4. The next step is to define the character that serves as the delimiter. Since our document was created / saved in the version of the program, we select "semicolon". Pano, senyaya yekusarudza encoding, isu tine mukana wekuyedza sarudzo dzakasiyana, kuongorora mhedzisiro munzvimbo yekutarisa (iwe unogona, pakati pezvimwe zvinhu, kutsanangura yako pachako hunhu nekusarudza iyo sarudzo. “Mumwe”) Mushure mekuisa zvigadziriso zvinodiwa, tinya bhatani zvakare. "Dalee".
5. Muhwindo rekupedzisira, kazhinji, haufanirwe kuita chero shanduko kune akajairwa marongero. Asi kana iwe uchida kushandura fomati yekoramu, tanga wadzvanya pairi pazasi pehwindo (munda "Muenzaniso"), wobva wasarudza sarudzo yakakodzera. Dzvanya kana wagadzirira “Gadzirira”.
6. Iwindo richaonekwa umo isu tinosarudza nzira yekupinza data (pane iripo kana pane pepa idzva) uye tinya OK.
   • mune yekutanga, iwe unofanirwa kutsanangura kero yesero (kana kusiya iyo yakasarudzika kukosha) inova iyo yepamusoro kuruboshwe chinhu chemukati memukati. Iwe unogona kuita izvi nemaoko nekupinda macoordinates uchishandisa iyo keyboard, kana nekungodzvanya pane yaunoda sero pane pepa (iyo cursor inofanira kunge iri mumunda wakakodzera wekuisa ruzivo).
   • paunosarudza sarudzo yekupinza pane pepa idzva, haufanire kutsanangura zvinorongeka.
7. Zvese zvakagadzirira, isu takakwanisa kupinza iyo data ye CSV faira. Kusiyana nenzira yekutanga, tinogona kuona kuti upamhi hwembiru hwakaremekedzwa, tichifunga nezvezviri mukati memasero.

Nzira 3: kuburikidza ne "Faira" menyu

Uye yekupedzisira nzira yaungashandisa ndeiyi inotevera:

1. Mushure mekutanga chirongwa, sarudza chinhu "Vhura".Kana purogiramu yakatovhurwa kare uye basa riri kuitwa pane rimwe pepa, enda kumenyu "Faira".Dzvanya pakuraira "Vhura" kune command list.
2. Dhinda bhatani "Ongorora"kuenda kuhwindo kondakita.
3. Sarudza fomati "Mafaera ese", enda kunzvimbo inochengeterwa gwaro redu, imaka uye tinya bhatani "Vhura".
4. Izvo zvatinoziva kwatiri zvichaonekwa pachiratidziro. Text Import Wizard. Isu tinobva tatevera matanho anotsanangurwa mukati Method 2.

mhedziso

Saka, zvisinei nekuoma kuri kuita, chirongwa cheExcel chinokutendera kuti uvhure uye ushande nemafaira mu CSV fomati. Chinhu chikuru ndechokusarudza nzira yekushandiswa. Kana, paunenge uchivhura gwaro zvakajairika (tinya-kaviri kana kuburikidza nemenu yemukati), zviri mukati maro zvine mavara asinganzwisisiki, unogona kushandisa Text Wizard, iyo inokutendera kuti usarudze yakakodzera encoding uye kupatsanura hunhu, iyo inobata zvakananga kurongeka kweiyo. ruzivo rwakaratidzwa.