Maitiro ekushandura Excel Mafaira kuita CSV Format

CSV (Comma Separated Values) imhando yakajairika yekuchengetedza data retabula (nhamba uye zvinyorwa) mune zviri pachena. Iyi faira fomati yakakurumbira uye inogara nekuda kwekuti nhamba huru yezvirongwa uye maapplication anonzwisisa CSV, zvirinani seimwe faira fomati yekuunza / kutumira kunze. Uyezve, iyo CSV fomati inobvumira mushandisi kutarisa mufaira uye nekukurumidza kuwana dambudziko nedata, kana iripo, shandura iyo CSV delimiter, quote mitemo, zvichingodaro. Izvi zvinogoneka nekuti CSV chinyorwa chakareruka, uye kunyangwe asina ruzivo mushandisi anogona kuzvinzwisisa zviri nyore pasina kudzidziswa kwakakosha.

Muchikamu chino, tichadzidza nzira dzinokurumidza uye dzakasimba dzekutumira data kubva kuExcel kuenda kuCSV uye kudzidza kushandura faira reExcel kuita CSV pasina kukanganisa ese akakosha uye ekunze mavara. Iwo matekiniki anotsanangurwa muchinyorwa anoshanda mune ese mavhezheni eExcel 2013, 2010 uye 2007.

• Shandura data kubva kuExcel kuenda kuCSV fomati
• Tumira kunze kubva kuExcel kuenda kuCSV UTF-8 kana UTF-16 fomati
• Dzimwe nzira dzekushandura kubva kuExcel kuenda kuCSV (kuchengetedza mavara akakosha)

Maitiro ekushandura Excel Faira kuita CSV

Kana iwe uchida kuendesa kunze faira reExcel kune chimwe chishandiso, senge bhuku rekero reOutlook kana dhatabhesi rekuwana, tanga washandura pepa reExcel kuita CSV faira, wobva wapinza faira racho. . Csv kune imwe application. Inotevera nhanho nhanho gwara rekuti ungatumira sei Excel workbook kune CSV fomati uchishandisa Excel chishandiso - "Save as".

1. Mune Excel workbook, vhura iyo tab faira (Faira) uye tinya Save as (Sevha se). Mukuwedzera, iyo dialog box Kuchengeta gwaro (Sevha se) inogona kuvhurwa nekudzvanya kiyi F12.
2. Mu File Type (Sevha semhando) sarudza CSV (yakaparadzaniswa nemakoma) (CSV (Comma delimited)).Pamusoro peCSV (comma delimited), mamwe akati wandei CSV fomati sarudzo dziripo:
   • CSV (yakaparadzaniswa nemakoma) (CSV (Comma delimited)). Iyi fomati inochengeta data reExcel secomma delimited text file uye inogona kushandiswa mune imwe Windows application uye mune imwe vhezheni yeWindows inoshanda system.
   • CSV (Macintosh). Iyi fomati inochengetedza bhuku rekushanda reExcel secomma delimited faira rekushandisa paMac inoshanda system.
   • CSV (MS DOS). Inochengetedza bhuku rekushanda reExcel secomma-delimited faira rekushandisa muMS-DOS system yekushandisa.
   • unicode text (Unicode Chinyorwa (* txt)). Iyi chiyero inotsigirwa neanenge ese aripo masisitimu anoshanda, anosanganisira Windows, Macintosh, Linux, uye Solaris Unix. Inotsigira mavara kubva kunenge ese azvino uye kunyangwe mimwe mitauro yekare. Naizvozvo, kana bhuku rebasa reExcel riine data mumitauro yekunze, ndinokurudzira kuti utange warichengeta mufomati unicode text (Unicode Text (* txt)), wozoshandura kuCSV sekutsanangurwa kwazvinoitwa muExport kubva kuExcel kuenda kuUTF-8 kana UTF-16 CSV fomati.

Cherechedza: Mafomati ese ataurwa anongochengetedza iyo inoshanda Excel sheet.

3. Sarudza folda kuchengetedza CSV faira uye tinya Save (Save).Mushure mekudzvanya Save (Chengetedza) mabhokisi maviri ehurukuro achaonekwa. Usanetseke, mameseji aya haaratidze kukanganisa, ndozvazvinofanira kunge zviri.
4. Yekutanga dialog box inokuyeuchidza izvozvo Pepa razvino chete ndiro rinogona kuchengetwa mufaira remhando yakasarudzwa (Rudzi rwefaira rakasarudzwa haritsigire mabhuku ebasa ane mapepa akawanda). Kuti uchengetedze pepa razvino chete, ingodzvanya OK.Kana uchida kuchengetedza mapepa ese ebhuku, wobva wadzvanya cancellation (Kanzura) uye chengetedza mapepa ese ebhuku ega nemazita efaira akakodzera, kana kuti unogona kusarudza kuchengetedza imwe mhando yefaira inotsigira akawanda mapeji.
5. Mushure mekutora OK mubhokisi rekutanga renhaurirano, rechipiri richaonekwa, richiyambira kuti mamwe maficha haazovepo nekuti haatsigirwe neiyo CSV fomati. Aya ndiwo maitiro azvinofanira kuva, saka ingobaya Ehe (Ehe).

Iyi ndiyo nzira iyo Excel worksheet inogona kuchengetwa se CSV faira. Kurumidza uye nyore, uye hapana matambudziko anogona kumuka pano.

Tumira kunze kubva kuExcel kuenda kuCSV ine UTF-8 kana UTF-16 encoding

Kana pepa reExcel riine chero mavara akakosha kana ekunze (tilde, accent, nezvimwe) kana hieroglyphs, ipapo kushandura pepa reExcel kuita CSV nenzira yakatsanangurwa pamusoro hazvishande.

Chiripo ndechekuti timu Save as > CSV (Chengetedza se> CSV) ichabatanidza mavara ese kunze kweASCII (American Standard Code for Information Interchange). Uye kana pane zvinyorwa zvakapetwa kaviri kana dashes refu paExcel sheet (inotamirwa kuExcel, semuenzaniso, kubva mugwaro reShoko kana uchikopa / kuisa zvinyorwa) - mavara akadaro anozocherwawo.

Easy Solution - Sevha Excel Sheet seChinyorwa Faira Unicode(.txt), wozoishandura kuita CSV. Nenzira iyi, ese asiri-ASCII mavara acharamba akasimba.

Ndisati ndaenderera mberi, regai nditsanangure muchidimbu misiyano mikuru pakati peUTF-8 neUTF-16 encodings, kuitira kuti mune imwe neimwe nyaya iwe unogona kusarudza iyo yakakodzera fomati:

• UTF-8 ndeye compact encoding inoshandisa 1 kusvika 4 bytes kune yega yega. Inonyanya kukurudzirwa kushandisa iyi fomati kana mavara eASCII achinyanya mufaira, sezvo mazhinji emavara aya achida 1 byte yendangariro. Imwe bhenefiti ndeyekuti kukodha kwefaira reUTF-8 rine mavara eASCII chete hazvizosiyane neimwe nzira kubva kune imwechete ASCII faira.
• UTF-16 inoshandisa 2 kusvika ku4 mabhayiti kuchengetedza mavara ega ega. Ndokumbira utarise kuti kwete muzviitiko zvese iyo UTF-16 faira inoda imwe nzvimbo yekurangarira kupfuura yeUTF-8 faira. Semuenzaniso, mavara echiJapan anotora 3 kusvika 4 byte muUTF-8 uye 2 kusvika 4 bytes muUTF-16. Nekudaro, zvine musoro kushandisa UTF-16 kana iyo data iine mavara ekuAsia, anosanganisira Japanese, Chinese, uye Korean. Iyo inonyanya kuipa yeiyi encoding ndeyekuti haina kunyatsoenderana nemafaira eASCII uye inoda zvirongwa zvakakosha kuratidza mafaera akadaro. Ramba uchifunga izvi kana ukaronga kuendesa mafaera anozobuda kubva kuExcel kumwe kunhu.

Maitiro ekushandura Excel Faira kuita CSV UTF-8

Ngatitii tine pepa remhando yepamusoro rine mavara ekunze, mumuenzaniso wedu iwo mazita echiJapan.

Kuendesa kunze pepa iri reExcel kune CSV faira, tichichengeta ese hieroglyphs, tichaita zvinotevera:

1. MuExcel, vhura iyo tab faira (Faira) uye tinya Save as (Sevha se).
2. Isa zita refaira mumunda File Type (Sevha semhando) sarudza unicode text (Unicode Text (*.txt)) wobva wadzvanya Save (Chengeta).
3. Vhura iyo yakagadzirwa faira mune chero yakajairwa mavara edhita, seNotepad.

Cherechedza: Haasi ese akareruka mavara edhita anotsigira zvizere Unicode mavara, saka mamwe anogona kuratidzika semakona. Muzviitiko zvakawanda, izvi hazvizokanganisa iyo yekupedzisira faira neimwe nzira, uye iwe unogona kungoifuratira kana kusarudza imwe yepamusoro mupepeti, senge Notepad ++.

4. Sezvo yedu Unicode mameseji faira inoshandisa iyo tab hunhu se delimiters, uye isu tinoda kuishandura kuita CSV (comma delimited), isu tinofanirwa kutsiva mavara etabhu nemakoma.

Cherechedza: Kana pasina kudiwa kwakasimba kwekutora faira ine comma delimiters, asi iwe unoda chero CSV faira iyo Excel inogona kunzwisisa, ipapo danho iri rinogona kusvetuka, sezvo Microsoft Excel inonyatsonzwisisa mafaira ane delimiter - tabulation.

4. Kana uchiri kuda CSV faira (rakaparadzaniswa nemakoma), wobva waita zvinotevera muNotepad:
   • Sarudza iyo tab chimiro, tinya-kurudyi pairi, uye mune yemukati menyu, tinya mufananidzo (Kopi), kana kungodzvanya Ctrl + Csezvinoratidzwa mumufananidzo uri pasi apa.
   • dzvanya Ctrl + Hkuvhura dialog box Substitute (Tsvanura) uye unamate iyo yakakopwa tebhu chimiro mumunda kuti (Wana chii). Muchiitiko ichi, chitubu chichaenda kurudyi - izvi zvinoreva kuti chimiro chebhu chinoiswa. Mumunda pane (Siva ne) isa koma wodzvanya Tsiva zvese (Tsvanura zvose).

   MuNotepad, mhedzisiro ichave seizvi:

   

5. Click faira > Save as (Faira> Chengetedza se), isa zita refaira uye mune yekudonha-pasi rondedzero Encoding (Encoding) sarudza UTF-8… Wobva wadzvanya bhatani Save (Chengeta).
6. Vhura Windows Explorer uye shandura iyo yekuwedzera faira kubva .txt on . Csv.Shandura kuwedzera zvakasiyana .txt on . Csv Unogona kuzviita zvakananga muNotepad. Kuti uite izvi, mubhokisi rebhokisi Save as (Chengetedza se) mumunda File Type (Sevha semhando) sarudza sarudzo Mafaira ese (Mafaira ose), uye wedzera ".csv" kune zita refaira mundima inoenderana, sezvinoratidzwa mumufananidzo uri pasi apa.
7. Vhura iyo CSV faira muExcel, yeizvi, pane iyo tab faira (Filet) knead Open > Nyora mafaira (Vhura> Mameseji mafaera) uye tarisa kana iyo data yakanaka.

Cherechedza: Kana faira yako ichida kushandiswa kunze kweExcel uye UTF-8 fomati inodiwa, saka usaite chero shanduko pabepa uye usaichengetedze zvakare muExcel, sezvo izvi zvinogona kutungamirira kumatambudziko nekuverenga encoding. Kana chimwe chikamu che data chisina kuratidzwa muExcel, vhura iyo yakafanana faira muNotepad uye gadzirisa iyo data mairi. Usakanganwa kuchengetedza faira muUTF-8 fomati zvakare.

Maitiro ekushandura Excel Faira kuita CSV UTF-16

Kutumira kunze kune UTF-16 CSV faira inokurumidza uye iri nyore pane kutumira kune UTF-8. Icho chokwadi ndechekuti Excel inongoshandisa iyo UTF-16 fomati paunochengeta faira se unicode text (Unicode Chinyorwa).

Kuti uite izvi, chengetedza faira uchishandisa chishandiso Save as (Sevha se) muExcel uyezve muWindows Explorer, shandura kuwedzera kwefaira rakagadzirwa kuti . Csv. Zvaitwa!

Kana iwe uchida faira reCSV rine semicolon kana semicolon sedelimiter, chinja mavara ese etibhu nemakoma kana semicolon zvakateerana muNotepad kana chero mamwe mavara edhita yesarudzo yako (ona pekutanga muchinyorwa chino kuti uwane yakadzama mirairo yemaitirwo eizvi).

Dzimwe Nzira dzekushandura Excel Mafaira kuCSV

Nzira dzakatsanangurwa pamusoro apa dzekutumira kunze data kubva kuExcel kuenda kuCSV (UTF-8 neUTF-16) ndeyepasirese, kureva kuti inokodzera kushanda nechero mavara akakosha uye mune chero vhezheni yeExcel kubva 2003 kusvika 2013.

Pane dzimwe nzira dzakawanda dzekushandura data kubva kuExcel kuenda kuCSV fomati. Kusiyana nemhinduro dzaratidzwa pamusoro, nzira idzi hadzizokonzeresa faira reUTF-8 rakachena (izvi hazvishande kuOpenOffice, inogona kutumira mafaera eExcel mune akati wandei eUTF encoding sarudzo). Asi kazhinji, iyo faira inoguma ichange iine iyo chaiyo hunhu seti, iyo inogona kushandurwa isingarwadze kuUTF-8 fomati uchishandisa chero chinyorwa chinyorwa.

Shandura Excel Faira kuita CSV Uchishandisa Google Sheets

Sezvazvinoitika, zviri nyore kwazvo kushandura faira reExcel kuita CSV uchishandisa Google Sheets. Kunze kwekuti Google Drive yakatoiswa pakombuta yako, tevera matanho mashanu akareruka aya:

1. MuGoogle Drive tinya bhatani sika (Gadzira) uye sarudza tafura (Spreadsheet).
2. Pamenu faira (Filet) knead Tumira (Import).
3. Click Download (Rodha) uye sarudza iyo Excel faira yekuisa kubva pakombuta yako.
4. Mubhokisi rehurukuro impfile ort (Import faira) sarudza Tsiva tafura (Siva spreadsheet) uye tinya Tumira (Import).

Tip: Kana iyo Excel faira iri diki, saka kuchengetedza nguva, unogona kuendesa data kubva kwairi kuenda kuGoogle spreadsheet uchishandisa kopi / paste.

5. Pamenu faira (Filet) knead Download as (Dhawunirodha se), sarudza mhando yefaira CSV - iyo faira ichachengetwa pakombuta.

Chekupedzisira, vhura iyo yakagadzirwa CSV faira mune chero mavara edhita kuti uve nechokwadi chekuti mavara ese akachengetedzwa nemazvo. Nehurombo, mafaera eCSV akagadzirwa nenzira iyi haagare achiratidza nenzira kwayo muExcel.

Sevha .xlsx faira se.xls wobva washandura kufaira reCSV

Iyi nzira haidi chero mamwe mazwi, sezvo zvese zvatove pachena kubva pazita.

Ndakawana mhinduro iyi pane imwe yemaforamu akatsaurirwa kuExcel, ini handiyeuke kuti ndeipi. Kutaura chokwadi, handina kumbobvira ndashandisa nzira iyi, asi maererano nevashandisi vakawanda, mamwe mavara anokosha anorasika kana achichengetedza zvakananga kubva. . Xlsx в . Csv, asi kana uri wokutanga . Xlsx save as .xls, wozoti . Csv, sezvataita patangira nyaya ino.

Zvakadaro, edza iyi nzira yekugadzira CSV mafaera kubva kuExcel iwe pachako, uye kana ikashanda, ichave yakanaka saver nguva.

Kuchengetedza faira reExcel seCSV uchishandisa OpenOffice

OpenOffice ndeye yakavhurika sosi suite yemashandisirwo ayo anosanganisira spreadsheet application inoita basa rakakura rekutumira kunze data kubva kuExcel kuenda kuCSV fomati. Muchokwadi, ichi chishandiso chinokupa iwe kuwana kune dzimwe sarudzo paunenge uchishandura maspredishiti kuCSV mafaera (encoding, delimiters, zvichingodaro) kupfuura Excel neGoogle Sheets akaiswa pamwechete.

Ingovhura iyo Excel faira muOpenOffice Calc, tinya faira > Save as (Faira> Sevha se) uye sarudza rudzi rwefaira CSV zvinyorwa (Chinyorwa CSV).

Nhanho inotevera ndeyekusarudza parameter values Encoding (Maseti ehunhu) uye Muparadzi wemunda (Field delimiter). Ehe, kana isu tichida kugadzira iyo UTF-8 CSV faira ine koma se delimiters, wobva wasarudza UTF-8 uye isa koma (,) munzvimbo dzakakodzera. Parameter Kuparadzanisa mavara (Text delimiter) kazhinji inosiiwa isina kuchinjwa - quotation mamaki (“). Next tinya OK.

Nenzira imwecheteyo, kuitira kukurumidza uye kusingarwadze kutendeuka kubva kuExcel kuenda kuCSV, unogona kushandisa imwe application - LibreOffice. Bvumiranai, zvingave zvakanaka kana Microsoft Excel ikapa kugona kugadzirisa zvakare marongero kana uchigadzira CSV mafaera.

Muchikamu chino, ndakataura nezve nzira dzandinoziva nezve kushandura Excel mafaera kuita CSV. Kana iwe uchiziva dzimwe nzira dzinoshanda dzekutumira kunze kubva kuExcel kuenda kuCSV, ndapota tiudze nezvazvo mune zvakataurwa. Ndinokutendai nekuteerera!