CSV (Comma-Separated Values) yog cov ntaub ntawv tso tawm uas tsim los qhia cov ntaub ntawv tabular. Hauv qhov no, txhua kab yog sib cais los ntawm ib qho vias thiab ib semicolon. Peb kawm, nrog kev pab los ntawm cov kev pab cuam uas koj tuaj yeem qhib hom ntawv no.
Cov kev pab rau kev ua haujlwm nrog CSV
Raws li txoj cai, tabular processors yuav siv los saib cov CSV cov lus kom raug, thiab cov ntawv kho kom raug siv los kho lawv. Cia siv sij hawm saib lub sijhawm ntawm cov txheej txheem thaum qhib cov kev pabcuam ntawm hom ntaub ntawv no.
Method 1: Microsoft Excel
Xav seb yuav ua li cas khiav CSV nyob rau hauv nrov Excel lo lus processor, uas yog muaj nyob hauv Microsoft Office suite.
- Khiav Excel. Nias lub tab "Cov Ntaub Ntawv".
- Mus rau qhov tab, nyem "Qhib".
Siv cov kev ua no, koj tuaj yeem thov rau ntawm daim ntawv. Ctrl + O.
- Lub qhov rais tshwm "Qhib Cov Ntaub Ntawv". Siv nws tsiv mus rau qhov chaw CSV nyob qhov twg. Nco ntsoov xaiv los ntawm daim ntawv teev cov nqi tawm tswv yim "Cov Ntaub Ntawv Sau" los yog "Txhua Ntaub Ntawv". Txwv tsis pub, lub hom phiaj yog tsuas yog tsis tso tawm. Tom qab ntawd khij qhov khoom no thiab nias "Qhib"uas yuav ua rau "Master Text".
Muaj lwm txoj kev mus rau "Master Text".
- Tsiv mus rau seem "Cov ntaub ntawv". Nias ntawm qhov khoom "Los ntawm cov ntawv nyeem"muab tso rau hauv ib lub block "Qhia lwm cov ntaub ntawv".
- Tuam pom tshwm "Hloov cov ntawv nyeem". Cia li zoo li nyob rau hauv lub qhov rais "Qhib Cov Ntaub Ntawv", ntawm no koj yuav tsum mus rau thaj chaw ntawm qhov khoom thiab cim nws. Tsis tas yuav tsum xaiv cov hom ntawv, txij thaum siv cov cuab yeej no, cov khoom uas muaj cov ntawv nyeem yuav muab tso tawm kom pom. Nyem "Ntshuam".
- Pib pib "Master Text". Hauv nws lub qhov rais ua ntej "Txheeb xyuas cov hom ntaub ntawv" muab lub xov tooj cua khawm hauv txoj hauj lwm "Delimited". Hauv thaj chaw "Ua Ntawv Thov" yuav tsum muaj ib qho parameter "Unicode (UTF-8)". Nias "Tom ntej".
- Tam sim no koj yuav tsum ua ib qho tseem ceeb heev, uas yuav txiav txim siab qhov tseeb ntawm cov ntaub ntawv qhia. Nws yuav tsum tau qhia kom meej tias qhov kev txiav txim twg yog qhov sib cais: semicolon (;) lossis comma (,). Qhov tseeb yog tias nyob rau ntau lub teb chaws hauv txoj kev npaj no txawv ntawm cov qauv. Yog li, tus vev thwm ib txwm siv rau cov ntawv Askiv, thiab ib semicolon yog siv rau cov ntawv hais lus Lavxias. Tab sis muaj qee qhov tshwj xeeb thaum cov kev txiav txim siab siv lwm txoj kev. Ntxiv rau, feem ntau tsis tshua muaj tshwm sim, lwm cov cim qhia yog siv cov cais, piv txwv, ib kab kab laum (~).
Yog li ntawd, tus neeg siv nws tus kheej yuav tsum tsim kom muaj nyob rau hauv qhov no qhov tshwj xeeb yog tus cwj pwm ua hauj lwm raws li lub ntsiab lus lossis qhov cim sau cwj pwm. Nws tuaj yeem ua qhov no los ntawm saib cov ntawv nyeem uas tshwm nyob rau hauv "Sample data parsing" thiab raws li logic.
Tom qab tus neeg siv txiav txim siab uas yog tus cwj pwm yog cais, hauv pawg "Tus cwj pwm tsis zoo yog" khij lub npov ntawm ib sab "Semicolon" los yog "Ntsuag". Tag nrho lwm yam khoom yuav tsum tsis kuaj xyuas. Tom qab ntawd nias "Tom ntej".
- Tom qab hais tias lub qhov rais qhib hauv, uas xaiv ib qho kev qhia nyob rau hauv cheeb tsam "Sample data parsing", koj tuaj yeem muab nws tso rau ib qho qauv qhia tseeb ntawm cov ntaub ntawv hauv lub block "Daim Ntawv Qhia Kem" los ntawm kev hloov lub xov tooj cua khawm ntawm cov haujlwm hauv qab no:
- hla kem;
- ntawv nyeem;
- hnub tim;
- hom
Tom qab ua tiav qhov kev tswj xyuas, nias "Ua li cas".
- Lub qhov rais tuaj nug qhov twg raws nraim cov ntaub ntawv ntshuam yuav tsum muab tso rau ntawm daim ntawv. Los ntawm kev hloov xov tooj cua cov nyees khawm, koj tuaj yeem ua qhov no rau ib daim ntawv tshiab los yog muaj. Nyob hauv rooj plaub tom kawg, koj tuaj yeem hais meej txog qhov chaw khiav hauj lwm ntawm qhov chaw nyob rau hauv cov cheeb tsam uas coj los siv. Yuav kom tsis txhob nkag rau lawv tus kheej, nws yog qhov txaus kom muab tus cursor hauv daim teb no, thiab xaiv rau ntawm daim ntawv xovtooj ntawm tes uas yuav ua rau lub sab nraud ntawm qhov array uas cov ntaub ntawv yuav muab ntxiv. Tom qab teeb tsa ib qhov chaw, nias "OK".
- Cov ntsiab lus ntawm tus kwv yog tso tawm kom pom ntawm daim Excel.
Tshooj: Yuav ua li cas khiav CSV hauv Excel
Txoj kev 2: LibreOffice Calc
CSV tseem tuaj yeem khiav lwm lub rooj zaum, Calc, nrog rau lub koom haum LibreOffice.
- Launch LibreOffice. Nyem "Qhib Cov Ntaub Ntawv" lossis siv Ctrl + O.
Koj tuaj yeem taug kev los ntawm cov zaub mov los ntawm kev nias "Cov Ntaub Ntawv" thiab "Qhib ...".
Tsis tas li ntawd, qhib qhov rai tuaj yeem nkag ncaj qha ntawm Calc interface. Ua li no, thaum nyob hauv LibreOffice Calc, nyem rau ntawm lub cim ua ib phau ntawv sau los sis hom Ctrl + O.
Lwm qhov kev xaiv yog los ntawm cov ntsiab lus "Cov Ntaub Ntawv" thiab "Qhib ...".
- Siv cov lus xaiv hauv qab no yuav ua rau lub qhov rais "Qhib". Tshem nws mus rau ntawm qhov chaw CSV, khij nws thiab nias "Qhib".
Tab sis koj tuaj yeem ua tau yam tsis khiav qhov rais "Qhib". Ua li no, rub lub CSV ntawm "Explorer" nyob rau hauv LibreOffice.
- Tuam pom tshwm "Hloov cov ntawv nyeem"ua analog Cov Ntawv Wizards hauv Excel. Qhov zoo dua yog tias qhov no nws tsis yog yuav tsum txav ntawm qhov rais txawv, kev nqis peev uas muaj nqis, txij li tag nrho cov kev tsim nyog tsis muaj nyob hauv ib qhov rai.
Mus ncaj qha mus rau lub koom haum pab pawg "Ntshuam". Hauv thaj chaw "Encoding" xaiv tus nqi "Unicode (UTF-8)"yog hais tias nws qhia txog lwm yam. Hauv thaj chaw "Hais lus" xaiv cov lus ntawv. Hauv thaj chaw "Los ntawm kab" koj yuav tsum qhia kom meej tias qhov twg thiaj li pib hloov cov ntsiab lus. Feem ntau, koj tsis tas yuav hloov mus rau qhov ntsuas no.
Ntxiv mus, mus rau cov pab pawg "Separator Options". Ua ntej tshaj, koj yuav tsum teem lub xov tooj cua khawm rau txoj haujlwm "Separator". Tsis tas li ntawd, raws li tib lub hauv paus ntsiab lus uas tau pom thaum siv Excel, koj yuav tsum qhia kom meej los ntawm khij lub checkbox ntawm lub ntsiab ntawm ib yam khoom xyov yuav ua li cas lub luag hauj lwm ntawm lub separator: semicolon los yog comma.
"Lwm txoj hau kev" tawm mus tsis hloov.
Koj tuaj yeem pom ua ntej raws nraim li cov ntaub ntawv muab xa tuaj thaum twg hloov cov chaw hauv qab ntawm qhov rais. Tom qab nkag mus rau tag nrho cov tsis tsim nyog, nias "OK".
- Cov ntsiab lus yuav muab tso tawm kom pom ntawm LibreOffice Calc interface.
Method 3: OpenOffice Calc
Koj tuaj yeem saib CSV siv lwm cov lus sib sab nraud - OpenOffice Calc.
- Khiav OpenOffice. Nyob rau hauv lub qhov rais loj, nias "Qhib ..." lossis siv Ctrl + O.
Koj tuaj yeem siv tau cov ntawv qhia zaub mov. Ua li no, mus rau hauv cov ntsiab lus "Cov Ntaub Ntawv" thiab "Qhib ...".
Xws li nrog txoj kev nrog rau yav dhau los, koj tuaj yeem tau txais cov khoom qhib qhov rai ncaj qha los ntawm tus Kalk interface. Hauv qhov no, koj yuav tsum nias qhov icon hauv daim duab ntawm daim nplaub tshev los yog siv tag nrho tib yam Ctrl + O.
Koj tuaj yeem siv cov zaub mov los ntawm cov khoom los ntawm cov khoom. "Cov Ntaub Ntawv" thiab "Qhib ...".
- Hauv qhov qhib qhov rai uas tshwm sim, mus rau hauv cheeb tsam chaw CSV, xaiv qhov khoom no thiab nias "Qhib".
Koj yuav ua tau yam tsis muaj kev qhib lub qhov rais los ntawm kev yooj yim dragging ib CSV los ntawm "Explorer" hauv OpenOffice.
- Ib qho ntawm ntau cov kev piav qhia yuav qhib qhov rais. "Hloov cov ntawv nyeem"uas zoo sib xws ob qho tib si hauv tsos thiab hauv kev ua haujlwm rau ib lub cuab yeej nrog tib lub npe nyob hauv LibreOffice. Raws li, qhov kev ua yog raws nraim tib yam. Hauv teb "Encoding" thiab "Hais lus" nthuav tawm "Unicode (UTF-8)" thiab cov lus ntawm daim ntawv qhia tam sim no.
Hauv kev thaiv "Separator Parameters" muab lub xov tooj cua khawm nyob ze ntawm qhov khoom "Separator", ces kos rau lub thawv ntawd khoom ("Semicolon" los yog "Ntsuag"), uas sib sau ua ke rau hom kev tshaj tawm hauv daim ntawv.
Tom qab ua tiav cov lus qhia, yog tias cov ntaub ntawv hauv daim ntawv ua ntej pom tshwm hauv qis sab nraud ntawm lub qhov rais qhia ncaj qha, nyem "OK".
- Cov ntaub ntawv yuav tsum tau tshwm sim ntawm OpenOffice Calc interface.
Method 4: Notepad
Rau kev kho kom haum, koj tuaj yeem siv Daim Ntawv Ceebtoom Npe.
- Pib Sau Ntawv. Nyem ntawm daim ntawv qhia zaub mov "Cov Ntaub Ntawv" thiab "Qhib ...". Los yog koj tuaj yeem thov Ctrl + O.
- Qhov qhib qhov rais qhib. Next rau ntawm thaj chaw CSV. Nyob hauv hom ntawv teb, teev tus nqi "Txhua Ntaub Ntawv". Kos rau yam khoom ntawd. Tom qab ntawd nias "Qhib".
- Tus kwv yuav raug qhib, tab sis, ntawm chav kawm, tsis nyob rau hauv ib daim ntawv tabular, uas peb pom hauv tabular processors, tab sis nyob rau hauv daim ntawv. Txawm li cas los xij, hauv ib phau ntawv nws yooj yim heev los hloov cov khoom ntawm hom ntawv no. Koj tsuas yog yuav tsum tau coj mus rau hauv tus account tias txhua kab ntawm lub rooj sib raug mus rau ib kab ntawv ntawm Notepad, thiab txhua kab yog sib cais los ntawm ib hnub twg los yog sib cais sib cais. Muab cov ntaub ntawv no, koj tuaj yeem yooj yim ua txhua yam kev kho me ntsis, cov ntawv sau nqi kuv, ntxiv cov kab, tshem tawm lossis ntxiv cov cais tawm thaum tsim nyog.
Txoj kev 5: Notepad ++
Koj tuaj yeem qhib nws nrog kev pab los ntawm ntau cov ntawv nyeem editor - Notepad ++.
- Qhib Notepad ++. Nyem ntawm daim ntawv qhia zaub mov "Cov Ntaub Ntawv". Ntxiv mus, xaiv "Qhib ...". Koj tuaj yeem thov tau Ctrl + O.
Lwm qhov kev xaiv yuav tsum tau txhaj rau lub cim vaj huam sib luag nyob rau hauv daim ntawv ntawm ib phau ntawv.
- Qhov qhib qhov rais qhib. Nws yog qhov yuav tsum tau tsiv mus rau thaj tsam ntawm cov ntaub ntawv system qhov twg qhov CSV xav tau. Tom qab xaiv nws, nias "Qhib".
- Cov ntsiab lus yog tso tawm kom pom hauv Notepad ++. Cov qauv ntawm kev kho yog tib yam li nrog Notepad, tab sis Notepad ++ muab ntau ntau cov cuab yeej rau ntau cov ntaub ntawv manipulations.
Txoj kev 6: Safari
Koj tuaj yeem saib cov ntsiab lus nyob rau hauv ib phau ntawv nyeem tsis tau kho nws hauv Safari browser. Feem ntau lwm cov browsers nrov tsis muab qhov feature no.
- Tua tawm Safari. Nyem "Cov Ntaub Ntawv". Tom ntej no, nyem rau ntawm "Qhib cov ntaub ntawv ...".
- Qhov qhib qhov rais qhib. Nws yuav tsum tsiv mus rau qhov chaw uas CSV nyob, uas tus neeg xav pom. Nws yog ib qho yuav tsum tau hloov cov ntaub ntawv hauv lub qhov rais mus "Txhua Ntaub Ntawv". Tom qab ntawd xaiv qhov khoom nrog CSV extension thiab nias "Qhib".
- Tus txheem ntawm qhov khoom yuav qhib rau hauv Safari tshiab qhov rais hauv daim ntawv, raws li nws nyob rau hauv Notepad. Tseeb, tsis zoo li Notepad, editing cov ntaub ntawv hauv Safari, hmoov tsis, yuav tsis ua hauj lwm, vim koj tsuas pom nws.
Txoj kev 7: Microsoft Outlook
Qee cov khoom CSV yog xa tawm xa tawm ntawm tus xa email tuaj. Lawv tuaj yeem saib siv Microsoft Outlook siv txoj cai ntshuam.
- Tawm Tshem tawm. Tom qab qhib lub program, mus rau lub tab "Cov Ntaub Ntawv". Tom qab ntawd nias "Qhib" nyob rau hauv lub sidebar. Tom ntej, nias "Ntshuam".
- Pib pib "Ntshuam thiab Export Wizard". Hauv daim ntawv xaiv tau xaiv "Ntshuam los ntawm lwm txoj haujlwm lossis cov ntaub ntawv". Nias "Tom ntej".
- Hauv qhov rais nram qab no, xaiv hom khoom kwv rau import. Yog tias peb yuav xa cov CSV, ces peb yuav tsum xaiv qhov chaw "Comma Separated Values (Windows)". Nyem "Tom ntej".
- Hauv qhov rais ntxiv, nias "Ntsuam xyuas ...".
- Lub qhov rais tshwm "Txheeb xyuas". Nws yuav tsum mus rau qhov chaw nyob qhov twg tsab ntawv nyob hauv CSV hom ntawv. Kos rau qhov no thiab nias "OK".
- Rov qab mus rau lub qhov rais "Ntshis thiab Export Wizards". Raws li koj tau pom hauv thaj chaw "Cov ntaub ntawv rau import" Ib qhov chaw nyob tau ntxiv rau qhov chaw CSV khoom. Hauv kev thaiv "Kev xaiv" Cov chaw yuav tawm mus ua neej ntawd. Nyem "Tom ntej".
- Tom qab ntawd koj yuav tsum khij lub nplaub tshev hauv chaw xa ntawv uas koj xav tso tus ntawv xa tuaj.
- Daim phiaj tom ntej no qhia txog qhov kev txiav txim uas yuav ua los ntawm qhov kev zov me nyuam. Nws txaus los nias "Ua li cas".
- Tom qab ntawd, mus saib cov ntaub ntawv xa tawm, mus rau lub tab "Xa thiab txais". Nyob rau ntawm ib cheeb tsam ntawm qhov program interface, xaiv lub nplaub tshev uas daim ntawv raug xa mus. Tom qab ntawd hauv feem nrab ntawm qhov kev zov me nyuam yuav pom cov npe ntawm cov tsiaj ntawv nyob hauv daim nplaub tshev. Nws yog txaus rau ob npaug-nias rau ntawm daim ntawv thov nrog tus nas laug khawm.
- Daim ntawv xa tawm ntawm CSV khoom yuav raug qhib rau hauv qhov kev pab tawm.
Nws tseem ceeb teev cia, txawm li cas los xij, tsis yog txhua yam khoom hauv CSV hom yuav khiav ntawm li no, tiam sis tsuas yog cov ntawv uas nws lub tsev ua tau raws li tus qauv, xws li, muaj cov lus teb: nqe, ntawv nyeem, chaw nyob, chaw nyob, thiab lwm yam.
Raws li koj tau pom, muaj ntau cov kev pabcuam los qhib CSV hom khoom. Raws li txoj cai, nws yog qhov zoo tshaj plaws los mus saib cov ntsiab lus ntawm cov ntaub ntawv zoo li hauv cov txheej txheem ntawm cov txheej txheem. Editing yuav ua tau raws li cov ntawv nyeem hauv cov ntawv kho kom raug. Tsis tas li ntawd, muaj cov CSV cais tawm nrog cov qauv, uas ua haujlwm nrog cov kev pabcuam tshwjxeeb, xws li email clients.
