Momwe mungasinthire Mafayilo a Excel kukhala CSV Format

CSV (Makhalidwe Osiyanitsidwa ndi Koma) ndi njira yodziwika bwino yosungira deta ya tabular (manambala ndi mawu) m'mawu osavuta. Mafayilo awa ndiwotchuka komanso okhalitsa chifukwa chakuti mapulogalamu ndi mapulogalamu ambiri amamvetsetsa CSV, makamaka ngati mtundu wina wamafayilo wotumizira / kutumiza kunja. Komanso, mawonekedwe a CSV amalola wosuta kuyang'ana mu fayilo ndikupeza vuto ndi deta, ngati alipo, asinthe CSV delimiter, malamulo obwereza, ndi zina zotero. Izi ndizotheka chifukwa CSV ndi mawu osavuta, ndipo ngakhale wogwiritsa ntchito wosadziwa amatha kumvetsetsa mosavuta popanda maphunziro apadera.

M'nkhaniyi, tiphunzira njira zachangu komanso zachangu zotumizira deta kuchokera ku Excel kupita ku CSV ndikuphunzira momwe mungasinthire fayilo ya Excel kukhala CSV osasokoneza zilembo zonse zapadera komanso zakunja. Njira zomwe zafotokozedwa m'nkhaniyi zimagwira ntchito m'mitundu yonse ya Excel 2013, 2010 ndi 2007.

• Sinthani data kuchokera ku Excel kukhala CSV
• Tumizani kunja kuchokera ku Excel kupita ku CSV UTF-8 kapena mtundu wa UTF-16
• Njira zina zosinthira kuchokera ku Excel kupita ku CSV (kusunga zilembo zapadera)

Momwe mungasinthire Fayilo ya Excel kukhala CSV

Ngati mukufuna kutumiza fayilo ya Excel ku pulogalamu ina, monga bukhu la adilesi la Outlook kapena database ya Access, choyamba sinthani pepala la Excel kukhala fayilo ya CSV, kenako lowetsani fayiloyo. . Csv ku ntchito ina. Zotsatirazi ndi ndondomeko ya sitepe ndi sitepe ya momwe mungatumizire buku la Excel ku CSV pogwiritsa ntchito chida cha Excel - "Sungani monga".

1. Mu buku la Excel, tsegulani tabu file (Fayilo) ndikudina Sungani monga (Sungani ngati). Komanso, dialog box Kusunga chikalata (Sungani monga) akhoza kutsegulidwa ndi kukanikiza kiyi F12.
2. Mu Mtundu wa Fayilo (Sungani monga mtundu) sankhani CSV (yolekanitsidwa ndi koma) (CSV (Comma delimited)Kuphatikiza pa CSV (comma delimited), zosankha zina zingapo za CSV zilipo:
   • CSV (yolekanitsidwa ndi koma) (CSV (Comma delimited) Mtunduwu umasunga zidziwitso za Excel ngati fayilo yotsatiridwa ndi koma ndipo zitha kugwiritsidwa ntchito mu pulogalamu ina ya Windows komanso mumitundu ina ya Windows.
   • CSV (Macintosh). Mtunduwu umasunga buku la Excel ngati fayilo yokhazikika kuti mugwiritse ntchito pa Mac.
   • CSV (MS DOS). Imasunga buku lantchito la Excel ngati fayilo yokhala ndi comma kuti mugwiritse ntchito pa MS-DOS.
   • unicode text (Unicode Text (*txt)). Mulingo uwu umathandizidwa ndi pafupifupi machitidwe onse omwe alipo, kuphatikiza Windows, Macintosh, Linux, ndi Solaris Unix. Imathandizira zilembo zamitundu yonse yamakono komanso zilankhulo zina zakale. Chifukwa chake, ngati bukhu la Excel lili ndi zilankhulo zakunja, ndikupangira kuti muyisunge kaye momwe ilili unicode text (Unicode Text (*txt)), kenako sinthani kukhala CSV monga momwe tafotokozera pambuyo pake mu Tumizani kuchokera ku Excel kupita ku UTF-8 kapena mtundu wa UTF-16 CSV.

Zindikirani: Mawonekedwe onse otchulidwa amangosunga pepala logwira ntchito la Excel.

3. Sankhani chikwatu kuti musunge fayilo ya CSV ndikudina Save (Sungani).Atatha kukanikiza Save (Sungani) mabokosi awiri a zokambirana adzawoneka. Osadandaula, mauthengawa sakuwonetsa cholakwika, ndi momwe ziyenera kukhalira.
4. Bokosi loyamba la zokambirana limakukumbutsani zimenezo Mapepala apano okha ndi omwe angasungidwe mufayilo yamtundu womwe wasankhidwa (Mtundu wosankhidwa wa fayilo sugwirizana ndi mabuku ogwirira ntchito omwe ali ndi mapepala angapo). Kuti musunge tsamba lomwe lilipo, ingodinani OK.Ngati mukufuna kusunga mapepala onse a bukhuli, dinani kufuta (Letsani) ndi kusunga mapepala onse a bukhu limodzi ndi mayina oyenerera a fayilo, kapena mukhoza kusankha kusunga mtundu wina wa fayilo womwe umagwirizana ndi masamba angapo.
5. Pambuyo kuwonekera OK m'bokosi loyamba la zokambirana, lachiwiri lidzawonekera, kuchenjeza kuti zina sizidzakhalapo chifukwa sizikuthandizidwa ndi mtundu wa CSV. Umu ndi momwe ziyenera kukhalira, ndiye ingodinani inde (Inde).

Umu ndi momwe tsamba la Excel lingasungidwe ngati fayilo ya CSV. Mwachangu komanso mophweka, ndipo palibe zovuta zomwe zingabwere pano.

Tumizani kunja kuchokera ku Excel kupita ku CSV ndi ma encoding a UTF-8 kapena UTF-16

Ngati pepala la Excel lili ndi zilembo zapadera kapena zakunja (tilde, accent, ndi zina) kapena hieroglyphs, ndiye kuti kutembenuza pepala la Excel kukhala CSV mwanjira yomwe tafotokozazi sikungagwire ntchito.

Mfundo ndi yakuti timu Sungani monga > CSV (Sungani monga> CSV) iphatikiza zilembo zonse kupatula ASCII (American Standard Code for Information Interchange). Ndipo ngati pali mawu awiri kapena mizere yayitali pa pepala la Excel (lotumizidwa ku Excel, mwachitsanzo, kuchokera ku chikalata cha Mawu pamene mukukopera / kumata malemba) - zilembo zoterezi zidzaphwanyidwanso.

Njira Yosavuta - Sungani Mapepala a Excel ngati Fayilo Yolemba Unicode(.txt), ndikusintha kukhala CSV. Mwanjira iyi, zilembo zonse zomwe si za ASCII zidzakhalabe.

Ndisanapitirire, ndiroleni ndifotokoze mwachidule kusiyana kwakukulu pakati pa ma encoding a UTF-8 ndi UTF-16, kuti pamutu uliwonse mutha kusankha mtundu woyenera:

• UTF-8 ndi kabisidwe kakang'ono kwambiri komwe kamagwiritsa ntchito mabayiti 1 mpaka 4 pamtundu uliwonse. Nthawi zambiri timalimbikitsa kugwiritsa ntchito mawonekedwewa pamene zilembo za ASCII zili pamwamba pa fayilo, chifukwa zambiri mwa zilembozi zimafuna 1 byte ya kukumbukira. Ubwino winanso ndikuti kusungitsa fayilo ya UTF-8 yokhala ndi zilembo za ASCII zokha sikungasiyane mwanjira iliyonse ndi fayilo yomweyo ya ASCII.
• UTF-16 amagwiritsa 2 mpaka 4 mabayiti kusunga chilembo chilichonse. Chonde dziwani kuti sikuti nthawi zonse fayilo ya UTF-16 imafunikira malo ambiri okumbukira kuposa fayilo ya UTF-8. Mwachitsanzo, zilembo za Chijapanizi zimatenga ma byte 3 mpaka 4 mu UTF-8 ndi ma byte 2 mpaka 4 mu UTF-16. Chifukwa chake, ndizomveka kugwiritsa ntchito UTF-16 ngati deta ili ndi zilembo zaku Asia, kuphatikiza Chijapani, Chitchaina, ndi Chikorea. Choyipa chachikulu cha encoding iyi ndikuti sichigwirizana kwathunthu ndi mafayilo a ASCII ndipo imafunikira mapulogalamu apadera kuti awonetse mafayilo otere. Kumbukirani izi ngati mukufuna kuitanitsa mafayilo kuchokera ku Excel kwinakwake.

Momwe mungasinthire Fayilo ya Excel kukhala CSV UTF-8

Tiyerekeze kuti tili ndi pepala la Excel lomwe lili ndi zilembo zakunja, mu chitsanzo chathu ndi mayina achi Japan.

Kutumiza pepala ili la Excel ku fayilo ya CSV, ndikusunga zolemba zonse, tichita izi:

1. Mu Excel, tsegulani tabu file (Fayilo) ndikudina Sungani monga (Sungani ngati).
2. Lowetsani dzina lafayilo m'munda Mtundu wa Fayilo (Sungani monga mtundu) sankhani unicode text ( Unicode Text (* .txt)) ndikudina Save (Sungani).
3. Tsegulani fayilo yomwe idapangidwa muzolemba zilizonse, monga Notepad.

Zindikirani: Sikuti osintha onse osavuta amatha kugwiritsa ntchito zilembo za Unicode, chifukwa chake ena amatha kuwoneka ngati makona anayi. Nthawi zambiri, izi sizingakhudze fayilo yomaliza mwanjira iliyonse, ndipo mutha kungoyinyalanyaza kapena kusankha mkonzi wapamwamba kwambiri, monga Notepad ++.

4. Popeza fayilo yathu ya Unicode imagwiritsa ntchito mawonekedwe a tabu ngati zodulira, ndipo tikufuna kuyisintha kukhala CSV (comma delimited), tifunika kusintha zilembo za tabu ndi koma.

Zindikirani: Ngati palibe kufunikira kokwanira kuti mupeze fayilo yokhala ndi comma delimiters, koma mukufuna fayilo iliyonse ya CSV yomwe Excel angamvetse, ndiye kuti sitepe iyi ikhoza kudumpha, popeza Microsoft Excel imamvetsetsa bwino mafayilo okhala ndi delimiter - tabulation.

4. Ngati mukufunabe fayilo ya CSV (yosiyanitsidwa ndi koma), chitani zotsatirazi mu Notepad:
   • Sankhani mawonekedwe a tabu, dinani pomwepa, ndipo mumenyu yankhaniyo, dinani Koperani (Koperani), kapena ingodinani Ctrl + Cmonga momwe tawonera m'chithunzichi.
   • Press Ctrl + Hkuti mutsegule bokosi la zokambirana M'malo (Bwezerani) ndikumata zilembo zomwe zakopedwa m'mundamo kuti (Pezani chiyani). Pankhaniyi, cholozera chidzasunthira kumanja - izi zikutanthauza kuti mawonekedwe a tabu amalowetsedwa. M'munda Than (Sinthani ndi) lowetsani koma ndikusindikiza Bwezerani zonse (Sinthani zonse).

   Mu Notepad, zotsatira zake zikhala motere:

   

5. Dinani file > Sungani monga (Fayilo> Sungani monga), lowetsani dzina la fayilo ndi mndandanda wotsitsa Kulemba (Encoding) sankhani UTF-8… Kenako dinani batani Save (Sungani).
6. Tsegulani Windows Explorer ndikusintha fayilo yowonjezera kuchokera .ndilembereni on . Csv.Sinthani zowonjezera mosiyana .ndilembereni on . Csv Mutha kuchita izi mwachindunji mu Notepad. Kuti muchite izi, mu bokosi la dialog Sungani monga (Sungani ngati) m'munda Mtundu wa Fayilo (Sungani monga mtundu) sankhani njira Mafayilo onse (Mafayilo onse), ndikuwonjezera ".csv" ku dzina lafayilo mugawo lofananira, monga momwe tawonetsera pachithunzichi.
7. Tsegulani fayilo ya CSV mu Excel, chifukwa cha izi, pa tabu file (Filet) knead Open > Mafayilo olemba (Tsegulani> Mafayilo alemba) ndikuwona ngati deta ili bwino.

Zindikirani: Ngati fayilo yanu idapangidwa kuti igwiritsidwe ntchito kunja kwa Excel ndi mtundu wa UTF-8 ndiyofunikira, musasinthe papepala ndipo musayisungenso ku Excel, chifukwa izi zitha kubweretsa zovuta pakuwerenga kabisidwe. Ngati gawo lina la data silikuwonetsedwa mu Excel, tsegulani fayilo yomweyi mu Notepad ndikuwongolera zomwe zilimo. Musaiwale kusunganso fayilo mu mtundu wa UTF-8.

Momwe mungasinthire Fayilo ya Excel kukhala CSV UTF-16

Kutumiza ku fayilo ya UTF-16 CSV ndikofulumira komanso kosavuta kuposa kutumiza ku UTF-8. Chowonadi ndi chakuti Excel imagwiritsa ntchito mtundu wa UTF-16 mukasunga fayilo ngati unicode text (Unicode Text).

Kuti muchite izi, sungani fayilo pogwiritsa ntchito chida Sungani monga (Sungani ngati) mu Excel ndiyeno mu Windows Explorer, sinthani kufalikira kwa fayilo yomwe idapangidwa kukhala . Csv. Wachita!

Ngati mukufuna fayilo ya CSV yokhala ndi semicolon kapena semicolon monga delimiter, sinthani zilembo zonse za tabu ndi koma kapena semicolons motsatana mu Notepad kapena mkonzi wina uliwonse womwe mungasankhe (onani koyambirira kwa nkhaniyi kuti mudziwe zambiri zamomwe mungachitire izi).

Njira Zina Zosinthira Mafayilo a Excel kukhala CSV

Njira zomwe zafotokozedwa pamwambapa zotumizira deta kuchokera ku Excel kupita ku CSV (UTF-8 ndi UTF-16) ndizapadziko lonse lapansi, mwachitsanzo, ndizoyenera kugwira ntchito ndi zilembo zapadera komanso mtundu uliwonse wa Excel kuyambira 2003 mpaka 2013.

Pali njira zina zambiri zosinthira deta kuchokera ku Excel kukhala mtundu wa CSV. Mosiyana ndi mayankho omwe awonetsedwa pamwambapa, njirazi sizingabweretse fayilo yoyera ya UTF-8 (izi sizikugwira ntchito ku OpenOffice, yomwe imatha kutumiza mafayilo a Excel munjira zingapo za UTF). Koma nthawi zambiri, fayiloyo imakhala ndi zilembo zolondola, zomwe zimatha kusinthidwa kukhala mtundu wa UTF-8 pogwiritsa ntchito mkonzi uliwonse.

Sinthani Fayilo ya Excel kukhala CSV Pogwiritsa Ntchito Mapepala a Google

Zotsatira zake, ndizosavuta kusintha fayilo ya Excel kukhala CSV pogwiritsa ntchito Mapepala a Google. Pokhapokha kuti Google Drive yakhazikitsidwa kale pakompyuta yanu, tsatirani njira zisanu zosavuta izi:

1. Mu Google Drive dinani batani Pangani (Pangani) ndikusankha Table (Spreadsheet).
2. Pa menyu file (Filet) knead Lowani (Tengani).
3. Dinani Download (Kwezani) ndikusankha fayilo ya Excel kuti muyike kuchokera pakompyuta yanu.
4. Mu dialog box Impfayilo ort (Tengani fayilo) sankhani Sinthani tebulo (Sinthani spreadsheet) ndikudina Lowani (Tengani).

Tip: Ngati fayilo ya Excel ndi yaying'ono, ndiye kuti musunge nthawi, mutha kusamutsa deta kuchokera ku Google spreadsheet pogwiritsa ntchito kukopera / kumata.

5. Pa menyu file (Filet) knead Sakani monga (Koperani monga), sankhani mtundu wa fayilo CSV - fayilo idzasungidwa pa kompyuta.

Pomaliza, tsegulani fayilo ya CSV yopangidwa muzolemba zilizonse kuti muwonetsetse kuti zilembo zonse zasungidwa bwino. Tsoka ilo, mafayilo a CSV opangidwa motere samawoneka bwino mu Excel.

Sungani fayilo ya .xlsx ngati .xls ndikusintha kukhala fayilo ya CSV

Njirayi sikutanthauza ndemanga zowonjezera, popeza zonse zadziwika kale kuchokera ku dzina.

Ndinapeza yankho ili pa imodzi mwamabwalo operekedwa ku Excel, sindikukumbukira kuti ndi iti. Kunena zowona, sindinagwiritsepo ntchito njirayi, koma malinga ndi ogwiritsa ntchito ambiri, zilembo zina zapadera zimatayika posunga mwachindunji kuchokera . Xlsx в . Csv, koma khalanibe ngati woyamba . Xlsx sungani monga .xls, ndiyeno ngati . Csv, monga tinachitira kumayambiriro kwa nkhani ino.

Komabe, yesani njira iyi yopangira mafayilo a CSV kuchokera ku Excel nokha, ndipo ngati ikugwira ntchito, idzakhala nthawi yabwino yopulumutsa.

Kusunga fayilo ya Excel ngati CSV pogwiritsa ntchito OpenOffice

OpenOffice ndi gwero lotseguka la mapulogalamu omwe amaphatikiza pulogalamu ya spreadsheet yomwe imagwira ntchito yabwino yotumiza deta kuchokera ku Excel kupita ku CSV. M'malo mwake, pulogalamuyi imakupatsani mwayi wosankha zambiri mukamatembenuza ma spreadsheets kukhala mafayilo a CSV (encoding, delimiters, ndi zina zotero) kuposa Excel ndi Google Mapepala atayikidwa palimodzi.

Ingotsegulani fayilo ya Excel mu OpenOffice Calc, dinani file > Sungani monga (Fayilo> Sungani monga) ndikusankha mtundu wa fayilo CSV mawu (Mawu a CSV).

Chotsatira ndikusankha magawo a parameter Kulemba (Makhalidwe) ndi Olekanitsa munda (Delimiter) Zachidziwikire, ngati tikufuna kupanga fayilo ya UTF-8 CSV yokhala ndi ma koma monga odulira, sankhani UTF-8 ndi lowetsani koma (,) m'malo oyenera. Parameter Cholekanitsa malemba (Text delimiter) nthawi zambiri imasiyidwa yosasinthika - ma quotation marks (“). Kenako dinani OK.

Momwemonso, kuti mutembenuke mwachangu komanso mopanda ululu kuchokera ku Excel kupita ku CSV, mutha kugwiritsa ntchito pulogalamu ina - LibreOffice. Gwirizanani, zingakhale zabwino ngati Microsoft Excel ipereka kuthekera kosinthiranso makonda popanga mafayilo a CSV.

M'nkhaniyi, ndalankhula za njira zomwe ndikudziwa zosinthira mafayilo a Excel kukhala CSV. Ngati mukudziwa njira zabwino zotumizira kuchokera ku Excel kupita ku CSV, chonde tiuzeni za izi m'mawu. Zikomo chifukwa chomvetsera!