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: Nrhiav Txoj Kev Hlub EP.4 2024, Tej zaum
Anonim

CSV lossis "comma cais qhov tseem ceeb" cov ntaub ntawv tso cai rau koj khaws cov ntaub ntawv hauv cov qauv txheej txheem uas muaj txiaj ntsig zoo thaum koj xav tau los tswj cov chaw khaws ntaub ntawv loj. CSV cov ntaub ntawv tuaj yeem tsim siv Microsoft Excel, OpenOffice Calc, Google Spreadsheets, thiab Notepad.

Kauj ruam

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

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 Spreadsheets

Yog tias koj xav hloov koj daim ntawv teev npe tam sim no rau hauv CSV hom, hla mus rau qib plaub

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

Kauj Ruam 2. Ntaus txhua kab lus npe lossis npe rau hauv cov thawv hauv kab 1 nyob rau sab saud ntawm daim ntawv ua haujlwm

Piv txwv li, yog tias koj xav nkag mus rau cov ntaub ntawv rau cov khoom muag, ntaus "Yam Khoom Lub Npe" hauv lub thawv A1, "Cov Khoom Nqe" hauv lub thawv B1, "Cov Lus Qhia Khoom" hauv lub thawv C1, thiab ntxiv rau.

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

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

Nrog qhov piv txwv piav qhia hauv theem ob, sau lub npe ntawm cov khoom hauv lub thawv A2, tus nqi ntawm yam khoom hauv lub thawv B2, thiab cov lus piav qhia hauv lub thawv C2.

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

Kauj Ruam 4. Nyem rau “File” menu thiab xaiv “Save As” tom qab nkag mus rau tag nrho cov ntaub ntawv ntawm daim ntawv nthuav qhia

Yog tias koj siv Google Ntawv, qhov kev xaiv los xaiv yog "Cov Ntaub Ntawv> Rub Tawm Raws Li".

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

Kauj Ruam 5. Xaiv "CSV" los ntawm "Save as type" drop-down menu

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

Kauj Ruam 6. Ntaus lub npe ntawm cov ntaub ntawv CSV, tom qab ntawd xaiv "Txuag"

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

Txoj Kev 2 ntawm 2: Siv Notepad

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

Kauj Ruam 1. Tua Notepad thiab ntaus cov npe ntawm kab sib cais los ntawm tus lej ntawm kab thawj

Piv txwv li, yog tias koj xav nkag mus rau cov ntaub ntawv rau cov khoom muag, ntaus cov ntawv hauv qab no rau hauv kab thawj ntawm daim ntawv: "npe, nqe, piav qhia." Nco ntsoov tias yuav tsum tsis muaj qhov nruab nrab ntawm txhua kab npe.

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

Kauj Ruam 2. Ntaus cov ntaub ntawv hauv kab thib ob siv tib hom ntawv raws li cov npe kab hauv kab ua ntej

Nrog tus piv txwv piav qhia hauv qib ib, sau lub npe ntawm yam khoom raug muag, ua raws tus nqi thiab piav qhia ntawm yam khoom. Piv txwv, yog tias koj muag cov ncuav qab zib, ntaus "biscuits, 10,000, khoom noj txom ncauj."

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

Kauj Ruam 3. Khaws nkag mus rau cov ntaub ntawv rau txhua qhov khoom hauv kab hauv qab no

Yog tias muaj cov teb uas koj xav tawm ntawm qhov khoob, nco ntsoov tias koj khaws tus lej. Txwv tsis pub, lwm kab ntawv yuav tsis tshwm vim tias ib kab ntawv tsis muaj dab tsi.

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

Kauj Ruam 4. Nyem rau “File” menu 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 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 “Txuag”

Tam sim no koj tau ua tiav tsim CSV cov ntaub ntawv ntawm Notepad.

Pom zoo: