Mokhoa oa ho fetolela lifaele tsa Excel ho CSV Format

CSV (Maemo a Arohaneng ka Likoma) ke mokhoa o tloaelehileng oa ho boloka data ea tabular (nomoro le mongolo) ka mongolo o hlakileng. Sebopeho sena sa faele se tumme ebile se tšoarella ka lebaka la hore palo e kholo ea mananeo le lits'ebetso li utloisisa CSV, bonyane e le mofuta o mong oa faele bakeng sa ho kenya / ho romela kantle ho naha. Ho feta moo, sebopeho sa CSV se lumella mosebedisi ho sheba faele mme hang-hang a fumane bothata ka data, haeba e teng, fetola CSV delimiter, melao ea qotsa, joalo-joalo. Sena sea khoneha hobane CSV ke sengoloa se bonolo, mme le mosebelisi ea se nang boiphihlelo a ka se utloisisa habonolo ntle le koetliso e khethehileng.

Sehloohong sena, re tla ithuta mekhoa e potlakileng le e sebetsang ea ho romella data ho tloha Excel ho ea ho CSV le ho ithuta ho fetolela faele ea Excel ho CSV ntle le ho sotha litlhaku tsohle tse ikhethang le tsa kantle ho naha. Mekhoa e hlalositsoeng sengolong e sebetsa liphetolelong tsohle tsa Excel 2013, 2010 le 2007.

• Fetolela data ho tloha Excel ho ea ho CSV format
• Romella ho tloha Excel ho ea ho CSV UTF-8 kapa sebopeho sa UTF-16
• Mekhoa e meng ea ho fetolela ho tloha Excel ho ea ho CSV (ho boloka litlhaku tse khethehileng)

Mokhoa oa ho fetolela faele ea Excel ho CSV

Haeba u batla ho romela faele ea Excel ho sesebelisoa se seng, joalo ka buka ea liaterese ea Outlook kapa database ea Access, qala ka ho fetolela leqephe la Excel ho faele ea CSV, ebe u kenya faele. . Csv ho sesebelisoa se seng. Se latelang ke tataiso ea mohato ka mohato mabapi le mokhoa oa ho romella buka ea Excel ho sebopeho sa CSV u sebelisa sesebelisoa sa Excel - "Boloka joalo".

1. Bukeng ea mosebetsi ea Excel, bula tab faele (File) ebe o tobetsa Boloka joalo (Boloka joalo ka). Ho phaella moo, lebokose la puisano Ho boloka tokomane (Save as) e ka buloa ka ho tobetsa konopo F12.
2. ka Mofuta oa Feshene (Boloka joalo ka mofuta) khetha CSV (e arotsoe ke lifeeloana) (CSV (Comma delimited)).Ntle le CSV (comma delimited), likhetho tse ling tse 'maloa tsa CSV lia fumaneha:
   • CSV (e arotsoe ke lifeeloana) (CSV (Comma delimited)). Sebopeho sena se boloka data ea Excel e le faele ea mongolo e arotsoeng ka koma 'me e ka sebelisoa ts'ebelisong e' ngoe ea Windows le mofuteng o fapaneng oa sistimi e sebetsang ea Windows.
   • CSV (Macintosh). Sebopeho sena se boloka buka ea mosebetsi ea Excel e le faele e arotsoeng ka comma hore e sebelisoe tsamaisong ea Mac.
   • CSV (MS DOS). E boloka buka ea mosebetsi ea Excel e le faele e arotsoeng ka likoma hore e sebelisoe tsamaisong ea tšebetso ea MS-DOS.
   • mongolo oa unicode (Mongolo oa Unicode (*txt)). Tekanyetso ena e tšehetsoa ke hoo e batlang e le lits'ebetso tsohle tse teng tsa ts'ebetso, ho kenyeletsoa Windows, Macintosh, Linux, le Solaris Unix. E tšehetsa litlhaku tsa hoo e ka bang lipuong tsohle tsa sejoale-joale esita le lipuong tse ling tsa khale. Ka hona, haeba buka ea mosebetsi ea Excel e na le data ka lipuo tsa linaha tse ling, ke khothaletsa hore u e boloke pele ka sebopeho mongolo oa unicode (Unicode Text (*txt)), ebe o fetolela ho CSV joalokaha ho hlalositsoe hamorao ho Export ho tloha Excel ho ea ho UTF-8 kapa UTF-16 CSV format.

Hlokomela: Liforomo tsohle tse boletsoeng li boloka feela leqephe le sebetsang la Excel.

3. Khetha foldara ho boloka faele ea CSV ebe o tobetsa Save (Boloka).Ka mora ho tobetsa Save (Boloka) ho tla hlaha mabokose a mabeli a puisano. Seke oa tšoenyeha, melaetsa ena ha e bontše phoso, ke kamoo e lokelang ho ba kateng.
4. Lebokose la pele la puisano le u hopotsa seo Ke leqephe la hajoale feela le ka bolokoang faeleng ea mofuta o khethiloeng (Mofuta o khethiloeng oa faele ha o tšehetse libuka tsa mosebetsi tse nang le maqephe a mangata). Ho boloka leqephe la hajoale feela, tobetsa feela OK.Haeba u batla ho boloka maqephe ohle a buka, tobetsa ho hlakola (Hlakola) 'me u boloke maqephe ohle a buka ka bonngoe ka mabitso a nepahetseng a lifaele, kapa u ka khetha ho boloka mofuta o mong oa faele o tšehetsang maqephe a mangata.
5. Kamora ho penya OK ka lebokoseng la pele la puisano, ho tla hlaha ea bobeli, e lemosang hore likarolo tse ling li ke ke tsa fumaneha hobane ha li tšehetsoe ke sebopeho sa CSV. Ke kamoo e lokelang ho ba kateng, kahoo tobetsa feela E (Ee).

Ke kamoo leqephe la mosebetsi la Excel le ka bolokoang joalo ka faele ea CSV. Ho potlakile ebile ho bonolo, 'me ha ho na mathata a ka hlahang mona.

Romella ho tloha Excel ho ea ho CSV ka khouto ea UTF-8 kapa UTF-16

Haeba leqephe la Excel le na le litlhaku tse ikhethileng kapa tsa kantle ho naha (tilde, accent, le tse ling) kapa li-hieroglyphs, joale ho fetolela leqephe la Excel ho CSV ka mokhoa o hlalositsoeng ka holimo ho ke ke ha sebetsa.

Taba ke hore sehlopha Boloka joalo > CSV (Boloka e le > CSV) e tla kopanya litlhaku tsohle ntle le ASCII (American Standard Code for Information Interchange). 'Me haeba ho na le litemana tse peli kapa li-dashes tse telele letlapeng la Excel (ho fetisetsoa ho Excel, mohlala, ho tloha tokomane ea Lentsoe ha ho kopitsoa / ho beha mongolo) - litlhaku tse joalo le tsona li tla khaoloa.

Tharollo e Bonolo - Boloka Leqephe la Excel joalo ka Faele ea Sengoloa Unicode(.txt), ebe o e fetolela ho CSV. Ka tsela ena, litlhaku tsohle tseo e seng tsa ASCII li tla lula li sa fetohe.

Pele ke fetela pele, e re ke hlalose ka bokhutšoanyane phapang e kholo lipakeng tsa likhoutu tsa UTF-8 le UTF-16, e le hore maemong a mang le a mang u ka khetha sebopeho se nepahetseng:

• UTF-8 ke khouto e kopaneng haholoanyane e sebelisang li-byte tse 1 ho isa ho tse 4 bakeng sa tlhaku ka 'ngoe. Hangata ho khothaletsoa ho sebelisa sebopeho sena ha litlhaku tsa ASCII li le teng ka har'a faele, kaha boholo ba litlhaku tsena li hloka memori e le 'ngoe. Molemo o mong ke hore khouto ea faele ea UTF-1 e nang le litlhaku tsa ASCII feela e ke ke ea fapana ka tsela efe kapa efe le faele e tšoanang ea ASCII.
• UTF-16 e sebelisa li-byte tse 2 ho isa ho tse 4 ho boloka sebapali ka seng. Ka kopo hlokomela hore ha se maemong 'ohle faele ea UTF-16 e hlokang sebaka sa mohopolo ho feta faele ea UTF-8. Mohlala, litlhaku tsa Sejapane li nka li-byte tse 3 ho isa ho tse 4 ho UTF-8 le li-byte tse 2 ho isa ho tse 4 ho UTF-16. Kahoo, hoa utloahala ho sebelisa UTF-16 haeba data e na le litlhaku tsa Asia, ho kenyeletsoa Sejapane, Sechaena le Sekorea. Bothata bo ka sehloohong ba khouto ena ke hore ha e lumellane ka botlalo le lifaele tsa ASCII mme e hloka mananeo a khethehileng ho hlahisa lifaele tse joalo. Hopola sena haeba u rera ho kenya lifaele tse hlahisoang ho tsoa Excel kae-kae.

Mokhoa oa ho fetolela faele ea Excel ho CSV UTF-8

Ha re re re na le leqephe la Excel le nang le litlhaku tsa kantle ho naha, mohlala oa rona ke mabitso a Majapane.

Ho romella leqephe lena la Excel faeleng ea CSV, ha re ntse re boloka li-hieroglyphs kaofela, re tla etsa tse latelang:

1. Ho Excel, bula tab faele (File) ebe o tobetsa Boloka joalo (Boloka joalo ka).
2. Kenya lebitso la faele tšimong Mofuta oa Feshene (Boloka joalo ka mofuta) khetha mongolo oa unicode (Unicode Text (*.txt)) ebe o tobetsa Save (Boloka).
3. Bula faele e entsoeng ho mohlophisi ofe kapa ofe o tloaelehileng oa mongolo, joalo ka Notepad.

Hlokomela: Ha se bahlophisi bohle ba mongolo ba bonolo ba tšehetsang litlhaku tsa Unicode ka botlalo, ka hona, tse ling li ka hlaha e le likhutlo-tharo. Maemong a mangata, sena se ke ke sa ama faele ea ho qetela ka tsela leha e le efe, 'me u ka e hlokomoloha kapa ua khetha mohlophisi ea tsoetseng pele, joalo ka Notepad ++.

4. Kaha faele ea rona ea mongolo oa Unicode e sebelisa sebopeho sa tabo joalo ka li-delimiters, 'me re batla ho e fetolela ho CSV (comma delimited), re hloka ho khutlisa litlhaku tsa li-tab ka lifehelo.

Hlokomela: Haeba ho se na tlhokahalo e tiileng ea ho fumana faele e nang le li-comma delimiters, empa u hloka faele leha e le efe ea CSV eo Excel e ka e utloisisang, joale mohato ona o ka tlōloa, kaha Microsoft Excel e utloisisa lifaele ka ho phethahetseng ka delimiter - tabulation.

4. Haeba o ntse o hloka faele ea CSV (e arotsoe ke lifeeloana), etsa se latelang ho Notepad:
   • Khetha sebapali sa tab, tobetsa ka ho le letona ho sona, 'me ho menu ea moelelo, tobetsa khopi (Kopitsa), kapa tobetsa feela Ctrl + Cjoalokaha ho bontšitsoe setšoantšong se ka tlase.
   • Press Ctrl + Hho bula lebokose la puisano Sebaka (Fetola) 'me u kenye litlhaku tse kopilitsoeng tšimong hore (Fumana eng). Tabeng ena, sesupa se tla fallela ka ho le letona - sena se bolela hore tlhaku ea tabo e kenngoa. Tšimong Than (Fetola sebaka ka) kenya phegelwana ebe o tobetsa Tlosa kaofela (Fetola tsohle).

   Ho Notepad, sephetho e tla ba ntho e kang ena:

   

5. Click faele > Boloka joalo (Faele > Boloka e le), kenya lebitso bakeng sa faele le lenaneng la ho theoha Ho ngodisa (Encoding) khetha UTF-8… Ebe o tobetsa konopo Save (Boloka).
6. Qala Windows Explorer 'me u fetole katoloso ea faele ho tloha .TXT on . Csv.Fetola katoloso ka tsela e fapaneng .TXT on . Csv U ka e etsa ka kotloloho ho Notepad. Ho etsa sena, ka lebokoseng la puisano Boloka joalo (Boloka joalo ka) tšimong Mofuta oa Feshene (Boloka joalo ka mofuta) khetha khetho Lifaele tsohle (Lifaele tsohle), 'me u kenye ".csv" ho lebitso la faele sebakeng se lumellanang, joalokaha ho bontšitsoe setšoantšong se ka tlase.
7. Bula faele ea CSV ho Excel, bakeng sa sena, ho tab faele (Filet) kopanya Open > Litokomane tsa mongolo (Bula > Lifaele tsa mongolo) 'me u hlahlobe hore na data e lokile.

Hlokomela: Haeba faele ea hau e reretsoe ho sebelisoa ka ntle ho Excel le sebopeho sa UTF-8 ke tlhokahalo, joale u se ke ua etsa liphetoho leha e le life ho lakane 'me u se ke ua e boloka hape ho Excel, kaha sena se ka lebisa mathateng a ho bala khouto. Haeba karolo e itseng ea data e sa bontšoe ho Excel, bula faele e tšoanang ho Notepad 'me u lokise lintlha tse ho eona. Se ke oa lebala ho boloka faele ka sebopeho sa UTF-8 hape.

Mokhoa oa ho fetolela faele ea Excel ho CSV UTF-16

Ho romela ka ntle ho faele ea UTF-16 CSV ho potlakile ebile ho bonolo ho feta ho romela ho UTF-8. Taba ke hore Excel e sebelisa sebopeho sa UTF-16 ka bo eona ha o boloka faele joalo ka mongolo oa unicode (Mongolo oa Unicode).

Ho etsa sena, boloka faele u sebelisa sesebelisoa Boloka joalo (Boloka e le) ho Excel ebe ho Windows Explorer, fetola katoloso ea faele e entsoeng ho . Csv. E entsoe!

Haeba o hloka faele ea CSV e nang le semicolon kapa semicolon e le delimiter, tlosa litlhaku tsohle tsa li-tab ka liphegelwana kapa li-semicolon ka ho latellana ho Notepad kapa mohlophisi ofe kapa ofe oa mongolo oa khetho ea hau (bona pejana sengolong sena bakeng sa litaelo tse felletseng tsa ho etsa sena).

Mekhoa e meng ea ho fetolela lifaele tsa Excel ho CSV

Mekhoa e hlalositsoeng ka holimo ea ho romela data ho tloha Excel ho ea ho CSV (UTF-8 le UTF-16) ke ea bokahohle, ke hore, e loketse ho sebetsa le litlhaku tse khethehileng le phetolelong efe kapa efe ea Excel ho tloha 2003 ho isa 2013.

Ho na le mekhoa e meng e mengata ea ho fetolela data ho tloha Excel ho ea ho sebopeho sa CSV. Ho fapana le litharollo tse bontšitsoeng ka holimo, mekhoa ena e ke ke ea fella ka faele e hloekileng ea UTF-8 (sena ha se sebetse ho OpenOffice, e ka khonang ho romela lifaele tsa Excel ka likhetho tse 'maloa tsa UTF). Empa maemong a mangata, faele e hlahisoang e tla ba le sete e nepahetseng ea litlhaku, e ka fetoloang ntle le bohloko ho sebopeho sa UTF-8 ho sebelisa mohlophisi ofe kapa ofe oa mongolo.

Fetolela Excel File ho CSV U sebelisa Google Sheets

Ha e le hantle, ho bonolo haholo ho fetolela faele ea Excel ho CSV u sebelisa Google Sheets. Ha feela Google Drive e se e kentsoe komporong ea hau, latela mehato ena e 5 e bonolo:

1. Ho Google Drive tobetsa konopo Create (Etsa) ebe u khetha Lethathamo (Spreadsheet).
2. Ho menu faele (Filet) kopanya Kenya (Ikantle).
3. Click Download (Kenya) ebe u khetha faele ea Excel eo u tla e kenya khomphuteng ea hau.
4. Ka lebokoseng la puisano impfile ort (Import faele) khetha Tlosa tafole (Fetola spreadsheet) ebe o tobetsa Kenya (Ikantle).

Keletso: Haeba faele ea Excel e batla e le nyane, joale ho boloka nako, o ka fetisetsa data ho eona ho ea ho Google spreadsheet o sebelisa kopi / paste.

5. Ho menu faele (Filet) kopanya Kenya hape (Khoasolla joalo ka), khetha mofuta oa faele CSV – faele tla bolokoa khomphuteng.

Qetellong, bula faele ea CSV e hlahisitsoeng ho mohlophisi ofe kapa ofe oa mongolo ho etsa bonnete ba hore litlhaku tsohle li bolokiloe ka nepo. Ka bomalimabe, lifaele tsa CSV tse entsoeng ka tsela ena ha se kamehla li hlahang ka nepo ho Excel.

Boloka faele ea .xlsx joalo ka .xls ebe u e fetolela ho faele ea CSV

Mokhoa ona ha o hloke litlhaloso tse eketsehileng, kaha ntho e 'ngoe le e' ngoe e se e hlakile ho tsoa lebitsong.

Ke fumane tharollo ena ho e 'ngoe ea liforomo tse inehetseng ho Excel, ha ke hopole hore na ke efe. Ho bua 'nete, ha ke e-s'o sebelise mokhoa ona, empa ho ea ka basebelisi ba bangata, litlhaku tse ling tse khethehileng lia lahleha ha li boloka ka ho toba. . Xlsx в . Csv, empa u lule u le pele . Xlsx pholosa joalo .xls, ebe joale joaloka . Csv, joalokaha re entse qalong ea sehlooho sena.

Leha ho le joalo, leka mokhoa ona oa ho iketsetsa lifaele tsa CSV ho Excel bakeng sa hau, 'me haeba o sebetsa, e tla ba nako e ntle ea ho boloka nako.

Ho boloka faele ea Excel joalo ka CSV u sebelisa OpenOffice

OpenOffice ke mohloli o bulehileng oa lits'ebetso tse kenyelletsang sesebelisoa sa spreadsheet se etsang mosebetsi o motle oa ho romela data ho tloha Excel ho ea ho CSV. Ebile, sesebelisoa sena se u fa monyetla oa ho fumana likhetho tse ngata ha u fetolela li-spreadsheet ho lifaele tsa CSV (encoding, delimiters, joalo-joalo) ho feta Excel le Google Sheets li kopantsoe hammoho.

Bula feela faele ea Excel ho OpenOffice Calc, tobetsa faele > Boloka joalo (Faele > Boloka e le) ebe o kgetha mofuta wa faele Mongolo oa CSV (Mongolo oa CSV).

Mohato o latelang ke ho khetha litekanyetso tsa parameter Ho ngodisa (Lihlopha tsa batho) le Searohanyi sa masimo (Sehlopha sa sebaka). Ehlile, haeba re batla ho theha faele ea UTF-8 CSV e nang le likoma joalo ka li-delimiters, khetha UTF-8 ebe o kenya phegelwana (,) dibakeng tse loketseng. Paramethara Se arola mongolo (Delimiter ea mongolo) hangata e siuoa e sa fetohe - matšoao a qotso (“). Tlanya e latelang OK.

Ka mokhoa o ts'oanang, bakeng sa phetoho e potlakileng le e se nang bohloko ho tloha Excel ho ea ho CSV, o ka sebelisa sesebelisoa se seng - LibreOffice. Lumellana, ho ka ba monate haeba Microsoft Excel e fana ka bokhoni ba ho fetola litlhophiso ha u theha lifaele tsa CSV.

Sehloohong sena, ke buile ka mekhoa eo ke e tsebang ka ho fetolela lifaele tsa Excel ho CSV. Haeba u tseba mekhoa e sebetsang hantle ea ho romella kantle ho naha ho tloha Excel ho ea ho CSV, ka kopo re bolelle ka eona maikutlong. Ke leboha tlhokomelo!