Cov nuj nqis sib cais (CSV) cov ntaub ntawv muaj cov ntaub ntawv los ntawm lub rooj hauv cov ntawv yooj yim. Txawm hais tias CSV cov ntaub ntawv tuaj yeem qhib nrog cov kws kho kab ntawv, cov ntaub ntawv uas lawv muaj yog qhov zoo tshaj plaws saib siv daim ntawv teev npe. Vim tias CSV cov ntaub ntawv siv hom ntawv tshwj xeeb, tsuas yog txoj hauv kev kom ntseeg tau tias lawv tso tawm kom raug yog kom lawv siv cov txheej txheem tshwj xeeb. Qhov wikiHow qhia koj li cas kom xa cov ntaub ntawv CSV rau hauv Microsoft Excel, Google Sheets, thiab OpenOffice Calc.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Microsoft Excel
Kauj Ruam 1. Qhib Microsoft Excel ntawm koj lub computer
Nws yuav nyob hauv koj lub Windows ntawv qhia zaub mov (PC) lossis koj daim ntawv thov nplaub tshev (Mac).
- Txoj hauv kev yooj yim los qhib CSV cov ntaub ntawv yog nyem Qhib ntawm lub vijtsam txais tos, xaiv koj cov ntaub ntawv CSV, thiab tom qab ntawd nyem Qhib. Txawm li cas los xij, qhov no yuav tsis tso tawm cov ntaub ntawv hauv CSV raws li tau npaj tseg. Ua raws li txoj hauv kev no txhawm rau qhib koj li ntaub ntawv CSV yam tsis tau poob qhov ua tiav thiab lwm cov ntaub ntawv.
Kauj Ruam 2. Nyem Daim Npav Ua Haujlwm
Nws nyob hauv ntu nruab nrab.
Kauj Ruam 3. Nyem rau Cov Ntaub Ntawv tab
Nws yog nyob rau sab saum toj ntawm Excel.
Kauj Ruam 4. Nyem Los Ntawm Ntawv
Nws nyob rau sab laug ntawm qhov toolbar. Qhov no qhib qhov Ntshuam qhov rai.
Kauj Ruam 5. Xaiv cov ntawv CSV thiab nyem Ntshuam
Qhov no nthuav tawm Cov Ntawv Ntsuas Ntsuas Wizard, uas tso cai rau koj hloov kho cov ntaub ntawv xa mus rau hauv Excel.
Kauj Ruam 6. Xaiv Delimited
Nws yog thawj qhov kev xaiv nyob rau kaum sab laug ntawm lub qhov rais.
Kauj Ruam 7. Nyem Tom ntej no mus ntxiv
Kauj Ruam 8. Txheeb lub thawv tom ntej no "Comma
"Yog tias muaj lwm yam khoom raug tshuaj xyuas hauv ntu" Delimiters ", tshem cov cim tam sim no.
Kauj Ruam 9. Nyem Tom ntej no mus ntxiv
Kauj Ruam 10. Xaiv tag nrho cov kab hauv kev saib ua ntej
Nov yog li cas:
- Nyem lub taub hau ntawm thawj kab ntawv los xaiv nws.
- Scroll mus rau kab ntawv kawg siv cov scrollbar yog tias nws tsis pom.
- Tuav cia Ua haujlwm qhov tseem ceeb thaum koj nyem kab lus kawg lub taub hau. Tam sim no txhua kab tau raug xaiv.
Kauj Ruam 11. Xaiv Cov Ntawv raws li kab ntawv cov ntaub ntawv
Qhov no yog nyob rau kaum kaum sab saud.
Kauj Ruam 12. Nyem Tiav
Tam sim no koj yuav pom koj cov ntaub ntawv CSV yam tsis muaj kev hloov pauv pauv rau nws hom ntawv.
Txoj Kev 2 ntawm 3: Google Ntawv
Kauj Ruam 1. Mus rau
Yog tias koj twb tau kos npe rau hauv koj tus lej Google, qhov no yuav tso tawm Google Cov Ntawv, pub dawb Google lwm txoj hauv kev rau Excel. Yog tias tsis yog, ua raws cov lus qhia ntawm lub vijtsam kom nkag mus tam sim no.
- Google Ntawv yog pub dawb, tab sis koj yuav tsum muaj Google account rau nws. Yog tias koj tsis muaj Google account, nyem Tsim Account thiab ua raws cov lus qhia ntawm lub vijtsam kom tsim ib qho tam sim no.
Kauj ruam 2. Nyem +
Nws yog ntau yam xim ntxiv rau kos npe rau ntawm kaum sab laug ntawm nplooj ntawv. Qhov no tsim cov ntawv Sheets dawb.
Kauj Ruam 3. Nyem rau File menu
Nws yog nyob rau sab saum toj-sab laug ntawm Sheets.
Kauj Ruam 4. Nyem Ntshuam
Lub qhov rai "Ntshuam ntaub ntawv" yuav qhib.
Kauj Ruam 5. Nyem rau Upload tab
Nov yog lub tab koj yuav xav tau txhawm rau rub cov ntawv los ntawm koj lub computer.
Kauj Ruam 6. Xaiv lossis rub cov ntawv
Koj tuaj yeem rub cov ntawv CSV mus rau nruab nrab ntawm lub thawv ntawv kom pib rub tawm, lossis nyem Xaiv cov ntaub ntawv los ntawm koj lub cuab yeej xaiv nws los ntawm koj lub computer.
- Yog koj pom xiav Xaiv khawm nyob rau hauv qab-kaum ces kaum tom qab xaiv koj cov ntawv, nyem nws mus txuas ntxiv.
Kauj Ruam 7. Xaiv Hloov daim ntawv nthuav qhia ntawm lub qhov rai "Ntshuam ntaub ntawv"
Yog tias nws twb tau xaiv lawm, koj tuaj yeem tso nws ib leeg.
Kauj Ruam 8. Xaiv Comma hauv qab "Separator type
Qhov no qhia rau Sheets kom siv tus lej cim ua tus cais, uas yog qhov tseem ceeb rau CSV cov ntaub ntawv.
Kauj Ruam 9. Xaiv Tsis yog hauv qab "Hloov cov ntawv rau tus lej, hnub tim, thiab cov qauv
Qhov no tiv thaiv Sheets los ntawm kev hloov cov ntsiab lus ntawm cov ntaub ntawv thaum lub sijhawm ntshuam.
Kauj ruam 10. Nyem rau ntsuab Ntshuam cov ntaub ntawv khawm
Qhov no ntshuam CSV rau hauv cov ntawv raws li nws tau npaj siab pom.
Txoj Kev 3 ntawm 3: OpenOffice Calc
Kauj Ruam 1. Rub tawm OpenOffice los ntawm OpenOffice Calc
Yog tias koj tsis muaj Microsoft Office thiab xav txhim kho ib qho app hauv koj lub computer ntau dua li siv Google Sheets, OpenOffice Calc yog qhov zoo tshaj plaws pub dawb. Tsuas yog xaiv koj lub operating system los ntawm cov ntawv qhia zaub mov nco thiab nyem Rub tawm, tom qab ntawd khiav lub installer. Tsuas yog app hauv chav suite koj yuav xav tau cov ntaub ntawv CSV yog Calc, yog li nco ntsoov xaiv qhov ntawd. Xav tias dawb los nruab ib qho ntawm lwm qhov software suav nrog.
Kauj Ruam 2. Qhib OpenOffice Calc
Thaum koj tau teeb tsa lub software, koj yuav pom Calc hauv koj lub Windows cov ntawv qhia zaub mov (PC) lossis Cov Ntawv Thov (Mac).
Kauj Ruam 3. Nyem rau File menu thiab xaiv Qhib
Cov ntawv qhia zaub mov no yog nyob rau sab laug sab sauv thiab yuav qhib lub qhov rai txhawm rau nrhiav cov ntaub ntawv hauv koj lub computer.
Kauj Ruam 4. Xaiv Cov Ntawv CSV hauv "Ntawv hom" ntawv qhia zaub mov
Koj yuav tsum tau nyem me ntsis hauv cov npe kom pom nws.
Kauj Ruam 5. Xaiv cov ntawv CSV thiab nyem Qhib
Qhov no qhib qhov "Text Import" screen.
Kauj Ruam 6. Xaiv lub pob "Separate By" lub xov tooj cua
Qhov no nyob hauv qab "Cov Kev Xaiv cais" lub taub hau.
Kauj Ruam 7. Xaiv lub thawv "Comma"
Qhov no qhia Calc kom siv tus lej cim hauv CSV cov ntaub ntawv txhawm rau txheeb xyuas txhua kab.
Kauj ruam 8. Nyem OK
Cov ntsiab lus ntawm koj li ntaub ntawv CSV yuav tshwm tam sim no hauv Calc.
