Yuav Hloov Li Cas Excel Cov Ntaub Ntawv Rau Hauv DAT Cov Ntaub Ntawv (nrog Duab)

Cov txheej txheem:

Yuav Hloov Li Cas Excel Cov Ntaub Ntawv Rau Hauv DAT Cov Ntaub Ntawv (nrog Duab)
Yuav Hloov Li Cas Excel Cov Ntaub Ntawv Rau Hauv DAT Cov Ntaub Ntawv (nrog Duab)

Video: Yuav Hloov Li Cas Excel Cov Ntaub Ntawv Rau Hauv DAT Cov Ntaub Ntawv (nrog Duab)

Video: Yuav Hloov Li Cas Excel Cov Ntaub Ntawv Rau Hauv DAT Cov Ntaub Ntawv (nrog Duab)
Video: Saib Mis paub Poj niam (hluas nkauj) tus yam ntxwv lub siab 2024, Plaub Hlis Ntuj
Anonim

Qhov wikiHow qhia koj yuav hloov Microsoft Excel (. XLS) cov ntaub ntawv mus rau. DAT hom ntawm lub khoos phis tawj Windows. Koj yuav tsum hloov pauv. XLS cov ntaub ntawv mus rau. CSV (cov cim sib cais qhov tseem ceeb) hom ua ntej, tom qab ntawd hloov nws mus rau. DAT cov ntaub ntawv los ntawm daim ntawv thov zoo li Notepad.

Kauj ruam

Ntu 1 ntawm 2: Hloov Cov Ntaub Ntawv Excel Rau Hauv. CSV Cov Ntaub Ntawv

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 1
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel

Daim ntawv thov no nyob hauv pab pawg thov " Microsoft Office "nyob rau hauv lub segment" Txhua Apps "Ntawm" Windows "/" Start "menu.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 2
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 2

Kauj ruam 2. Nyem rau File menu

Nws nyob rau sab saum toj-sab laug ntawm qhov screen.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 3
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 3

Kauj Ruam 3. Nyem Qhib

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 4
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 4

Kauj ruam 4. Nyem rau cov ntawv koj xav hloov

Cov ntaub ntawv yuav qhib hauv Excel qhov rai.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 5
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 5

Kauj Ruam 5. Nyem rau File menu

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 6
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 6

Kauj Ruam 6. Xaiv Txuag li…

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 7
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 7

Kauj Ruam 7. Qhib daim nplaub tshev uas koj xav khaws cov ntawv

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 8
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 8

Kauj Ruam 8. Nyem rau "Txuag raws li hom" cov ntawv qhia zaub mov nco

Ib daim ntawv teev cov hom ntaub ntawv yuav qhib.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 9
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 9

Kauj Ruam 9. Xaiv CSV (Comma delimited) (*. Cvs)

Txoj kev no, koj tuaj yeem tsim cov ntaub ntawv uas tuaj yeem hloov pauv mus rau hauv. DAT hom ntawv.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 10
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 10

Kauj Ruam 10. Ntaus lub npe ntawv

Sau ib lub npe hauv daim teb "File name". Yog tias koj xav siv lub npe uas twb muaj lawm, hla ntu no.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 11
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 11

Kauj Ruam 11. Nyem Txuag

Cov lus pom zoo yuav muab tso tawm.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 12
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 12

Kauj ruam 12. Nyem OK

Cov ntaub ntawv. CSV yuav raug cawm thiab npaj yuav hloov dua siab tshiab.

Ntu 2 ntawm 2: Hloov pauv. CSV Cov Ntaub Ntawv rau hauv. DAT Hom Ntawv

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 13
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 13

Kauj Ruam 1. Nias Yeej+E qhov tseem ceeb

Qhov File Explorer window yuav qhib.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 14
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 14

Kauj Ruam 2. Mus ntsib daim nplaub tshev qhov twg khaws cov ntaub ntawv. CSV

Tsis txhob nyem cov ntawv thaum lub nplaub tshev qhib; tsuas yog cia daim nplaub tshev tshwm ntawm qhov screen.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 15
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 15

Kauj Ruam 3. Txoj cai-nias cov ntaub ntawv koj xav hloov

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 16
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 16

Kauj Ruam 4. Xaiv Qhib nrog…

Ib daim ntawv teev npe yuav raug muab tso tawm.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 17
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 17

Kauj Ruam 5. Nyem Notepad

Cov ntawv yuav qhib rau hauv Notepad daim ntawv thov.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 18
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 18

Kauj Ruam 6. Nyem rau File menu

Nws nyob rau sab saud sab laug ntawm lub qhov rais Notepad.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 19
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 19

Kauj Ruam 7. Nyem Txuag Raws Li…

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 20
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 20

Kauj Ruam 8. Nyem rau "Txuag raws li hom" cov ntawv qhia zaub mov nco

Cov ntawv qhia zaub mov no nyob hauv kab ntawv "File name". Ib daim ntawv teev cov hom ntaub ntawv yuav muab tso tawm.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 21
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 21

Kauj Ruam 9. Xaiv Txhua Cov Ntaub Ntawv (*.*)

Nrog rau qhov kev xaiv no, koj tuaj yeem txhais koj tus kheej txuas ntxiv mus siv.

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 22
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 22

Kauj ruam 10. Hloov npe cov ntaub ntawv nrog. DAT txuas ntxiv ntawm qhov kawg ntawm lub npe

Piv txwv li, yog tias kab ntawv "Lub npe" tam sim no sau Buku1.txt, hloov nws mus rau Book1.dat.

Kev nqis peev ntawm. DAT txuas ntxiv tsis muaj kev cuam tshuam (piv txwv li ". DAT" lossis ".dat")

Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 23
Hloov Excel rau Cov Ntaub Ntawv Kauj Ruam 23

Kauj Ruam 11. Nyem Txuag

Cov ntaub ntawv tseem ceeb tam sim no tau ua tiav khaws cia rau hauv. DAT hom ntawv.

Pom zoo: