Ntshuam cov ntsiab lus ntawm CSV cov ntaub ntawv rau hauv Excel. Yuav ua li cas qhib CSV cov ntaub ntawv hauv Excel

CSV yog ib qho kev xaiv rau cov ntawv nyeem cov ntaub ntawv uas yog siv los tso saib cov ntaub ntawv tabular. Cov ntaub ntawv nrog qhov txuas ntxiv no yog siv los pauv qee cov ntaub ntawv ntawm cov khoos phis tawj. Txhawm rau saib lossis kho cov ntaub ntawv CSV, tsis yog txhua qhov khoom siv tsim nyog. Qhov ib txwm ob npaug nias feem ntau ua rau cov ntaub ntawv tsis raug. Txhawm rau kom tau txais cov ntaub ntawv raug thiab muaj peev xwm hloov pauv, koj tuaj yeem siv Excel.

Txoj hauv kev qhib CSV cov ntaub ntawv hauv Excel

Ua ntej sim qhib cov ntaub ntawv nrog qhov txuas ntxiv, koj yuav tsum nkag siab tias lawv yog dab tsi. Comma-Separated Values ​​(CSV) - los ntawm lus Askiv "comma-separated values". Cov ntaub ntawv nws tus kheej siv ob hom sib cais, nyob ntawm seb hom lus ntawm qhov program:

1. Rau cov lus - ib tug semicolon.
2. Rau cov lus Askiv version - comma.

Thaum txuag CSV cov ntaub ntawv, ib qho kev encoding yog siv, vim hais tias, thaum lawv qhib, tej zaum yuav muaj teeb meem cuam tshuam nrog cov ntaub ntawv tsis raug. Qhib ib daim ntawv nrog Excel nrog tus qauv ob npaug nias, nws yuav xaiv qhov kev txiav txim siab tsis txaus ntseeg rau kev txiav txim siab. Yog hais tias nws tsis phim tus uas encrypted cov ntaub ntawv nyob rau hauv cov ntaub ntawv, cov ntaub ntawv yuav muab tso tawm kom pom nyob rau hauv cov cim tsis raug. Lwm qhov teeb meem tshwm sim yog delimiter mismatch, piv txwv li, yog tias cov ntaub ntawv tau txais kev cawmdim nyob rau hauv lus Askiv version ntawm qhov kev pab cuam, tab sis qhib rau hauv , los yog vice versa.

Txhawm rau zam cov teeb meem no, koj yuav tsum paub yuav ua li cas qhib CSV cov ntaub ntawv nrog Excel. Muaj peb txoj hauv kev uas yuav tsum tau xav txog ntau yam ntxiv.

Siv lub Text Wizard

Excel muaj ntau yam cuab yeej ua ke, ib qho yog Text Wizard. Nws tuaj yeem siv los qhib cov ntaub ntawv CSV. Txheej txheem:

1. Koj yuav tsum qhib qhov program. Ua haujlwm ntawm kev tsim daim ntawv tshiab.
2. Mus rau "Cov ntaub ntawv" tab.
3. Nyem rau ntawm "Tau txais cov ntaub ntawv sab nraud" khawm. Ntawm cov kev xaiv muaj, xaiv "Los ntawm cov ntawv".
4. Los ntawm lub qhov rais uas qhib, koj yuav tsum nrhiav cov ntaub ntawv xav tau, nyem rau ntawm "Ntshuam" khawm.
5. Lub qhov rais tshiab yuav qhib nrog Text Wizard teeb tsa. Nyob rau hauv cov ntaub ntawv hom kho tab, kos lub thawv nyob ib sab ntawm "Delimited". Koj yuav tsum xaiv hom ntawv nws tus kheej nyob ntawm seb qhov encoding tau siv thaum encoding daim ntawv. Cov hom ntawv nrov tshaj plaws yog Unicode, Cyrillic.
6. Ua ntej nias lub pob "Tom ntej", nyob rau hauv qab ntawm nplooj ntawv, koj tuaj yeem ua qhov saib ua ntej los txiav txim siab seb hom ntawv twg raug xaiv, yuav ua li cas cov ntaub ntawv tso tawm.
7. Tom qab kuaj xyuas thiab nias lub pob "Tom ntej", ib nplooj ntawv yuav qhib uas koj yuav tsum tau teeb tsa hom cais (commas lossis semicolons). Nyem "Tom ntej" khawm dua.
8. Nyob rau hauv lub qhov rai uas tshwm, koj yuav tsum xaiv tus txheej txheem ntawm importing cov ntaub ntawv, nyem "OK".

Tseem ceeb! Txoj kev qhib CSV cov ntaub ntawv no tso cai rau koj kom txuag tau qhov dav ntawm txhua kab, nyob ntawm seb cov ntaub ntawv lawv tau sau li cas.

Los ntawm ob-nias lossis xaiv ib daim ntawv thov los ntawm lub computer

Txoj hauv kev yooj yim tshaj plaws los qhib CSV cov ntaub ntawv. Lawv tsim nyog siv yog tias txhua qhov kev ua nrog cov ntaub ntawv (tsim, txuag, qhib) yog ua los ntawm tib lub version ntawm qhov kev pab cuam. Yog hais tias Excel yog Ameslikas ntsia raws li ib qho kev pab cuam uas yuav qhib tag nrho cov ntaub ntawv ntawm hom ntawv no, cia li ob-nias ntawm daim ntawv. Yog tias qhov kev zov me nyuam tsis raug muab los ntawm lub neej ntawd, koj yuav tsum ua ntau yam haujlwm:

1. Txoj nyem rau ntawm daim ntawv thiab xaiv "Qhib Nrog" los ntawm cov ntawv qhia zaub mov uas tshwm.
2. Cov txheej txheem xaiv yuav raug nthuav tawm. Yog tias tsis muaj cov khoom siv tsim nyog, koj yuav tsum nrhiav Excel hauv "Xaiv lwm daim ntawv thov" tab.

Cov zaub kom raug ntawm cov ntaub ntawv tsuas yog ua tau nrog qhov piv ntawm cov encodings, cov kev pab cuam versions.

Tsis tas yuav pom Excel hauv "Xaiv lwm daim ntawv thov" tab. Hauv qhov no, koj yuav tsum nyem rau ntawm "Nrhiav lwm daim ntawv thov ntawm lub khoos phis tawj no" khawm. Tom qab ntawd, koj yuav tsum nrhiav qhov kev pab cuam uas yuav tsum tau los ntawm nws qhov chaw, nyem lub pob "OK".

Cov ntawv qhia ua zaub mov

Lwm txoj hauv kev zoo los qhib CSV cov ntaub ntawv. Txheej txheem:

1. Qhib Excel.
2. Nyem rau ntawm lub pob "Qhib".
3. Qhib lub explorer los ntawm "Xaiv" muaj nuj nqi.
4. Xaiv "Tag nrho cov ntaub ntawv" hom.
5. Nyem qhov "Qhib" khawm.

Tam sim ntawd tom qab ntawd, "Text Import Wizard" yuav qhib. Nws yuav tsum tau configured raws li tau piav ua ntej.

xaus

Tsis muaj teeb meem npaum li cas cov hom ntawv ntawm CSV cov ntaub ntawv yog, nrog rau txoj cai encoding thiab program version, lawv tuaj yeem qhib nrog Excel. Yog tias, tom qab qhib nrog ob npaug nias, lub qhov rais tshwm nrog ntau cov cim nyeem tsis tau, nws raug nquahu kom siv Text Wizard.