3 Txoj Hauv Kev Yuav Qhib CSV Cov Ntaub Ntawv

Cov txheej txheem:

3 Txoj Hauv Kev Yuav Qhib CSV Cov Ntaub Ntawv
3 Txoj Hauv Kev Yuav Qhib CSV Cov Ntaub Ntawv

Video: 3 Txoj Hauv Kev Yuav Qhib CSV Cov Ntaub Ntawv

Video: 3 Txoj Hauv Kev Yuav Qhib CSV Cov Ntaub Ntawv
Video: yuav coj li cas kom luag nyiam 2024, Lub peb hlis ntuj
Anonim

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

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 1
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 1

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 2
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 2

Kauj Ruam 2. Nyem Daim Npav Ua Haujlwm

Nws nyob hauv ntu nruab nrab.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 3
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 3

Kauj Ruam 3. Nyem rau Cov Ntaub Ntawv tab

Nws yog nyob rau sab saum toj ntawm Excel.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 4
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 4

Kauj Ruam 4. Nyem Los Ntawm Ntawv

Nws nyob rau sab laug ntawm qhov toolbar. Qhov no qhib qhov Ntshuam qhov rai.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 5
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 5

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 6
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 6

Kauj Ruam 6. Xaiv Delimited

Nws yog thawj qhov kev xaiv nyob rau kaum sab laug ntawm lub qhov rais.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 7
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 7

Kauj Ruam 7. Nyem Tom ntej no mus ntxiv

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 8
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 8

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 9
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 9

Kauj Ruam 9. Nyem Tom ntej no mus ntxiv

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 10
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 10

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.
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 11
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 11

Kauj Ruam 11. Xaiv Cov Ntawv raws li kab ntawv cov ntaub ntawv

Qhov no yog nyob rau kaum kaum sab saud.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 12
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 12

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

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 13
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 13

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 14
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 14

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 15
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 15

Kauj Ruam 3. Nyem rau File menu

Nws yog nyob rau sab saum toj-sab laug ntawm Sheets.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 16
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 16

Kauj Ruam 4. Nyem Ntshuam

Lub qhov rai "Ntshuam ntaub ntawv" yuav qhib.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 17
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 17

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 18
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 18

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 19
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 19

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 20
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 20

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 21
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 21

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 22
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 22

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

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 23
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 23

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 24
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 24

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).

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 25
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 25

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 26
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 26

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 27
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 27

Kauj Ruam 5. Xaiv cov ntawv CSV thiab nyem Qhib

Qhov no qhib qhov "Text Import" screen.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 28
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 28

Kauj Ruam 6. Xaiv lub pob "Separate By" lub xov tooj cua

Qhov no nyob hauv qab "Cov Kev Xaiv cais" lub taub hau.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 29
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 29

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.

Qhib CSV Cov Ntaub Ntawv Kauj Ruam 30
Qhib CSV Cov Ntaub Ntawv Kauj Ruam 30

Kauj ruam 8. Nyem OK

Cov ntsiab lus ntawm koj li ntaub ntawv CSV yuav tshwm tam sim no hauv Calc.

Pom zoo: