Hloov CSV rau Excel ua lub rooj

Cov ntsiab lus ntawm cov ntaub ntawv feem ntau yog muab rho tawm ua cov ntaub ntawv .csv. Txawm li cas los xij, nws tsuas yog cov ntawv nyeem xwb, tsis yooj yim nyeem. Txhawm rau ua haujlwm nrog cov ntsiab lus ntawm cov ntaub ntawv, nws yog qhov tsim nyog los nthuav tawm nws hauv ntau hom - feem ntau Excel nplooj ntawv yooj yim tshaj plaws. Txog cov txheej txheem dab tsi tshwm sim los ua qhov no, qhov twg yog qhov zoo dua, thiab qhov yuam kev twg thaum hloov cov ntaub ntawv, yuav tau tham hauv kab lus no.

Yuav Hloov CSV rau Excel li cas

Muaj ntau txoj hauv kev uas cov ntaub ntawv CSV rub tawm los ntawm cov ntaub ntawv tuaj yeem xa mus rau Excel. Peb yuav tham txog peb ntawm lawv:

1. Qhib ncaj qha hauv Excel.
2. Qhib ntawm Windows Explorer.
3. Ntshuam cov ntaub ntawv nrog hloov hom ntawv.

Qhib cov ntaub ntawv CSV hauv Excel

Excel tuaj yeem qhib .csv cov ntaub ntawv ncaj qha yam tsis muaj kev hloov pauv. Cov hom ntawv tsis hloov tom qab qhib hauv txoj kev no, .csv txuas ntxiv tau txais kev cawmdim - txawm hais tias qhov txuas ntxiv tuaj yeem hloov pauv tom qab kho.

1. Tua tawm Excel, nyem rau ntawm "cov ntaub ntawv“, Tiamsis”Qhib".
2. Hauv qhov rai uas tshwm, xaiv qhov kev xaiv "Cov ntawv luam tawmlos ntawm daim ntawv nthuav dav.

3. Nrhiav cov ntaub ntawv koj xav tau thiab nyem ob npaug rau nws.

.csv cov ntaub ntawv qhib hauv Excel tam sim ntawd, tsis muaj kev hloov pauv ntxiv. Tab sis .txt cov ntaub ntawv yuav xav tau hloov dua siab tshiab - lub qhov rais yuav tshwm sim "Text Import Wizards".

Muaj cov rooj plaub thaum nws zoo dua tsis txhob qhib cov ntaub ntawv ncaj qha, tab sis hu Master. Txoj hauv kev no yog tsim nyog nyob rau hauv cov xwm txheej hauv qab no:

• cov cim cais siv nyob rau hauv cov ntaub ntawv tsis yog tus qauv, los yog muaj ntau ntau yam ntawm lawv;
• cov ntaub ntawv muaj cov hnub sib txawv;
• koj tab tom hloov cov lej uas pib nrog xoom thiab xav kom lawv li ntawd;
• ua ntej koj hloov cov ntaub ntawv, koj xav saib seb qhov kawg tshwm sim yuav zoo li cas;
• koj feem ntau xav tau ntau portability.

Master yuav pib yog tias koj hloov daim ntawv txuas ntxiv mus rau .txt. Koj tuaj yeem pib import cov ntaub ntawv sib txawv, uas yuav tau tham tom qab, tom qab piav qhia txoj kev qhib thib ob.

Yog tias koj hloov pauv cov ntaub ntawv tom qab koj qhib nws, Excel yuav qhia koj kom txuag nws li .xls (lossis .xlsx) vim tias tsis yog qee qhov kev hloov pauv yuav ploj. Tom qab ntawd yuav muaj lub sijhawm los hloov cov hom ntawv rov qab, txawm li cas los xij, lwm qhov ntawm cov ntsiab lus yuav ploj mus - xoom yuav ploj mus thaum pib ntawm cov lej, qee cov ntaub ntawv yuav hloov lawv cov tsos.

Qhib cov ntaub ntawv CSV los ntawm Windows Explorer

Txoj kev no tsis yog qhov txawv ntawm qhov dhau los. Txhawm rau qhib ib daim ntawv, tsuas yog nyem ob npaug rau nws hauv Windows Explorer.

Ua ntej qhib, xyuas kom meej tias nyob ib sab ntawm cov ntaub ntawv npe muaj lub cim rau Excel program, thiab tsis yog lwm qhov - qhov no txhais tau tias Excel raug xaiv los ua qhov program uas yuav tsum qhib cov ntaub ntawv. Txwv tsis pub, qee qhov kev pab cuam yuav qhib. Koj tuaj yeem hloov nws mus rau Excel li no:

1. Hu rau cov ntawv qhia zaub mov los ntawm txoj cai-nias ntawm ib qho .csv cov ntaub ntawv thiab siv Qhib Nrog…> Xaiv Qhov Kev Pabcuam.
2. xaiv Excel (lub desktop) of Cov kev pab cuam pom zoo, xaiv nws raws li ib qho kev pab cuam uas yuav tsum tau siv rau cov ntaub ntawv zoo li no (kos lub thawv hauv qab), thiab kaw lub qhov rais los ntawm nias OK.

Import CSV rau Excel

Nws tseem tuaj yeem tig cov ntaub ntawv qhib rau hauv Excel phau ntawv ua haujlwm. Cov hom ntawv yuav hloov mus rau .xls rau yav dhau los versions ntawm Excel (2000, 2003) thiab .xlsx rau tag nrho lwm tus. Tag nrho cov ntsiab lus yuav muab tso rau hauv ib daim ntawv.

1. Nyem rau ntawm lub xov tooj ntawm tes nyob rau hauv daim ntawv uas cov ntshuam yuav tsum pib. Qhov no feem ntau yog thawj cell hauv lub rooj, A1. Pib los ntawm nws, ntau kab raws li muaj nyob rau hauv cov ntaub ntawv qhib, thiab ntau txhua kab raws li muaj nuj nqis nyob rau hauv txhua kem yuav tau sau.
2. Hauv tab "Cov ntaub ntawv” hauv ib pab pawg "Tau txais cov ntaub ntawv sab nraud " xaiv "Los ntawm cov ntawv”.

3. Hauv qhov rai uas tshwm, nrhiav cov ntaub ntawv xav tau thiab nyem ob npaug rau nws (koj tuaj yeem siv lub pob Ntshuam nyob rau hauv qab ntawm lub qhov rais).

4. Tom ntej no, koj yuav tsum ua raws li cov lus qhia step-by-step ntawm qhov qhib Text Import Wizards.

Daim duab hauv qab no qhia txog cov ntaub ntawv qub thiab cov txiaj ntsig xav tau. Txhawm rau kom txhua yam zoo li no tom qab ntshuam, koj yuav tsum siv ntau qhov chaw, uas yuav tau tham tom qab.

Kauj ruam 1. Tus wizard yuav hais kom koj xaiv hom ntaub ntawv - Raws li koj tuaj yeem twv, nws yuav yog "nrog separators” (hauv lus Askiv – txwv tsis pub), thiab kab los ntawm cov ntsiab lus hloov pauv yuav pib - feem ntau yuav, koj yuav tsum pib nrog lus 1yog tias koj tsis xav hloov tsuas yog ib feem ntawm cov ntsiab lus. Lub qhov rais hauv qab no yuav qhia thawj kab ntawm cov ntaub ntawv xaiv.

Kauj ruam 2. Tam sim no koj yuav tsum to taub qhov twg yog siv cais (tej zaum yuav muaj ntau tshaj ib qho) hauv cov ntaub ntawv, thiab qhia cov cim no hauv Masters. Nws muaj cov kev xaiv los xaiv los ntawm tus qauv delimiters, tab sis yog tias siv cov cim atypical hauv daim ntawv, koj tuaj yeem xaiv lwm yam thiab nkag mus rau tus yam ntxwv xav tau. Hauv cov ntaub ntawv siv rau kev ua qauv qhia, tus delimiters yog − Comma и Tab. Commas cais cov hlwb nrog cov yam ntxwv ntawm cov khoom lag luam, xws li tus lej xov tooj thiab cov ntawv luam tawm, thiab tabs cais ib yam khoom los ntawm lwm tus - cov ntaub ntawv hais txog txhua tus yuav tsum pib ntawm kab tshiab.

Nws tseem yuav tsum tau txhais thiab qhia meej ntawv delimiter. Qhov no yog ib tug cim tso ua ntej thiab tom qab txhua daim ntawv uas yuav tsum tau nyob rau hauv ib tug cell. Ua tsaug rau tus delimiter, txhua ntu yog pom tias yog tus nqi sib cais, txawm tias hauv nws muaj cov cim xaiv los cais cov txiaj ntsig. Nyob rau hauv peb cov ntaub ntawv, txhua tus nqi yog framed nrog quotes - yog li ntawd, txawm yog hais tias nws muaj ib tug comma (piv txwv li, "pib, ces mus ntxiv"), tag nrho nws cov ntawv yuav muab tso rau hauv ib lub xov tooj, thiab tsis nyob rau hauv ob lub sib law liag.

Kauj ruam 3. Ntawm no nws yog txaus los saib qhov saib ua ntej thiab, yog tias nws tsis pom qhov tsis txaus ntseeg, nyem Tag. Tej zaum nws yuav tshwm sim tias qee qhov txiaj ntsig yuav raug sib cais tsis yog los ntawm ib qho kev sib cais, tab sis los ntawm ob peb, vim li ntawd, cov hlwb tsis muaj nuj nqis yuav tshwm sim ntawm lawv. Txhawm rau tiv thaiv qhov no tshwm sim, xaiv lub checkbox Kho cov kab sib law liag ua ib qho.

5. Xaiv txoj hauv kev (nws tuaj yeem yog daim ntawv tshiab lossis ib daim ntawv uas twb muaj lawm) thiab nyem OKua kom tiav cov txheej txheem ntshuam.

Koj kuj tseem tuaj yeem nyem ntaub ntawv - muaj lwm txoj hauv kev. Piv txwv li, koj tuaj yeem tsim cov ntsiab lus, kho qhov cim, thiab hloov kho cov ntaub ntawv li cas.

Qee zaum qhov tshwm sim ntawm kev hloov dua siab tshiab yog deb ntawm qhov xav tau. Cov txiaj ntsig no tuaj yeem hloov pauv li cas yuav tau tham hauv tshooj tom ntej ntawm kab lus.

Teeb meem thaum hloov dua siab tshiab thiab lawv cov kev daws teeb meem

Rau txhua lub sijhawm uas CSV hom muaj nyob, tsis muaj leej twg cuam tshuam los ua ntaub ntawv nws. Yog li ntawd, txawm hais tias nws tau xav tias yuav tsum siv commas los cais cov txiaj ntsig, qhov tseeb, cov ntaub ntawv sib txawv siv cov khoom sib txawv - semicolons, tabs, thiab lwm yam.

Cov ntawv delimiters kuj tuaj yeem sib txawv - feem ntau lawv yog cov cim hais lus lossis ib qho kev txiav txim byte. Tej zaum yuav tsis muaj qhov txwv tsis pub dhau - tom qab ntawd tus cwj pwm siv los ua qhov sib cais ib txwm pom zoo li no (tom qab ntawd nws feem ntau tsis yog comma - nws yog siv ntau dhau hauv cov ntawv nyeem - tab sis txawv, tsawg dua tus cwj pwm).

Cov ntaub ntawv tsis yog tus qauv yuav tsis qhib kom raug - txhawm rau kom lawv tso tawm kom pom raws li lawv yuav tsum tau, koj yuav tsum hloov cov chaw ntawm lub khoos phis tawj lossis qhib qhov program. Cia peb saib seb muaj teeb meem dab tsi thiab cov kev daws teeb meem twg muaj rau lawv.

Cov ntaub ntawv qhib tsis raug

Pov thawj. Tag nrho cov ntsiab lus ntawm cov ntaub ntawv tau muab tso rau hauv thawj kab.

Cause. Cov ntaub ntawv siv tus cwj pwm ua tus delimiter uas tsis raug xaiv raws li xws li hauv cov chaw hauv computer, lossis tshwj xeeb rau kev ua haujlwm sib txawv. Piv txwv li, ib qho comma tej zaum yuav tau tshwj tseg rau cais cov zauv feem ntawm tus lej, thiab yog li ntawd tsis tuaj yeem cais cov nqi hauv cov ntaub ntawv.

Solutions. Muaj ntau txoj hauv kev los daws qhov teeb meem no:

1. Hloov cov cim cais hauv daim ntawv nws tus kheej. Qhib nws hauv Notepad lossis tus editor zoo sib xws, thiab hauv kab pib (kho, tag nrho cov ntaub ntawv yuav tsum nyob hauv kab hauv qab), sau cov ntawv hauv qab no:

• hloov lub separator mus rau ib qho comma: Sep
• hloov mus rau semicolon: sib =;

Lwm tus cim sau tom qab sep = ib nyob rau hauv thawj kab, kuj yuav dhau los ua tus delimiter.

2. Cov cim cais siv hauv cov ntaub ntawv kuj tuaj yeem teev tseg hauv Excel nws tus kheej. Hauv versions 2016, 2013 lossis 2010, rau qhov no koj yuav tsum qhib lub tab Cov ntaub ntawv thiab xaiv “Cov ntawv los ntawm kab” hauv ib pab pawg "Ua haujlwm nrog cov ntaub ntawv ".

Qhov no yuav qhib qhov rais "Wizards rau faib cov ntawv rau hauv kab ". Nyob ntawd, los ntawm cov ntaub ntawv tawm tswv yim, koj yuav tsum xaiv cov neeg sib cais. Ces koj yuav tsum nias Tom ntej no thiab, tom qab xaiv tus delimiter, Tag.

3. Txhawm rau qhib ib daim ntawv nrog Ntshuam Cov Ntsuas, thiab tsis yog hauv daim ntawv Excel xwb, qhov txuas ntxiv tuaj yeem hloov pauv ntawm .csv rau .txt. AT Masters Nws muaj peev xwm hais meej txhua tus cwj pwm ua tus cais - yuav ua li cas, tsab xov xwm tau piav qhia ua ntej.
4. Siv VBA. Koj tuaj yeem siv, piv txwv li, - nws yog qhov tsim nyog rau Excel 2000 lossis 2003. Cov lej tuaj yeem hloov pauv kom nws haum rau lwm cov qauv.

Cov kev daws teeb meem uas tau hais los saum toj no yog tsim los rau ib tus neeg cov ntaub ntawv, qhov chaw uas txawv ntawm cov niaj hnub. Cov kev ua ntu zus no yuav tsum tau siv rau txhua cov ntaub ntawv uas tsis qhib kom raug. Yog tias feem ntau ntawm cov ntaub ntawv tsis qhib kom raug, tej zaum qhov kev daws teeb meem zoo tshaj plaws yog hloov chaw ntawm lub khoos phis tawj - qhov no tau tham hauv qhov kev daws thib tsib.

5. Hloov tus cais thiab tus lej lej hauv lub computer teeb tsa

В Control Vaj Huam Sib Luag, hu los ntawm khawm Start, xaiv "Ntxiv kev xaiv " los ntawm daim ntawv "Regional Standards”. Tom qab txhaj, lub qhov rai yuav tshwmFormatting” - hauv nws koj tuaj yeem xaiv "List Separator" thiab tus separator ntawm tus lej thiab feem feem ntawm tus lej. Yog hais tias cov ntaub ntawv xav tau ib tug comma raws li tus delimiter, thawj zaug teem lub sij hawm raws li tus decimal point. Tej zaum nws yuav tig mus rau lwm txoj hauv kev - koj xav tau ib qho semicolon ua tus cim cais. Tom qab ntawd rau feem, koj tuaj yeem tawm ntawm ib qho kev kos npe, qhov no yuav tsis ua rau muaj kev tsis sib haum xeeb.

Thaum tag nrho cov kev teeb tsa tiav, nyem OK ntawm ob qho tib si ntawm ob lub qhov rais qhib - lawv yuav kaw thiab cov kev hloov pauv yuav raug cawm dim. Nco ntsoov tias tam sim no lawv ua haujlwm rau txhua qhov haujlwm hauv computer.

Tshem tawm cov xoos ua ntej

Kos npe rau. Qee qhov tseem ceeb hauv cov ntaub ntawv yog cov lej pib nrog xoom uas tsis sib cais los ntawm ib feem ntawm kos npe (piv txwv li, ciphers thiab cov lej nrog tus lej tas li, nkag mus thiab passwords, ntsuas ntsuas thiab ntsuas ntsuas ntsuas). Hauv Excel, cov xoos thaum pib ntawm cov lej no ploj mus. Yog tias koj hloov kho cov ntaub ntawv thiab tom qab ntawd khaws nws ua Excel phau ntawv ua haujlwm, nws yuav tsis tuaj yeem pom hauv phau ntawv ua haujlwm no uas cov lej nrog xoom yog.

Cause. Excel muaj cov ntawv sib cais rau cov ntawv nyeem thiab cov lej. Hauv cov ntawv nyeem, tsis muaj qhov sib cais li ntawd, thiab yog li Excel muab cov hom ntawv dav dav rau txhua qhov txiaj ntsig. Nws txhais tau tias cov ntawv tso tawm raws li cov ntawv nyeem, thiab cov lej tsis muaj cov cim ntawm cov tsiaj ntawv tau tshwm sim ua tus lej uas tsis tuaj yeem pib nrog xoom.

tshuaj. Hloov qhov txuas ntxiv mus rau .txt kom pab kom Ntshuam Wizard thaum koj qhib cov ntaub ntawv. Thaum koj tau mus rau Kauj Ruam 3, hloov cov hom kab nrog cov lej uas pib nrog xoom rau cov ntawv nyeem.

Qee qhov txiaj ntsig zoo li hnub

Kos npe rau. Hnub tso tawm qhov tseem ceeb uas yog cov ntawv nyeem yooj yooj yim lossis cov lej.

Cause. Cov hom ntawv dav dav suav nrog hloov cov txiaj ntsig mus rau hnub uas zoo li cov rau Excel. Yog tias daim ntawv CSV muaj ib tus nqi zoo li maj 12, ces nyob rau hauv daim ntawv Excel nws yuav tshwm sim raws li hnub tim.

tshuaj. Zoo ib yam li ntawd hauv rooj plaub dhau los. Hloov qhov txuas ntxiv rau .txt, hauv Masters hloov cov qauv ntawm cov nqi hloov mus rau hnub rau cov ntawv nyeem.

Yog hais tias, ntawm qhov tsis tooj, koj xav tso saib cov ntsiab lus ntawm ib kem raws li hnub, teem hom ntawv rau nws hnub. Muaj ntau ntau hom hnub hom, yog li xaiv qhov koj xav tau los ntawm daim ntawv teev npe.

Yuav ua li cas import ntau CSV cov ntaub ntawv rau hauv Excel

Excel tuaj yeem qhib ntau cov ntaub ntawv CSV ib zaug.

1. Xovxwm Cov Ntaub Ntawv> Qhib thiab xaiv qhov kev xaiv Cov ntawv luam tawm los ntawm daim ntawv teev npe hauv qab no.
2. Txhawm rau xaiv ntau cov ntaub ntawv ib sab, ua ntej xaiv thawj tus, ces nyem ua haujlwm thiab nyem rau ntawm qhov kawg. Ntxiv rau cov ntaub ntawv xaiv, txhua cov ntaub ntawv nyob nruab nrab yuav raug xaiv.
3. Nyem Qhib.

Qhov tsis zoo ntawm txoj kev no yog tias txhua cov ntaub ntawv xaiv yuav raug qhib cais hauv Excel. Tsiv ntawm ib daim ntawv mus rau lwm qhov tuaj yeem ua rau cov nqi sijhawm. Txawm li cas los xij, tom qab ntawd nws tuaj yeem luam cov ntsiab lus ntawm tag nrho lawv mus rau hauv nplooj ntawv hauv tib phau ntawv ua haujlwm.

Cov lus piav qhia tau ntev, txawm li cas los xij, tam sim no koj yuav tuaj yeem qhib cov ntaub ntawv CSV hauv Excel yam tsis muaj teeb meem ntau. Yog tias ib yam dab tsi zoo li tsis nkag siab thaum xub thawj siab ib muag, tsuas yog ua raws li cov kauj ruam qhia thiab txhua yam yuav paub meej.