CSV (Comma-Separated Values) yog cov qauv ntaub ntawv uas tau tsim los tsim cov ntaub ntawv tabular. Hauv qhov xwm txheej no, cov kem raug sib cais los ntawm ib kab thiab ib kab lus ncua. Nrhiav kom paub nrog cov ntawv thov twg koj tuaj yeem qhib hom ntawv no.
Cov haujlwm pabcuam rau kev ua haujlwm nrog CSV
Raws li txoj cai, rooj txheej txheem siv tau los siv kom pom cov ntsiab lus CSV kom raug, thiab cov neeg kho kho lus kuj tseem siv tau los kho lawv. Cia peb saib ze lub algorithm ntawm kev ua thaum muaj ntau cov kev pab cuam qhib cov hom ntaub ntawv no.
Txoj Kev 1: Microsoft Excel
Cia peb pom yuav ua li cas khiav CSV hauv qhov nrov Excel lo lus, uas tau suav nrog chav Microsoft Office.
- Tua tawm Excel. Mus rau hauv lub tab Cov ntaub ntawv.
- Mus rau cov ntawv no, nyem "Qhib".
Hloov chaw ntawm cov haujlwm no, koj tuaj yeem thov ncaj qha rau daim ntawv Ctrl + O.
- Lub qhov rais tawm "Qhib daim ntawv"Cov. Siv nws taw rau qhov chaw CSV nyob. Nco ntsoov xaiv los ntawm daim ntawv teev cov hom ntawv Ntawv Cov Ntaub Ntawv lossis "Txhua cov ntaub ntawv"Cov. Txwv tsis pub, cov hom ntawv uas xav tau tsuas yog tsis ua kom pom. Tom qab ntawv cim qhov khoom tau muab thiab nias "Qhib"uas yuav ua rau "Tus tswv ntawm cov ntawv".
Muaj lwm txoj hauv kev mus "Tus tswv ntawm cov ntawv".
- Tsiv mus rau seem "Cov ntaub ntawv"Cov. Nyem rau ntawm qhov khoom "Los ntawm cov ntawv nyeem"muab tso rau hauv thaiv "Tau cov ntaub ntawv sab nraud".
- Tuam tshwm Cov Ntawv Ntshuam Ntaub NtawvCov. Tib yam li nyob hauv lub qhov rai "Qhib daim ntawv", ntawm no koj yuav tsum mus rau thaj chaw thaj tsam ntawm cov khoom thiab kos cim nws. Koj tsis tas yuav xaiv cov hom ntawv, vim tias thaum siv cov cuab yeej no, cov khoom yuav muaj cov ntawv sau tawm. Nyem "Ntshuam".
- Pib li "Tus tswv ntawm cov ntawv"Cov. Hauv nws thawj lub qhov rai "Qhia cov hom ntaub ntawv" teeb lub xov tooj cua khawm Sib caisCov. Hauv cheeb tsam "Cov hom ntaub ntawv" yuav tsum muaj parameter Unicode (UTF-8)Cov. Xov Xwm "Tom ntej".
- Tam sim no nws yog qhov tsim nyog los ua cov kauj ruam tseem ceeb, uas qhov tseeb ntawm cov ntaub ntawv cov ntaub ntawv yuav nyob ntawm. Nws yog qhov yuav tsum tau los sau dab tsi raws nraim pom tau tias yog kev sib cais: semicolon (;) lossis comma (,). Qhov tseeb yog tias nyob hauv ntau lub teb chaws cov qauv sib txawv tau siv rau hauv qhov no. Yog li, rau cov lus Askiv, ib tus comma feem ntau siv, thiab rau cov ntawv hauv Lavxias-lus Askiv, lub suab lus. Tab sis muaj kev zam thaum pawg sib cais siv nyob rau hauv rov qab. Tsis tas li ntawd, hauv qee qhov xwm txheej tsis tshua pom, lwm cov cim raug siv los ua tus txiav, xws li cov kab laim laim (~).
Vim li no, tus neeg siv yuav tsum txiav txim siab saib qhov xwm txheej tshwj xeeb yog cim dab tsi lossis cim cov cim kom raug. Nws tuaj yeem ua qhov no los ntawm saib cov ntawv nyeem uas tshwm hauv thaj chaw. "Cov ntaub ntawv piv txwv ua pov thawj" thiab raws li qhov tseeb.
Tom qab tus neeg siv txiav txim siab txog tus cwj pwm twg yog lub cais hauv pawg "Tus yam ntxwv cais yog" xaiv lub thawv tom ntej Semicolon lossis CommaCov. Lub thawv ntawv yuav tsum rho tawm txhua lwm yam khoom. Tom qab ntawd nyem "Tom ntej".
- Tom qab ntawd, lub qhov rais qhib rau qhov twg, hais txog ib kem tshwj xeeb hauv cheeb tsam "Cov ntaub ntawv piv txwv ua pov thawj", koj tuaj yeem muab nws ua hom ntawv rau kev qhia kom raug ntawm cov ntaub ntawv hauv block Kem Qhia Cov Qauv Ntaub Ntawv los ntawm kev hloov lub xov tooj cua khawm ntawm txoj haujlwm:
- hla kab ntawv;
- ntseeg cuav
- Hnub Tim
- ntau.
Tom qab ua tiav kev tswj hwm, nias Ua li cas.
- Lub qhov rai zoo li nug txog qhov twg cov ntaub ntawv yuav tsum tau ntsauv yog nyob rau ntawm daim ntawv. Los ntawm kev hloov cov xov tooj cua hauv xov tooj cua, koj tuaj yeem ua qhov no ntawm daim ntawv tshiab lossis qub. Nyob rau hauv rooj plaub tom kawg, koj tuaj yeem hais qhia qhov chaw nyob ncaj qha hauv cov lus coj. Txhawm rau kom tsis txhob nkag rau lawv tus kheej, nws txaus los tso tus cursor hauv daim teb no thiab tom qab ntawd xaiv lub cell ntawm daim ntawv uas yuav dhau los ua cov khoom sib txuas sab saud hauv qhov array uas cov ntaub ntawv yuav raug ntxiv. Tom qab teeb tsa cov kev sib koom tes, nyem "OK".
- Cov ntsiab lus ntawm lub npes pom ntawm daim ntawv Excel.
Zaj lus qhia: Yuav ua li cas khiav CSV hauv Excel
Txoj Kev 2: LibreOffice Calc
Lwm lub rooj ua haujlwm tuaj yeem khiav CSV - Calc, uas yog ib feem ntawm LibreOffice lub rooj sib txoos.
- Tshaj tawm LibreOffice. Nyem "Qhib cov ntaub ntawv" lossis siv Ctrl + O.
Koj tseem tuaj yeem mus hauv cov ntawv qhia zaub mov los ntawm nias Cov ntaub ntawv thiab "Qhib ...".
Tsis tas li ntawd, lub qhov rai qhib kuj tseem tuaj yeem nkag ncaj qha los ntawm Calc interface. Txhawm rau ua qhov no, thaum nyob hauv LibreOffice Calc, nyem rau ntawm kab ntawv “folder” lossis hom Ctrl + O.
Lwm qhov kev xaiv cuam tshuam nrog kev hloov pauv ntawm cov ntsiab lus Cov ntaub ntawv thiab "Qhib ...".
- Siv ib qho ntawm ntau txoj kev xaiv tau teev tseg yuav ua rau lub qhov rai ua haujlwm "Qhib"Cov. Txav nws mus rau qhov chaw ntawm CSV, khij nws thiab nias "Qhib".
Tab sis koj tuaj yeem ua txawm tias tsis tau khiav lub qhov rai "Qhib"Cov. Txhawm rau ua qhov no, rub CSV tawm "Explorer" hauv LibreOffice.
- Tuam tshwm Ntawv Ntshuam Ntawvua ib qho analog "Phau Ntawv Masters" hauv Excel. Qhov kom zoo dua yog tias qhov no koj tsis tas yuav tsiv ntawm lub qhov rai sib txawv, ua cov chaw ntshuam nkag, txij li txhua qhov tsim nyog yuav tsum nyob rau hauv ib lub qhov rais.
Mus ncaj qha rau pawg pab pawg "Ntshuam"Cov. Hauv cheeb tsam "Rho Tawm" xaiv tus nqi Unicode (UTF-8)yog tias muaj lwm yam teeb meem nyob ntawd. Hauv cheeb tsam "Lus" xaiv hom lus ntawm cov ntawv nyeem. Hauv cheeb tsam "Los ntawm kab" koj yuav tsum qhia kom meej txoj kab twg uas yuav tsum tau pib qhov tseem ceeb ntawm cov ntsiab lus. Feem ntau, qhov no tsis tas yuav tsum tau hloov pauv.
Tom ntej no, mus rau cov pab pawg Separator XaivCov. Ua ntej tshaj plaws, koj yuav tsum teeb tsa lub xov tooj cua Kev sib caisCov. Ntxiv mus, raws li tib lub hauv paus ntsiab lus uas tau txiav txim siab thaum siv Excel, koj yuav tsum qhia kom meej, los ntawm khij lub npov nyob ib sab ntawm ib yam khoom, dab tsi xyov yuav ua lub luag haujlwm ntawm kev sib cais: semicolon lossis comma.
"Lwm txoj kev xaiv" tawm tsis hloov pauv.
Koj tuaj yeem pom ua ntej dab tsi raws nraim cov ntaub ntawv txawv teb zoo li thaum hloov qee qhov chaw, tom qab ntawm lub qhov rais. Tom qab nkag mus rau txhua qhov tsis tsim nyog, nias "OK".
- Cov ntsiab lus yuav raug tso tawm kom pom los ntawm LibreOffice Kalk interface.
Txoj Kev 3: OpenOffice Calc
Koj tuaj yeem saib CSV uas siv lwm tus txheej txheem lub rooj - OpenOffice Calc.
- Qhib Ua Haujlwm OpenOffice. Ntawm qhov rai tseem ceeb, nyem "Qhib ..." lossis siv Ctrl + O.
Koj tseem tuaj yeem siv cov ntawv qhia zaub mov. Txhawm rau ua qhov no, mus dhau cov khoom Cov ntaub ntawv thiab "Qhib ...".
Ib yam li cov qauv nrog cov txheej txheem yav dhau los, koj tuaj yeem mus rau lub hom phiaj qhib qhov rai ncaj qha los ntawm Kalk interface. Hauv qhov no, koj yuav tsum nias ntawm lub ntsiab lus hauv cov duab ntawm cov ntawv tais ceev tseg lossis siv tib yam Ctrl + O.
Koj tseem tuaj yeem siv cov ntawv qhia zaub mov los ntawm mus rau txoj haujlwm nyob hauv. Cov ntaub ntawv thiab "Qhib ...".
- Hauv kev qhib qhov rai uas zoo nkaus li, mus rau CSV qhov chaw thaj chaw, xaiv qhov khoom no thiab nyem "Qhib".
Koj tuaj yeem ua yam tsis tau tua lub qhov rai no los ntawm tsuas yog txav lub CSV ntawm "Explorer" hauv OpenOffice.
- Ib qho ntawm ntau cov yeeb yam tau piav qhia yuav ua rau kev ua kom muaj lub qhov rais qhib. Ntawv Ntshuam Ntawv, uas yog qhov sib xws heev ntawm ob qho tib si hauv kev pom thiab hauv kev ua haujlwm rau lub cuab tam nrog tib lub npe hauv LibreOffice. Raws li, ua tib qho yeeb yam. Hauv daim teb "Rho Tawm" thiab "Lus" raug Unicode (UTF-8) thiab cov lus ntawm daim ntawv tam sim no, ntsig txog.
Ntawm kev thaiv Separator tsis dhau muab xov tooj cua khawm ze rau qhov khoom Kev sib cais, tom qab ntawv khij ntawm lub npov nyob ze (Semicolon lossis Comma) uas phim cov sib cais ntawm cov hom hauv cov ntawv.
Tom qab ua cov kauj ruam no, yog tias cov ntaub ntawv hauv daim foos saib ua ntej pom hauv qab ntawm lub qhov rai raug tso tawm kom raug, nyem "OK".
- Cov ntaub ntawv yuav ua tiav zoo ntawm OpenOffice Kalk interface.
Txoj Kev 4: Notepad
Txog kev kho, koj tuaj yeem siv Daim Ntawv Sau Ntawv ib txwm.
- Tshaj Tawm Cov Phoo Ntawv. Hauv daim ntawv qhia zaub mov, nyem Cov ntaub ntawv thiab "Qhib ..."Cov. Lossis koj tuaj yeem thov Ctrl + O.
- Lub qhov rooj qhib qhib. Mus rau hauv nws rau CSV qhov chaw cheeb tsam. Hauv cov hom ntawv tso saib teb, teeb tus nqi "Txhua cov ntaub ntawv"Cov. Khij qhov khoom koj tab tom nrhiav. Tom qab ntawv nias "Qhib".
- Lub hom phiaj yuav qhib, tab sis, tau kawg, tsis nyob hauv daim ntawv tab uas peb tau pom hauv cov txheej txheem rooj, tab sis hauv cov ntawv nyeem ib. Txawm li cas los xij, hauv phau ntawv sau nws yooj yim los kho 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 haum rau ib kab ntawm cov lus hauv Notepad, thiab cov kem tau sib cais los ntawm sib cais nyob rau hauv daim ntawv ntawm commas lossis semicolons. Muab cov ntaub ntawv no, koj tuaj yeem yooj yim kho txhua qhov kev hloov kho rau kuv, cov ntawv sau nqi, ntxiv kab, tshem tawm lossis ntxiv cov cais thaum tsim nyog.
Txoj Kev 5: Notepad ++
Koj tuaj yeem qhib nws nrog cov ntawv nyeem ntau dua - Notepad ++.
- Tig los ntawm Notepad ++. Nyem rau ntawm daim ntawv qhia zaub mov Cov ntaub ntawvCov. Tom ntej no xaiv "Qhib ..."Cov. Koj tuaj yeem thov Ctrl + O.
Lwm qhov kev xaiv yuav cia li nyem rau ntawm lub icon vaj huam sib luag rau hauv daim ntawv ntawm daim nplaub tshev.
- Lub qhov rooj qhib qhib. Nws yog qhov tsim nyog yuav tsum tsiv mus rau thaj chaw ntawm cov ntaub ntawv qhov chaw uas xav tau CSV nyob. Tom qab xaiv nws, nias "Qhib".
- Cov ntsiab lus yuav tshwm sim hauv Notepad ++. Cov ntsiab lus kho yog tib yam li thaum siv Notepad, tab sis Notepad ++ muab ntau qhov ntau ntawm cov cuab yeej siv rau ntau cov ntaub ntawv siv.
Txoj Kev 6: Safari
Koj tuaj yeem saib cov ntsiab lus hauv cov ntawv nyeem tsis muaj qhov hloov kho nws hauv qhov browser browser. Feem ntau lwm cov browsers nrov tsis muab cov yam ntxwv no.
- Tua tawm Safari. Nyem Cov ntaub ntawvCov. Tom ntej no nyem "Qhib cov ntaub ntawv ...".
- Lub qhov rooj qhib qhib. Nws yuav tsum tau tsiv mus rau qhov chaw uas CSV tau nyob, uas tus neeg siv xav mus saib. Yuav tsum tau hom hloov nyob rau hauv lub qhov rai yuav tsum tau teeb tsa "Txhua cov ntaub ntawv"Cov. Tom qab ntawv xaiv cov khoom nrog CSV txuas ntxiv thiab nyem "Qhib".
- Cov ntsiab lus ntawm cov khoom yuav qhib rau hauv lub qhov rai tshiab Safari hauv ntawv, raws li nws tau nyob hauv Notepad. Muaj tseeb, tsis zoo li Notepad, kho cov ntaub ntawv hauv Safari, hmoov tsis, yuav tsis ua haujlwm, vim koj tsuas tuaj yeem pom nws nkaus xwb.
Txoj Kev 7: Microsoft Outlook
Qee qhov khoom CSV yog email xa tawm los ntawm ib tus neeg siv email. Lawv tuaj yeem raug saib siv Microsoft txheej txheem kev pabcuam los ntawm kev ua cov txheej txheem ntshuam.
- Tua Tawm Outlook. Tom qab qhib qhov program, mus rau ntawm lub tab Cov ntaub ntawvCov. Tom qab ntawd nyem "Qhib" nyob rau ntawm daim ntawv qhia zaub mov sab. Tom ntej no nyem "Ntshuam".
- Pib li "Ntshuam thiab Export Wizard"Cov. Hauv cov ntawv teev npe, xaiv "Ntshuam los ntawm lwm qhov program lossis ntaub ntawv"Cov. Xov Xwm "Tom ntej".
- Ntawm lub qhov rais tom ntej no, xaiv cov hom khoom los ntshuam khoom. Yog tias peb tab tom yuav import CSV, tom qab ntawd koj yuav tsum xaiv txoj haujlwm "Comma Separated Values (Windows)"Cov. Nyem "Tom ntej".
- Ntawm qhov rais tom ntej, nyem "Ntsuam xyuas ...".
- Lub qhov rais tawm "Txheej txheem cej luam"Cov. Nws yuav tsum mus rau qhov chaw uas ntawv yog CSV hom. Ntaus cim rau cov khoom no thiab nyem "OK".
- Muaj qhov rov qab los rau ntawm qhov rais "Ntshuam thiab Export Wizards"Cov. Raws li koj tuaj yeem pom, hauv thaj chaw "Cov ntaub ntawv mus rau import" Ib qho chaw nyob tau ntxiv rau qhov chaw nyob ntawm CSV khoom. Ntawm kev thaiv "Xaiv" nqis yuav nyob ua lub neej ntawd. Nyem "Tom ntej".
- Tom qab ntawd koj yuav tsum kos tus cim rau hauv lub thawv xa ntawv qhov twg koj xav tso tus ntawv xov xwm sib txawv.
- Lub qhov rais tom ntej no qhia lub npe ntawm qhov kev ua uas ua los ntawm qhov kev zov me nyuam. Tsuas nyem rau ntawm no Ua li cas.
- Tom qab ntawd, txhawm rau saib cov ntaub ntawv txawv teb, mus rau ntawm lub tab "Xa thiab txais"Cov. Ntawm thaj chaw ib sab ntawm lub program interface, xaiv daim nplaub tshev uas cov xov tau ntshuam. Tom qab ntawd nyob rau hauv nruab nrab ntawm qhov kev pab cuam ib daim ntawv teev cov npe nyob hauv phau ntawv no yuav tshwm sim. Nws yog qhov txaus los ua ob npaug nias rau ntawm daim ntawv xav tau nrog sab laug nas.
- Daim ntawv xa tuaj ntawm CSV khoom yuav raug qhib hauv qhov kev pab cuam Outlook.
Muaj tseeb, nws tsim nyog sau cia tias txoj kev no koj tuaj yeem khiav kom deb ntawm txhua qhov CSV hom khoom, tab sis tsuas yog cov ntawv uas nws cov qauv ua tau raws li ib qho qauv, uas yog muaj cov teb: cov ntawv kawm, ntawv nyeem, chaw nyob xa ntawv, chaw txais neeg, thiab lwm yam.
Raws li koj tuaj yeem pom, muaj ntau ntau cov kev pabcuam rau kev qhib cov hom phiaj CSV. Raws li txoj cai, nws yog qhov zoo tshaj plaws los saib cov khoom ntawm cov ntaub ntawv xws li hauv cov rooj txheej txheem. Kev hloov kho tuaj yeem ua raws li kab lus hauv cov zaj nyeem. Ib qho ntxiv, nyias muaj nyias CSV nrog cov qauv tshwj xeeb, uas cov kev pabcuam tshwjxeeb ua haujlwm, piv txwv li, email rau cov neeg siv khoom.
