Sinthani CSV kukhala Excel ngati tebulo

Zomwe zili munkhokwe nthawi zambiri zimachotsedwa ngati fayilo ya .csv. Komabe, ndi fayilo chabe, yosawerengeka kwambiri. Kuti mugwire ntchito ndi zomwe zili mu database, ndikofunikira kuziwonetsa mwanjira ina - nthawi zambiri mapepala a Excel ndiwosavuta. Za njira zomwe zilipo zochitira izi, zomwe zili bwino, ndi zolakwika zotani pamene mukusamutsa deta, tidzakambirana m'nkhaniyi.

Momwe mungasinthire CSV kukhala Excel Format

Pali njira zingapo zomwe chikalata cha CSV chotsitsidwa kuchokera pankhokwe chingasamutsire ku Excel. Tikambirana zitatu mwa izo:

1. Kutsegula kwachindunji mu Excel.
2. Kutsegula kudzera pa Windows Explorer.
3. Lowetsani chikalata chosintha mawonekedwe.

Kutsegula chikalata cha CSV mu Excel

Excel imatha kutsegula zolemba za .csv mwachindunji popanda kutembenuka. Mawonekedwewo sasintha atatha kutsegulidwa motere, kukulitsa kwa .csv kumasungidwa - ngakhale kukulitsa kungasinthidwe mutatha kusintha.

1. Tsegulani Excel, dinani "file", Ndiye"Open".
2. Pazenera lomwe likuwoneka, sankhani kusankha "Mafayilo olembakuchokera pamndandanda wowonjezedwa.

3. Pezani chikalata chomwe mukufuna ndikudina kawiri pamenepo.

Zolemba za .csv zimatsegulidwa mu Excel nthawi yomweyo, popanda kusintha kwina kulikonse. Koma mafayilo a .txt adzafunika kutembenuka - zenera lidzawoneka "Text Import Wizards".

Pali zochitika pamene kuli bwino kuti musatsegule chikalatacho mwachindunji, koma kuyitana Master. Njira iyi ndiyovomerezeka muzochitika zotsatirazi:

• mawonekedwe olekanitsa omwe amagwiritsidwa ntchito muzolemba siwokhazikika, kapena pali mitundu ingapo ya iwo;
• chikalatacho chili ndi masiku m'njira zosiyanasiyana;
• mukutembenuza manambala omwe amayamba ndi ziro ndipo mukufuna kuwasunga motero;
• musanasamutse deta, mukufuna kuwona momwe zotsatira zake zidzawoneka;
• nthawi zambiri mumafuna kunyamula zambiri.

Master idzayamba ngati musintha chiwongola dzanja kukhala .txt. Mukhozanso kuyamba kuitanitsa fayilo mosiyana, zomwe zidzakambidwe pambuyo pake, mutatha kufotokoza njira yachiwiri yotsegulira.

Ngati musintha chikalatacho mukachitsegula, Excel idzakulimbikitsani kuti muyisunge ngati .xls (kapena .xlsx) chifukwa ngati sichoncho masanjidwe ena adzatayika. Ndiye nthawi zonse padzakhala mwayi wosintha mawonekedwe mmbuyo, komabe, gawo lina lazomwe likhoza kutayika - zero zikhoza kutha kumayambiriro kwa manambala, zolemba zina zingasinthe maonekedwe awo.

Kutsegula chikalata cha CSV kudzera pa Windows Explorer

Njira imeneyi si yosiyana kwenikweni ndi yapitayi. Kuti mutsegule chikalata, dinani kawiri pa Windows Explorer.

Musanatsegule, onetsetsani kuti pafupi ndi dzina lachikalatacho pali chithunzi cha pulogalamu ya Excel, osati china - izi zikutanthauza kuti Excel yasankhidwa kukhala pulogalamu yomwe iyenera kutsegula mafayilo otere. Apo ayi, pulogalamu ina idzatsegulidwa. Mutha kusintha ku Excel motere:

1. Imbani mndandanda wankhani podina pomwe pafayilo iliyonse ya .csv ndikuyika Tsegulani Ndi…> Sankhani Pulogalamu.
2. Sankhani Excel (desktop) of Mapulogalamu ovomerezeka, iwonetseni ngati pulogalamu yomwe iyenera kugwiritsidwa ntchito nthawi zonse pamafayilo oterowo (onani bokosi lomwe lili pansipa), ndikutseka zenera ndikukanikiza OK.

Lowetsani CSV ku Excel

Ndikothekanso kusintha chikalata chotsegulidwa kukhala buku la Excel. Mtunduwu usintha kukhala .xls pamatembenuzidwe akale a Excel (2000, 2003) ndi .xlsx kwa ena onse. Zinthu zonse zidzawonetsedwa papepala limodzi.

1. Dinani pa selo yomwe ili papepala lomwe kulowetsa kuyenera kuyamba. Ili nthawi zambiri imakhala cell yoyamba patebulo, A1. Kuyambira pamenepo, mizere ingapo yomwe ili mufayilo yotsegulidwa, ndipo mizere yochuluka monga momwe zilili pagawo lililonse idzadzazidwa.
2. Mu tab "Deta” mu gulu"Kupeza Zambiri Zakunja” sankhani "Kuchokera pamawu".

3. Pazenera lomwe likuwoneka, pezani chikalata chofunikira ndikudina kawiri (mutha kugwiritsanso ntchito batani Lowani pansi pawindo).

4. Kenako, muyenera kutsatira tsatane-tsatane malangizo a anatsegula Text Import Wizards.

Chithunzi chomwe chili pansipa chikuwonetsa chikalata choyambirira ndi zotsatira zomwe zikuyembekezeka. Kuti chilichonse chiwoneke ngati chotere mutatha kuitanitsa, muyenera kugwiritsa ntchito zoikamo zosiyanasiyana, zomwe zidzakambidwe pambuyo pake.

Gawo 1. Wizard idzakupangitsani kusankha mtundu wa fayilo - monga momwe mungaganizire, zidzakhala "ndi olekanitsa" (m'Chingerezi - malire), ndi mzere umene kusamutsidwa kokhutira kudzayambira - mwinamwake, muyenera kuyamba nawo mawu 1ngati simukufuna kusamutsa gawo chabe la zili. Zenera ili m'munsimu liwonetsa mizere yoyamba kuchokera pachikalata chosankhidwa.

Gawo 2. Tsopano muyenera kumvetsetsa yomwe imagwiritsidwa ntchito wopatula (pakhoza kukhala oposa mmodzi) mu fayilo, ndipo tchulani munthu uyu mu ambuye. Ili ndi zosankha zoti musankhe kuchokera ku delimiters wamba, koma ngati mawonekedwe atypical agwiritsidwa ntchito pachikalatacho, mutha kusankha Zina ndipo lowetsani chikhalidwe chomwe mukufuna. M'fayilo yomwe imagwiritsidwa ntchito powonetsera, otsitsa ndi - Sakanizani и Tab. Makoma amalekanitsa ma cell okhala ndi mawonekedwe, monga nambala ya seriyo ndi kuchuluka kwa makope omwe agulitsidwa, ndi ma tabu amalekanitsa chinthu china ndi china - zambiri za chilichonse ziyenera kuyamba pamzere watsopano.

M'pofunikanso kufotokoza ndi kufotokoza malemba delimiter. Ichi ndi chilembo chomwe chimayikidwa chisanachitike komanso pambuyo pa gawo lililonse lomwe liyenera kukhala mu selo imodzi. Chifukwa cha delimiter, gawo lililonse loterolo limawonedwa ngati mtengo wosiyana, ngakhale mkati mwake muli zilembo zosankhidwa kuti zilekanitse zikhalidwe. M'chikalata chathu, mtengo uliwonse umapangidwa ndi zolemba - choncho, ngakhale liri ndi comma (mwachitsanzo, "chiyambi, ndiye pitirizani"), zolemba zake zonse zidzayikidwa mu selo imodzi, osati ziwiri zotsatizana.

Khwerero 3. Apa ndikwanira kuyang'ana zowoneratu ndipo, ngati sizikuwonetsa zolakwika zilizonse zosavomerezeka, dinani chitsiriziro. Zitha kuchitika kuti zina mwazabwino zidzasiyanitsidwa osati ndi olekanitsa m'modzi, koma ndi angapo, chifukwa chake, pakati pawo ma cell opanda zikhalidwe adzawonekera. Kuti izi zisachitike, sankhani bokosi Chitani zodulira motsatizana ngati m'modzi.

5. Sankhani njira yopita (ikhoza kukhala tsamba latsopano kapena pepala lomwe lilipo) ndikudina OKkuti amalize kuitanitsa.

Mutha kuchezanso zipangizo - pali zina zotheka. Mwachitsanzo, mutha kupanga zomwe zili, kusinthira mwamakonda anu, ndi momwe chidziwitso chimasinthidwa.

Nthawi zina zotsatira za kutembenuka zimakhala zosayembekezereka. Mmene zotsatirazi zingasinthidwe zidzakambidwa m’chigawo chotsatira cha nkhaniyo.

Mavuto pa kutembenuka ndi njira zawo

Kwa nthawi yonse yomwe mawonekedwe a CSV adakhalapo, palibe amene adavutikira kulemba. Choncho, ngakhale zimaganiziridwa kuti commas iyenera kugwiritsidwa ntchito kulekanitsa zikhalidwe, makamaka, zolemba zosiyanasiyana zimagwiritsa ntchito zolekanitsa zosiyana - semicolons, tabo, ndi zina.

Zolemba malire zimathanso kusiyanasiyana - nthawi zambiri amakhala ma quotation marks kapena ma byte order mark. Pakhoza kukhala palibe malire aliwonse - ndiye kuti mawonekedwe omwe amagwiritsidwa ntchito ngati olekanitsa nthawi zonse amawazindikira (ndiye nthawi zambiri si koma - amagwiritsidwa ntchito nthawi zambiri m'malemba - koma osiyana, osadziwika bwino).

Mafayilo osakhala ovomerezeka sangatsegule bwino - kuti awonetsedwe momwe akuyenera, muyenera kusintha makonzedwe apakompyuta kapena pulogalamu yotsegulira. Tiyeni tiwone zovuta zomwe zilipo komanso njira zothetsera mavutowo.

Fayiloyo simatseguka bwino

Umboni. Zonse zomwe zili m'chikalatacho zayikidwa mugawo loyamba.

Chifukwa. Chikalatacho chimagwiritsa ntchito mawonekedwe ngati chodulira chomwe sichinasankhidwe motere pamakonzedwe apakompyuta, kapena amasungidwa ntchito ina. Mwachitsanzo, comma ikhoza kusungidwa kuti ilekanitse magawo a chiwerengero cha nambala, choncho sangathe kulekanitsa zofunikira mu fayilo.

Solutions. Pali njira zosiyanasiyana zothetsera vutoli:

1. Sinthani mawonekedwe olekanitsa mu chikalata chomwe. Tsegulani mu Notepad kapena mkonzi wofananira, ndipo pamzere woyamba (wopanda kanthu, zonse ziyenera kukhala m'mizere ili pansipa), lowetsani mawu otsatirawa:

• kusintha cholekanitsa kukhala comma: Sep
• kusintha kukhala semicolon: sep=;

Munthu wina wolembedwa pambuyo pake sep = mu mzere woyamba, adzakhalanso delimiter.

2. Makhalidwe olekanitsa omwe amagwiritsidwa ntchito mufayilo amathanso kufotokozedwa mu Excel palokha. M'mitundu ya 2016, 2013 kapena 2010, chifukwa chake muyenera kutsegula tabu. Deta ndi kusankha "Mawu ndi mizere” mu gulu"Kugwira ntchito ndi data ".

Izi zidzatsegula zenera "Wizards pogawa zolemba m'mizere". Kumeneko, kuchokera pamawonekedwe a deta, muyenera kusankha omwe ali ndi olekanitsa. Ndiye muyenera kukanikiza Ena ndipo, pambuyo posankha delimiter, chitsiriziro.

3. Kuti mutsegule chikalata ndi Import Wizard, osati mu pepala la Excel lokha, kuwonjezerako kungasinthidwe kuchokera ku .csv kupita ku .txt. AT ambuye ndizotheka kufotokozera munthu aliyense ngati wolekanitsa - momwe angachitire izi, nkhaniyo idafotokozedwa kale.
4. Gwiritsani ntchito VBA. Mungagwiritse ntchito, mwachitsanzo, - ndi yoyenera kwa Excel 2000 kapena 2003. Khodiyo ikhoza kusinthidwa kuti ikhale yoyenera kumasulira ena.

Mayankho omwe aperekedwa pamwambapa adapangidwa kuti azilemba payekhapayekha, zokonda zake zomwe zimasiyana ndi zomwe zimachitika nthawi zonse. Zotsatirazi ziyenera kugwiritsidwa ntchito pa fayilo iliyonse yomwe siyikutsegula bwino. Ngati zolemba zambiri sizikutsegula molondola, mwinamwake njira yabwino yothetsera makonzedwe a makompyuta - izi zikukambidwa mu yankho lachisanu.

5. Sinthani cholekanitsa ndi decimal point muzokonda pakompyuta

В Gawo lowongolera, otchedwa ndi batani Start, sankhani "Zowonjezera" kuchokera pamndandanda"Miyezo Yachigawo”. Pambuyo kuwonekera, zenera adzaonekaKukonzekera kwa Format" - momwemo mutha kusankha"Olekanitsa Mndandanda” ndi cholekanitsa cha chiwerengero ndi magawo a chiwerengerocho. Ngati mafayilo amafunikira koma monga delimiter, choyamba ikani nthawiyo ngati malo owerengera. Zitha kukhala mwanjira ina - mufunika semicolon ngati munthu wolekanitsa. Ndiye kwa tizigawo tating'ono, mutha kusiya chizindikiro chilichonse, izi sizingayambitse mkangano.

Zokonda zonse zikamalizidwa, dinani OK pa mazenera awiri otseguka - adzatseka ndipo zosintha zidzapulumutsidwa. Kumbukirani kuti tsopano ntchito mapulogalamu onse pa kompyuta.

Chotsani ziro zotsogola

chizindikiro. Zina mwazinthu zomwe zili muzolemba zoyambira ndi manambala omwe amayamba ndi ziro omwe samasiyanitsidwa ndi chizindikiro cha magawo (mwachitsanzo, ma ciphers ndi ma code okhala ndi manambala okhazikika, ma logins ndi mapasiwedi, kuwerengera kwa mita ndi zida). Mu Excel, ziro kumayambiriro kwa manambalawa zimasowa. Ngati musintha fayilo ndikuyisunga ngati bukhu la Excel, sikuthekanso kupeza m'bukuli pomwe manambala okhala ndi ziro anali.

Chifukwa. Excel ili ndi mawonekedwe osiyana a zolemba ndi manambala. M'mafayilo apamawu, palibe kulekanitsa koteroko, chifukwa chake Excel imagawira mawonekedwe a General pamakhalidwe onse. Zikutanthauza kuti mawu amawonetsedwa ngati mawu, ndipo manambala opanda zilembo amawonetsedwa ngati nambala yomwe singayambe ndi ziro.

Anakonza. Sinthani chiwonjezeko kukhala .txt kuti mutsegule Import Wizard mukatsegula chikalatacho. Mukafika pa Gawo 3, sinthani mawonekedwe a mizati yokhala ndi manambala omwe amayamba ndi ziro kukhala mawu.

Zina mwazinthu zimawoneka ngati madeti

chizindikiro. Madeti amawonetsa mitengo yomwe ili ndi mawu osamveka kapena manambala.

Chifukwa. Mtundu wamba umaphatikizapo kutembenuza mitengo kukhala madeti ofanana ndi a Excel. Ngati chikalata cha CSV chili ndi mtengo umodzi ngati may12, ndiye patsamba la Excel lidzawonetsedwa ngati tsiku.

Anakonza. Zofanana ndi zomwe zidachitika m'mbuyomu. Sinthani zowonjezera kukhala .txt, in ambuye sinthani mawonekedwe amtengo wosinthidwa kukhala madeti kukhala mawu.

Ngati, m'malo mwake, mukufuna kuwonetsa zomwe zili mugawo linalake ngati masiku, ikani mtundu wake tsiku. Pali mitundu ingapo ya mtundu wa deti, ndiye sankhani yomwe mukufuna pamndandanda.

Momwe mungasinthire mafayilo angapo a CSV ku Excel

Excel imatha kutsegula mafayilo angapo a CSV nthawi imodzi.

1. Press Fayilo> Tsegulani ndipo sankhani kusankha Mafayilo olemba kuchokera pamndandanda wotsitsa pansipa.
2. Kuti musankhe mafayilo angapo mbali imodzi, choyamba sankhani yoyamba, kenako dinani kosangalatsa ndipo dinani pa yomaliza. Kuphatikiza pa mafayilo osankhidwa, mafayilo onse omwe ali pakati adzasankhidwa.
3. Dinani Open.

Choyipa cha njirayi ndikuti fayilo iliyonse yosankhidwa idzatsegulidwa padera mu Excel. Kuchoka pa chikalata chimodzi kupita ku chimzake kukhoza kuonjezera nthawi. Komabe, ndizotheka kukopera zonse zomwe zili m'mapepala a m'buku lomwelo.

Kufotokozera kunali kwautali, komabe, tsopano mudzatha kutsegula fayilo iliyonse ya CSV ku Excel popanda zovuta. Ngati china chake chikuwoneka chosamvetsetseka poyang'ana koyamba, tsatirani njira zomwe zasonyezedwa ndipo zonse zidzamveka bwino.