Yuav Tsim Li Cas CSV Cov Ntaub Ntawv: 12 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Tsim Li Cas CSV Cov Ntaub Ntawv: 12 Kauj Ruam (nrog Duab)
Yuav Tsim Li Cas CSV Cov Ntaub Ntawv: 12 Kauj Ruam (nrog Duab)

Video: Yuav Tsim Li Cas CSV Cov Ntaub Ntawv: 12 Kauj Ruam (nrog Duab)

Video: Yuav Tsim Li Cas CSV Cov Ntaub Ntawv: 12 Kauj Ruam (nrog Duab)
Video: Tu tus kheej lis cas thaum muaj me nyuam thiaj zoo Nkauj! 2024, Plaub Hlis Ntuj
Anonim

Cov ntaub ntawv CSV, uas yog "cov cim cais cais" cov ntaub ntawv, tso cai rau koj khaws koj cov ntaub ntawv hauv cov txheej txheem txheej txheem rooj, uas muaj txiaj ntsig zoo thaum koj xav tau los tswj cov ntaub ntawv loj. CSV cov ntaub ntawv tuaj yeem tsim siv Microsoft Excel, OpenOffice Calc, Google Sheets, thiab Notepad.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Microsoft Excel, OpenOffice Calc, thiab Google Sheets

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 1
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv tshiab hauv Microsoft Excel, OpenOffice Calc, lossis Google Sheets

Yog tias koj xav hloov daim ntawv nthuav tawm uas twb muaj lawm rau CSV, hla mus rau qib #4

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 2
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 2

Kauj Ruam 2. Ntaus txhua tus ntawm koj lub taub hau, lossis cov npe teb rau hauv cov cell nyob hauv kab 1 nyob rau sab saum toj ntawm daim ntawv nthuav tawm

Piv txwv, yog tias nkag mus rau cov ntaub ntawv rau cov khoom koj tab tom muag, ntaus "Yam Lub Npe" rau hauv cell A1, "Yam Nqe" rau hauv cell B1, "Yam Khoom Qhia" rau hauv cell C1, thiab ntxiv rau.

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 3
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 3

Kauj Ruam 3. Sau koj cov ntaub ntawv rau hauv daim ntawv nthuav qhia hauv qab txhua kab ntawv raws li xav tau

Siv tus piv txwv teev tseg hauv qib #2, sau cov npe khoom hauv cell A2, tus nqi khoom hauv cell B2, thiab cov khoom piav qhia hauv cell C2.

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 4
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 4

Kauj Ruam 4. Nyem rau "Cov Ntaub Ntawv" thiab xaiv "Txuag Raws Li" tom qab koj tau nkag mus rau txhua cov ntaub ntawv rau hauv daim ntawv nthuav tawm

Yog tias siv Google Ntawv, qhov kev xaiv no yuav nyeem ua "File> Download as."

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 5
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 5

Kauj Ruam 5. Xaiv "CSV" hauv qab "Save as type" dropdown menu

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 6
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 6

Kauj Ruam 6. Ntaus lub npe rau koj li ntaub ntawv CSV, tom qab ntawd xaiv "Txuag

Tam sim no koj tau tsim CSV cov ntaub ntawv, thiab tus lej cim cim cia yuav tau ntxiv rau hauv cov ntawv cais txhua qhov chaw.

Txoj Kev 2 ntawm 2: Notepad

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 7
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 7

Kauj Ruam 1. Tua Notepad thiab ntaus koj cov npe lub npe sib cais los ntawm tus lej rau kab thib ib

Piv txwv, yog tias nkag mus rau cov ntaub ntawv rau cov khoom koj tab tom muag, ntaus cov hauv qab no mus rau thawj kab: "npe, nqe, piav qhia." Yuav tsum tsis muaj qhov chaw nruab nrab ntawm cov khoom.

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 8
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 8

Kauj Ruam 2. Ntaus koj cov ntaub ntawv mus rau kab thib ob, siv tib hom ntawv zoo li koj cov npe hauv kab thawj kab

Siv qhov piv txwv tau teev tseg hauv qib #1, sau lub npe yam khoom tiag, ua raws cov khoom nqe thiab kev piav qhia. Piv txwv, yog tias muag baseball, sau "baseball, 5.99, ncaws pob."

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 9
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 9

Kauj Ruam 3. Txuas ntxiv koj cov ntaub ntawv rau txhua tus neeg yam khoom mus rau txhua kab tom ntej

Yog tias tawm hauv ib qho chaw uas tsis muaj dab tsi, xyuas kom tseeb tias koj suav nrog tus lej, lossis thaj chaw uas seem yuav tawm los ntawm ib qho.

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 10
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 10

Kauj Ruam 4. Nyem rau “File” thiab xaiv “Save

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 11
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 11

Kauj Ruam 5. Ntaus lub npe rau koj cov ntaub ntawv thiab xaiv ".csv" los ntawm cov ntawv qhia zaub mov nco qab txuas ntxiv

Tsim CSV Cov Ntaub Ntawv Kauj Ruam 12
Tsim CSV Cov Ntaub Ntawv Kauj Ruam 12

Kauj Ruam 6. Nyem rau “Txuag

Tam sim no koj tau tsim CSV cov ntaub ntawv hauv Notepad.

Pom zoo: