Yuav hloov ua lwm yam ntaub ntawv Excel rau CSV hom li cas

CSV (Comma Separated Values) yog ib hom kev khaws cia cov ntaub ntawv (tus lej thiab ntawv) hauv cov ntawv dawb. Cov ntaub ntawv hom ntawv no yog nrov thiab enduring vim hais tias ib tug lossis loj tus naj npawb ntawm cov kev pab cuam thiab cov ntawv thov nkag siab CSV, yam tsawg kawg yog lwm hom ntaub ntawv rau ntshuam / export. Ntxiv mus, CSV hom tso cai rau tus neeg siv los saib rau hauv cov ntaub ntawv thiab tam sim ntawd pom muaj teeb meem nrog cov ntaub ntawv, yog tias muaj, hloov CSV delimiter, quoting cov cai, thiab lwm yam. Qhov no ua tau vim tias CSV yog cov ntawv nyeem yooj yim, thiab txawm tias tus neeg siv tsis tau paub dhau los tuaj yeem nkag siab yooj yim yam tsis muaj kev cob qhia tshwj xeeb.

Hauv tsab xov xwm no, peb yuav kawm sai thiab muaj txiaj ntsig txoj hauv kev xa tawm cov ntaub ntawv los ntawm Excel rau CSV thiab kawm paub hloov cov ntaub ntawv Excel rau CSV yam tsis muaj kev cuam tshuam tag nrho cov cim tshwj xeeb thiab txawv teb chaws. Cov txheej txheem tau piav qhia hauv tsab xov xwm ua haujlwm hauv txhua yam ntawm Excel 2013, 2010 thiab 2007.

• Hloov cov ntaub ntawv los ntawm Excel rau CSV hom
• Export los ntawm Excel rau CSV UTF-8 lossis UTF-16 hom
• Lwm txoj hauv kev los hloov ntawm Excel rau CSV ( khaws cia cov cim tshwj xeeb)

Yuav hloov ua lwm yam ntaub ntawv Excel rau CSV li cas

Yog tias koj xav xa cov ntaub ntawv Excel mus rau lwm daim ntawv thov, xws li phau ntawv chaw nyob Outlook lossis Access database, ua ntej hloov daim ntawv Excel mus rau CSV cov ntaub ntawv, thiab tom qab ntawd import cov ntaub ntawv. . Csv mus rau lwm daim ntawv thov. Cov hauv qab no yog ib kauj ruam los ntawm kauj ruam qhia yuav ua li cas xa tawm Excel phau ntawv rau CSV hom siv Excel cuab yeej - "Txuag li".

1. Hauv phau ntawv Excel, qhib lub tab cov ntaub ntawv (Cov ntaub ntawv) thiab nyem Txuag li (Txuag li). Tsis tas li ntawd, lub dialog box Txuag ib daim ntawv (Txuag li) tuaj yeem qhib los ntawm nias tus yuam sij F12.
2. Nyob rau hauv lub Cov Ntaub Ntawv Hom (Txuag li hom) xaiv CSV (sib cais los ntawm commas) (CSV (Comma delimited)).Ntxiv rau CSV (comma delimited), ob peb lwm CSV hom kev xaiv muaj:
   • CSV (sib cais los ntawm commas) (CSV (Comma delimited)). Cov hom ntawv no khaws cov ntaub ntawv Excel ua cov ntawv cim cim cim cim thiab tuaj yeem siv rau hauv lwm daim ntawv thov Windows thiab nyob rau hauv ib qho txawv version ntawm Windows operating system.
   • CSV (Macintosh). Hom ntawv no txuag tau phau ntawv ua haujlwm Excel ua cov ntaub ntawv comma delimited rau siv ntawm Mac operating system.
   • CSV (MS DOS). Txuag ib phau ntawv ua haujlwm Excel ua cov ntaub ntawv comma-delimited rau siv hauv MS-DOS operating system.
   • unicode ntawv (Unicode Text (*txt)). Cov qauv no tau txais kev txhawb nqa los ntawm yuav luag txhua qhov kev khiav haujlwm uas twb muaj lawm, suav nrog Windows, Macintosh, Linux, thiab Solaris Unix. Nws txhawb cov cim los ntawm yuav luag txhua yam niaj hnub thiab txawm tias qee yam lus qub. Yog li, yog tias Excel phau ntawv ua haujlwm muaj cov ntaub ntawv ua lus txawv teb chaws, kuv xav kom koj ua ntej khaws nws hauv hom ntawv unicode ntawv (Unicode Text (*txt)), thiab tom qab ntawd hloov mus rau CSV raws li tau piav qhia tom qab hauv Export los ntawm Excel rau UTF-8 lossis UTF-16 CSV hom.

Nco ntsoov: Txhua yam hais tawm tsuas yog khaws cov ntawv Excel ua haujlwm xwb.

3. Xaiv ib lub nplaub tshev kom txuag tau cov ntaub ntawv CSV thiab nyem Txuag (Txuag). Tom qab nias Txuag (Txuag) ob lub thawv dialog yuav tshwm sim. Tsis txhob txhawj, cov lus no tsis qhia qhov yuam kev, yog li nws yuav tsum ua.
4. Thawj lub dialog box qhia koj tias Tsuas yog daim ntawv tam sim no tuaj yeem khaws cia hauv cov ntaub ntawv ntawm hom xaiv (Cov ntaub ntawv xaiv tsis txhawb cov phau ntawv ua haujlwm uas muaj ntau nplooj ntawv). Txhawm rau txuag daim ntawv tam sim no, tsuas yog nias OK.Yog tias koj xav khaws tag nrho cov nplooj ntawv ntawm phau ntawv, ces nyem kev tshem tawm (Xa tseg) thiab khaws tag nrho cov nplooj ntawv ntawm phau ntawv ib tus zuj zus nrog cov npe cov ntaub ntawv tsim nyog, lossis koj tuaj yeem xaiv khaws lwm hom ntaub ntawv uas txhawb nqa ntau nplooj ntawv.
5. Tom qab txhaj OK nyob rau hauv thawj lub dialog box, ib tug thib ob yuav tshwm sim, ceeb toom tias ib co nta yuav ua tsis tau vim lawv tsis txaus siab los ntawm CSV hom. Qhov no yog li cas nws yuav tsum tau, yog li cia li nias Yog (Yog).

Qhov no yog li cas Excel daim ntawv ua haujlwm tuaj yeem khaws cia ua cov ntaub ntawv CSV. Ceev thiab yooj yim, thiab tsis tshua muaj teeb meem tuaj yeem tshwm sim ntawm no.

Export los ntawm Excel rau CSV nrog UTF-8 lossis UTF-16 encoding

Yog tias daim ntawv Excel muaj cov cim tshwj xeeb lossis txawv teb chaws (tilde, accent, thiab lwm yam) lossis hieroglyphs, ces hloov daim ntawv Excel rau CSV raws li tau piav qhia saum toj no yuav tsis ua haujlwm.

Lub ntsiab lus yog tias pab neeg Txuag li > CSV (Txuag li> CSV) yuav mangle tag nrho cov cim tshwj tsis yog ASCII (American Standard Code for Information Interchange). Thiab yog hais tias muaj ob nqe lus los yog ntev dashes nyob rau hauv Excel daim ntawv (hloov mus rau Excel, piv txwv li, los ntawm ib lo lus ntawv thaum luam / pasting ntawv nyeem) - cov cim no kuj yuav shredded.

Kev daws yooj yim - Txuag Excel Sheet li Text File Unicode (txt), thiab ces hloov nws mus rau CSV. Ua li no, tag nrho cov cim tsis yog ASCII yuav nyob twj ywm.

Ua ntej yuav mus, cia kuv piav me ntsis txog qhov sib txawv tseem ceeb ntawm UTF-8 thiab UTF-16 encodings, yog li ntawd nyob rau hauv txhua rooj plaub koj tuaj yeem xaiv hom ntawv tsim nyog:

• UTF-8 yog ib tug ntau compact encoding uas siv 1 mus rau 4 bytes rau txhua tus cim. Nws feem ntau pom zoo kom siv hom ntawv no thaum ASCII cov cim tseem ceeb hauv cov ntaub ntawv, vim tias feem ntau ntawm cov cim no xav tau 1 byte ntawm lub cim xeeb. Lwm qhov zoo dua yog tias qhov encoding ntawm UTF-8 cov ntaub ntawv uas muaj cov cim ASCII nkaus xwb yuav tsis txawv ntawm ib qho ntawm cov ntaub ntawv ASCII.
• UTF-16 siv 2 mus rau 4 bytes khaws txhua tus cim. Thov nco ntsoov tias tsis yog nyob rau hauv txhua rooj plaub UTF-16 cov ntaub ntawv xav tau ntau qhov chaw nco dua li UTF-8 cov ntaub ntawv. Piv txwv li, cov cim Japanese siv li 3 txog 4 bytes hauv UTF-8 thiab 2 txog 4 bytes hauv UTF-16. Yog li, nws tsim nyog siv UTF-16 yog tias cov ntaub ntawv muaj cov cim Asian, suav nrog Nyij Pooj, Suav, thiab Kauslim. Lub ntsiab tsis zoo ntawm qhov encoding no yog tias nws tsis tau tag nrho nrog ASCII cov ntaub ntawv thiab yuav tsum tau tshwj xeeb cov kev pab cuam los tso saib cov ntaub ntawv. Nco ntsoov qhov no yog tias koj npaj yuav import cov ntaub ntawv los ntawm Excel lwm qhov.

Yuav ua li cas Hloov Excel ntaub ntawv rau CSV UTF-8

Piv txwv tias peb muaj ib daim ntawv Excel nrog cov cim txawv teb chaws, hauv peb qhov piv txwv lawv yog cov npe Japanese.

Txhawm rau xa daim ntawv Excel no mus rau CSV cov ntaub ntawv, thaum khaws tag nrho cov hieroglyphs, peb yuav ua cov hauv qab no:

1. Hauv Excel, qhib lub tab cov ntaub ntawv (Cov ntaub ntawv) thiab nyem Txuag li (Txuag li).
2. Sau cov npe ntawm cov ntaub ntawv hauv daim teb Cov Ntaub Ntawv Hom (Txuag li hom) xaiv unicode ntawv (Unicode Text (*.txt)) thiab nias Txuag (Txuag).
3. Qhib cov ntaub ntawv tsim nyob rau hauv cov ntawv sau tus qauv, xws li Notepad.

Nco ntsoov: Tsis yog txhua tus kws kho cov ntawv nyeem yooj yim txhawb nqa cov cim Unicode, yog li qee qhov yuav tshwm sim ua duab plaub. Feem ntau, qhov no yuav tsis cuam tshuam rau cov ntaub ntawv zaum kawg hauv txhua txoj kev, thiab koj tuaj yeem tsis quav ntsej nws lossis xaiv tus kws kho mob siab dua, xws li Notepad ++.

4. Txij li thaum peb cov ntaub ntawv Unicode siv cov cim tab raws li tus lej delimiters, thiab peb xav hloov nws mus rau CSV (comma delimited), peb yuav tsum hloov cov cim tab nrog commas.

Nco ntsoov: Yog tias tsis muaj qhov xav tau nruj kom tau txais cov ntaub ntawv nrog tus lej cim cais, tab sis koj xav tau cov ntaub ntawv CSV uas Excel tuaj yeem nkag siab, cov kauj ruam no tuaj yeem hla, txij li Microsoft Excel nkag siab zoo txog cov ntaub ntawv nrog delimiter - tabulation.

4. Yog tias koj tseem xav tau cov ntaub ntawv CSV (sib cais los ntawm commas), tom qab ntawd ua cov hauv qab no hauv Notepad:
   • Xaiv lub cim tab, right-click rau nws, thiab hauv cov ntawv qhia zaub mov, nyem Copy (Copy), los yog cia li nias Ctrl + Craws li qhia hauv daim duab hauv qab no.
   • Xovxwm Ctrl + Hqhib lub dialog box Hloov chaw (Hloov) thiab muab tshuaj txhuam cov cim tab rau hauv daim teb uas (Nrhiav dab tsi). Hauv qhov no, tus cursor yuav txav mus rau sab xis - qhov no txhais tau hais tias lub cim tab raug tso. Hauv teb tshaj (Hloov nrog) nkag mus rau lub cim thiab nias Hloov tag nrho (Hloov tag nrho).

   Hauv Notepad, qhov tshwm sim yuav yog qee yam zoo li no:

   

5. Nyem cov ntaub ntawv > Txuag li (Cov ntaub ntawv> Txuag li), sau lub npe rau cov ntaub ntawv thiab hauv daim ntawv teev npe Encoding (Encoding) xaiv UTF-8… Ces nias lub pob Txuag (Txuag).
6. Tua tawm Windows Explorer thiab hloov cov ntaub ntawv txuas ntxiv los ntawm .txt on . Csv.Hloov extension txawv .txt on . Csv Koj tuaj yeem ua nws ncaj qha hauv Notepad. Txhawm rau ua qhov no, hauv dialog box Txuag li (Txuag li) hauv daim teb Cov Ntaub Ntawv Hom (Txuag li hom) xaiv ib qho kev xaiv Txhua cov ntaub ntawv (Tag nrho cov ntaub ntawv), thiab ntxiv ".csv" rau cov ntaub ntawv npe nyob rau hauv cov teb, raws li qhia hauv daim duab hauv qab no.
7. Qhib cov ntaub ntawv CSV hauv Excel, rau qhov no, ntawm lub tab cov ntaub ntawv (Filet) knead Qhib > Cov ntawv luam tawm (Qhib> Cov ntaub ntawv ntawv) thiab xyuas seb cov ntaub ntawv puas zoo.

Nco ntsoov: Yog tias koj cov ntaub ntawv yog npaj los siv sab nraud ntawm Excel thiab UTF-8 hom ntawv yog qhov yuav tsum tau ua, tsis txhob hloov pauv rau daim ntawv thiab tsis txhob khaws nws dua hauv Excel, vim qhov no yuav ua rau muaj teeb meem nrog kev nyeem ntawv encoding. Yog tias qee qhov ntawm cov ntaub ntawv tsis tshwm sim hauv Excel, qhib tib cov ntaub ntawv hauv Notepad thiab kho cov ntaub ntawv hauv nws. Tsis txhob hnov ​​​​qab khaws cov ntaub ntawv hauv UTF-8 hom dua.

Yuav ua li cas Hloov Excel ntaub ntawv rau CSV UTF-16

Kev xa tawm mus rau UTF-16 CSV cov ntaub ntawv sai dua thiab yooj yim dua li xa tawm mus rau UTF-8. Qhov tseeb yog tias Excel cia li siv UTF-16 hom ntawv thaum koj khaws cov ntaub ntawv li unicode ntawv (Unicode Text).

Ua li no, txuag cov ntaub ntawv siv lub cuab yeej Txuag li (Txuag li) hauv Excel thiab tom qab ntawd hauv Windows Explorer, hloov qhov txuas ntxiv ntawm cov ntaub ntawv tsim rau . CsvCov. Ua li cas!

Yog tias koj xav tau CSV cov ntaub ntawv nrog ib lub cim lossis lub cim cim raws li tus lej, hloov tag nrho cov cim tab nrog commas lossis semicolons feem hauv Notepad lossis lwm cov ntawv sau uas koj xaiv (saib ua ntej hauv kab lus no kom ntxaws cov lus qhia yuav ua li cas).

Lwm txoj hauv kev los hloov cov ntaub ntawv Excel rau CSV

Cov txheej txheem tau piav qhia saum toj no rau kev xa tawm cov ntaub ntawv los ntawm Excel rau CSV (UTF-8 thiab UTF-16) yog universal, piv txwv li tsim nyog rau kev ua haujlwm nrog cov cim tshwj xeeb thiab hauv ib qho version ntawm Excel los ntawm 2003 txog 2013.

Muaj ntau ntau txoj hauv kev los hloov cov ntaub ntawv los ntawm Excel rau CSV hom. Tsis zoo li cov kev daws teeb meem saum toj no, cov txheej txheem no yuav tsis ua rau cov ntaub ntawv ntshiab UTF-8 (qhov no tsis siv rau OpenOffice, uas tuaj yeem xa tawm Excel cov ntaub ntawv hauv ntau UTF encoding xaiv). Tab sis feem ntau, cov ntaub ntawv uas tau tshwm sim yuav muaj cov cim raug teeb tsa, uas tuaj yeem hloov pauv tsis zoo rau UTF-8 hom siv cov ntawv nyeem.

Hloov cov ntaub ntawv Excel rau CSV Siv Google Sheets

Raws li nws hloov tawm, nws yooj yim heev los hloov cov ntaub ntawv Excel rau CSV siv Google Sheets. Muab tias Google Drive twb tau teeb tsa hauv koj lub computer, ua raws li 5 kauj ruam yooj yim no:

1. Hauv Google Drive nyem lub pob tsim (Tsim) thiab xaiv rooj (Spreadsheet).
2. Ntawm cov ntawv qhia zaub mov cov ntaub ntawv (Filet) knead Ntshuam (Ntshuam).
3. Nyem download (Upload) thiab xaiv Excel cov ntaub ntawv upload los ntawm koj lub computer.
4. Nyob rau hauv lub dialog box Impua ort (Ntshuam cov ntaub ntawv) xaiv Hloov lub rooj (Hloov daim ntawv nthuav dav) thiab nyem Ntshuam (Ntshuam).

Tswv yim: Yog tias Excel cov ntaub ntawv me me, ces kom txuag tau sijhawm, koj tuaj yeem hloov cov ntaub ntawv los ntawm nws mus rau Google spreadsheet siv luam / paste.

5. Ntawm cov ntawv qhia zaub mov cov ntaub ntawv (Filet) knead Download tau li (Download li), xaiv hom ntaub ntawv CSV - Cov ntaub ntawv yuav raug cawm hauv lub computer.

Thaum kawg, qhib CSV cov ntaub ntawv tsim tawm hauv cov ntawv nyeem kom paub tseeb tias txhua tus cim tau raug cawm kom raug. Hmoov tsis zoo, CSV cov ntaub ntawv tsim los ntawm txoj kev no tsis tas yuav tso tawm kom raug hauv Excel.

Txuag .xlsx cov ntaub ntawv ua .xls thiab tom qab ntawd hloov mus rau CSV cov ntaub ntawv

Txoj kev no tsis xav tau cov lus qhia ntxiv, vim tias txhua yam twb paub meej los ntawm lub npe.

Kuv pom qhov kev daws teeb meem no ntawm ib lub rooj sab laj rau Excel, Kuv tsis nco qab qhov twg. Yuav kom ncaj ncees, kuv yeej tsis tau siv txoj kev no, tab sis raws li ntau tus neeg siv, qee cov cim tshwj xeeb tau ploj thaum txuag ncaj qha los ntawm . Xlsx в . Csv, tab sis nyob twj ywm yog ua ntej . Xlsx txuag tau li .xl ua, thiab tom qab ntawd nyiam . Csv, raws li peb tau ua thaum pib ntawm tsab xov xwm no.

Xijpeem, sim cov qauv no ntawm kev tsim CSV cov ntaub ntawv los ntawm Excel rau koj tus kheej, thiab yog tias nws ua haujlwm, nws yuav yog lub sijhawm zoo.

Txuag cov ntaub ntawv Excel li CSV siv OpenOffice

OpenOffice yog qhov qhib qhov chaw ntawm cov ntawv thov uas suav nrog daim ntawv teev npe uas ua haujlwm zoo ntawm kev xa tawm cov ntaub ntawv los ntawm Excel rau CSV hom. Qhov tseeb, daim ntawv thov no muab rau koj nkag mus rau ntau txoj kev xaiv thaum hloov cov ntawv xa mus rau CSV cov ntaub ntawv (encoding, delimiters, thiab lwm yam) dua li Excel thiab Google Sheets muab tso ua ke.

Tsuas yog qhib Excel cov ntaub ntawv hauv OpenOffice Calc, nyem cov ntaub ntawv > Txuag li (Cov ntaub ntawv> Txuag li) thiab xaiv hom ntaub ntawv CSV text (Text CSV).

Cov kauj ruam tom ntej yog xaiv cov nqi parameter Encoding (Character sets) thiab Teb cais (Field delimiter). Tau kawg, yog tias peb xav tsim cov ntaub ntawv UTF-8 CSV nrog commas li delimiters, ces xaiv UTF-8 thiab sau ib qho comma (,) hauv cov teb uas tsim nyog. Parameter Text separator (Text delimiter) feem ntau yog tshuav tsis hloov - cov lus hais (“). Tom ntej no nyem OK.

Ib yam li ntawd, kom hloov pauv sai thiab tsis mob los ntawm Excel rau CSV, koj tuaj yeem siv lwm daim ntawv thov - LibreOffice. Pom zoo, nws yuav zoo yog tias Microsoft Excel muab lub peev xwm los kho qhov chaw thaum tsim cov ntaub ntawv CSV.

Hauv tsab xov xwm no, kuv tau tham txog txoj hauv kev uas kuv paub txog kev hloov cov ntaub ntawv Excel rau CSV. Yog tias koj paub ntau txoj hauv kev zoo rau kev xa tawm ntawm Excel rau CSV, thov qhia peb txog nws hauv cov lus. Ua tsaug rau koj mloog!