Ukuguqula i-CSV ibe yi-Excel: Ungawangenisa kanjani Amafayela e-CSV ku-Excel Spreadsheets

Kulesi sihloko, uzothola izindlela ezi-2 ezilula zokuguqula ifayela le-CSV libe yi-Excel. Ngaphezu kwalokho, uzofunda ukuthi ungangenisa kanjani amafayela e-CSV amaningi ku-Excel nokuthi ungabhekana kanjani nezimo lapho ingxenye yedatha evela kufayela le-CSV ingabonisi kahle eshidini le-Excel.

Muva nje, siqale ukufunda izici zefomethi ye-CSV (Amanani Ahlukaniswe Ngokhefana) kanye nezinhlobonhlobo. izindlela zokuguqula ifayela le-Excel libe yi-CSV. Namuhla sizokwenza inqubo yokuhlehla - ukungenisa i-CSV ku-Excel.

Lesi sihloko sizokukhombisa ukuthi ungayivula kanjani i-CSV ku-Excel nokuthi ungangenisa kanjani amafayela e-CSV amaningi ngesikhathi esisodwa. Sizophinde sibone izingibe ezingaba khona futhi sinikeze izixazululo eziphumelela kakhulu.

• Ungayiguqula kanjani i-CSV ibe yi-Excel
• Ukuguqula i-CSV ibe yi-Excel: Izinkinga Nezixazululo

Ungayiguqula kanjani i-CSV ibe yi-Excel

Uma udinga ukudonsa ulwazi oluthile eshidini le-Excel kusizindalwazi senkampani yakho, umqondo wokuqala ofikayo engqondweni owokuthekelisa isizindalwazi kufayela le-CSV bese ungenisa ifayela le-CSV ku-Excel.

Kunezindlela ezi-3 zokuguqula i-CSV ibe yi-Excel: Ungakwazi ukuvula ifayela ngokunwetshwa . Csv ngqo ku-Excel, chofoza kabili ifayela ku-Windows Explorer, noma ngenisa i-CSV ku-Excel njengomthombo wedatha wangaphandle. Ngokulandelayo, ngizonaba ngalezi zindlela ezintathu futhi ngiveze izinzuzo nezinkinga zazo ngayinye yazo.

• Indlela 1: Vula ifayela le-CSV ku-Excel
• Indlela 2: Vula ifayela le-CSV ku-Excel usebenzisa i-Windows Explorer
• Indlela 3: Ngenisa i-CSV ku-Excel

Ungalivula kanjani ifayela le-CSV ku-Excel

Noma ngabe ifayela le-CSV ladalwa kolunye uhlelo, ungakwazi ukulivula njengencwadi yokusebenzela ye-Excel usebenzisa umyalo Vula (Vula).

Qaphela: Ukuvula ifayela le-CSV ku-Excel akushintshi ifomethi yefayela. Ngamanye amazwi, ifayela le-CSV ngeke liguqulelwe kufayela le-Excel (.xls noma ifomethi ye-xlsx), lizogcina uhlobo lwalo lwangempela (.csv noma .txt).

1. Yethula i-Microsoft Excel, ithebhu Ikhaya (Ekhaya) chofoza Vula (Vula).
2. Ibhokisi lengxoxo lizovela Vula (Ukuvula idokhumenti), ohlwini lokudonsela phansi ekhoneni elingezansi kwesokudla, khetha Amafayela wombhalo (Amafayela ombhalo).
3. Thola ifayela le-CSV ku-Windows Explorer bese ulivula ngokuchofoza kabili kulo.

Uma uvula ifayela le-CSV, i-Excel izolivula ngokushesha ngokufaka idatha ebhukwini lokusebenza elisha le-Excel. Uma uvula ifayela lombhalo (.txt), i-Excel izovula Iseluleki Sokungenisa Umbhalo. Funda kabanzi ngalokhu ekungeniseni i-CSV ku-Excel.

Qaphela: Lapho i-Microsoft Excel ivula ifayela le-CSV, isebenzisa izilungiselelo zokufometha ezizenzakalelayo ukuze ithole ukuthi ungenisa kanjani ikholomu ngayinye yedatha.

Uma idatha ifana okungenani nento eyodwa kwezilandelayo, sebenzisa Iwizadi Yokungenisa Umbhalo:

• Ifayela le-CSV lisebenzisa ama-delimiters ahlukene;
• Ifayela le-CSV lisebenzisa amafomethi edethi ahlukahlukene;
• Uguqula idatha efaka izinombolo ezinoziro oholayo, futhi ufuna ukugcina lowo ziro;
• Ufuna ukubuka kuqala ukuthi idatha evela kufayela le-CSV izongeniswa kanjani ku-Excel;
• Ufuna ukuguquguquka okwengeziwe emsebenzini wakho.

Ukwenza i-Excel iqalise Iwizadi Yokungenisa Umbhalo, ungashintsha isandiso sefayela usuka kuso . Csv on .txt (ngaphambi kokuvula ifayela), noma ngenisa i-CSV ku-Excel njengoba kuchazwe ngezansi.

Ungalivula kanjani ifayela le-CSV usebenzisa iWindows Explorer

Lena indlela eshesha kakhulu yokuvula i-CSV ku-Excel. Ku-Windows Explorer, chofoza kabili ifayela . Csv, futhi izovuleka njengencwadi yokusebenzela entsha ye-Excel.

Nokho, le ndlela izosebenza kuphela uma i-Microsoft Excel isethwe njengohlelo oluzenzakalelayo lokuvula amafayela. . Csv. Uma kunjalo, uzobona isithonjana esijwayelekile ku-Windows Explorer eduze kwegama lefayela.

Uma i-Excel kungelona uhlelo oluzenzakalelayo, nansi indlela ongalulungisa ngayo:

1. Chofoza kwesokudla kunoma yiliphi ifayela . Csv ku-Windows Explorer nakumenyu yokuqukethwe evulayo, chofoza Vula nge (Vula nge) > Khetha uhlelo oluzenzakalelayo (Khetha uhlelo).
2. Khetha Excel ohlwini lwezinhlelo ezinconyiwe, qiniseka ukuthi kunophawu lokuhlola lwenketho Njalo sebenzisa uhlelo olukhethiwe ukuze vula lolu hlobo lwefayela (Sebenzisa njalo uhlelo olukhethiwe lwalolu hlobo lwefayela) bese uchofoza OK.

Uyingenisa kanjani i-CSV ku-Excel

Ngale ndlela ungangenisa idatha efayelini . Csv eshidini elikhona noma elisha le-Excel. Ngokungafani nezindlela ezimbili ezedlule, ayivuli nje i-CSV ku-Excel, kodwa iguqula ifomethi . Csv в . Xlsx (uma usebenzisa i-Excel 2007, 2010 noma 2013) noma .xls (ezinguqulweni ze-Excel 2003 nangaphambilini).

1. Vula ishidi le-Excel olifunayo bese uchofoza kuseli lapho ufuna ukungenisa khona idatha kufayela . Csv or .txt.
2. Kuthebhu ethuthukisiwe Idatha (Idatha) esigabeni Thola idatha yangaphandle (Thola idatha yangaphandle) chofoza Kusuka Embhalweni (Kusuka embhalweni).
3. Thola ifayela . Csvofuna ukuyingenisa, ikhethe bese uchofoza Ngenisa (Ngenisa), noma vele uchofoze kabili kufayela le-CSV olifunayo.
4. Iwizadi Yokungenisa Umbhalo izovuleka, udinga nje ukulandela izinyathelo zayo.

Ngaphambi kokuthi siqhubeke, sicela ubheke isithombe-skrini esingezansi, sibonisa ifayela le-CSV loqobo kanye nomphumela ofunekayo ku-Excel. Ngethemba ukuthi lokhu kukusiza ukuthi uqonde kangcono ukuthi kungani sikhetha izilungiselelo ezithile esibonelweni esilandelayo.

4. 
   • Isinyathelo 1. Khetha ifomethi yedatha nenombolo yolayini ongaqala ngayo ukungenisa. Okuvame ukukhethwa Kunqunyelwe (Ngezihlukanisi) kanye nentambo 1. Indawo yokubuka kuqala engaphansi kwebhokisi lengxoxo lewizadi ibonisa amarekhodi ambalwa okuqala efayela le-CSV elingenisiwe.
   • Isinyathelo 2. Kulesi sinyathelo, udinga ukukhetha ama-delimiters nesinqamuli somugqa. i-delimiter (Delimiter) uhlamvu oluhlukanisa amanani kufayela le-CSV. Uma ifayela lakho le-CSV lisebenzisa uphawu olungekho ohlwini oluhlongozwayo, bese uthikha ibhokisi Izincwajana zemininingwane (Okunye) bese ufaka uhlamvu olufunayo. Esibonelweni sethu, sibalule Ithebhu (Uhlamvu lwethebhu) kanye Qalisa (Ukhefana) ukuze umkhiqizo ngamunye (uhlukaniswe ngamathebhu) uqale emugqeni omusha, futhi ulwazi lomkhiqizo, olufana ne-ID nedatha yokuthengisa (kuhlukaniswe ngokhefana), kubekwe kumaseli ahlukene.Ukufaneleka kombhalo (isinqamuli somugqa) wuhlamvu oluhlanganisa amanani angawodwana. Wonke umbhalo ofakwe phakathi kwezinhlamvu ezinjalo, njengokuthi “umbhalo1, umbhalo2”, uzongeniswa njengenani elilodwa, ngisho noma umbhalo uqukethe uhlamvu olucacisile njengolunqunyiwe. Kulesi sibonelo, sicacise ukhefana njenge-delimiter kanye nezimpawu zokucaphuna njengesinqamuli somugqa. Ngenxa yalokho, zonke izinombolo ezinesehlukanisi sedesimali (okuphinde kube ukhefana kithi!) zizongeniswa kuseli eyodwa, njengoba kungabonakala endaweni yokubuka kuqala esithombeni esingezansi. Uma singacacisi izingcaphuno njengesinqamuli seyunithi yezinhlamvu, zonke izinombolo zizongeniswa kumaseli ahlukene.

     

   • Isinyathelo 3. Bheka endaweni Ukuhlola kuqala idatha (Isampula yokuhlaziya idatha). Uma ujabulile ngendlela idatha yakho ebukeka ngayo, bese uchofoza inkinobho Qeda (Lungile).

Ithiphu: Uma ifayela lakho le-CSV lisebenzisa ukhefana olandelanayo noma olunye uhlamvu lwe-delimiter ngokulandelana, qoka ibhokisi Phatha abahlukanisi abalandelanayo njengento eyodwa (Bala ama-delimiters alandelanayo njengento eyodwa) ukuze ugweme amaseli angenalutho.

5. Khetha ukuthi uyayinamathisela yini idatha engenisiwe eshidini elikhona noma eshidini elisha, bese uchofoza OKukuze uqedele ukungenisa ifayela le-CSV ku-Excel.

Ithiphu: Ungacindezela inkinobho Izakhiwo (Izakhiwo) ukuze ulungiselele izilungiselelo ezithuthukile njengokubuyekeza, isakhiwo, nokufometha kwedatha engenisiwe.

Qaphela: Uma ifayela lakho le-CSV liqukethe izinombolo noma amadethi, i-Excel ingase ingaziguquleli ngendlela efanele. Ukushintsha ifomethi yedatha engenisiwe, khetha ikholomu(ama)kholomu enamaphutha, chofoza kwesokudla kuwo bese ukhetha kumenyu yokuqukethwe. Fometha amaseli (ifomethi yeseli).

Ukuguqula i-CSV ibe yi-Excel: Izinkinga Nezixazululo

Ifomethi ye-CSV isisetshenziswe iminyaka engaphezu kwengu-30, kodwa ngaphandle komlando wayo omude, ayikaze ibhalwe ngokusemthethweni. Igama elithi CSV (Amanani Ahlukaniswe Ngokhefana) livela ekusetshenzisweni kokhefana ukuhlukanisa izinkambu zedatha. Kodwa lokho kusezingqondweni. Eqinisweni, amafayela amaningi abizwa ngokuthi amafayela e-CSV asebenzisa ezinye izinhlamvu ukuze ahlukanise idatha, isibonelo:

• Amathebhu - amafayela e-TSV (amanani ahlukaniswe ngamathebhu)
• I-semicolon - amafayela e-SCSV (amanani ahlukene we-semicolon)

Okunye ukuhlukahluka kwamafayela e-CSV kuhlukanisa izinkambu zedatha ngezingcaphuno eyodwa noma ezimbili, ezinye zidinga Umaka Wokulandelana we-Unicode Byte (BOM), njenge-UTF-8, ukuze atolike i-Unicode ngendlela efanele.

Lokhu kuntuleka kwezindinganiso kudala izinkinga ezihlukahlukene ongase uhlangabezane nazo lapho uzama guqula ifayela le-excel libe yi-csv, futhi ikakhulukazi lapho ungenisa ifayela le-CSV ku-Excel. Ake sibheke izindaba ezaziwayo, siqale ngezivame kakhulu.

• Ifayela le-CSV liboniswa ngokungalungile ku-Excel (yonke idatha ibekwe kukholomu yokuqala)
• Oziro abahamba phambili balahleke ngenkathi kuvulwa ifayela le-CSV ku-Excel
• Amanani aguqulwa abe yizinsuku lapho kufakwa ifayela le-CSV ku-Excel

Ifayela le-CSV alibonisi kahle ku-Excel

izimpawu: Uzama ukuvula ifayela le-CSV ku-Excel futhi yonke idatha igcina kukholamu yokuqala.

Isizathu: Umsuka wenkinga ukuthi izilungiselelo zakho zesifunda nezilimi ze-Windows kanye nefayela lakho le-CSV linama-delimiter ahlukene. ENyakatho Melika nakwamanye amazwe, isihlukanisi sohlu esimisiwe siwukhefana. Ngenkathi emazweni ase-Europe ikhoma isetshenziswa njengesihlukanisi sendawo yedesimali futhi isihlukanisi senkundla yohlu siyi-semicolon.

Isinqumo: Kunezixazululo ezimbalwa zale nkinga. Ungabheka ngokushesha izincomo ezingezansi bese ukhetha okufanele kakhulu umsebenzi wakho othile.

1. Cacisa i-delimiter elungile ngokuqondile kufayela le-CSV. Vula ifayela le-CSV kunoma yimuphi umhleli wombhalo (ngisho nencwajana evamile izokwenza) bese unamathisele umbhalo olandelayo emugqeni wokuqala. Qaphela ukuthi lokhu kufanele kube umugqa ohlukile ngaphambi kwanoma iyiphi enye idatha:
   • Ukusetha isihlukanisi sokhefana: Septhemba
   • Ukusetha isihlukanisi sibe isemicolon: isiqephu =;

   Njengoba ungase uqagele, ngale ndlela ungasetha noma iyiphi enye uhlamvu njengesihlukanisi ngokumane uyicacise ngokushesha ngemva kophawu olulinganayo.

2. Khetha i-delimiter oyifunayo ku-Excel. Ku-Excel 2013 noma 2010 kuthebhu Idatha (Idatha) esigabeni Amathuluzi Edatha (Sebenza ngedatha) chofoza Umbhalo Uya Kumakholomu (Umbhalo ngamakholomu).Uma Iseluleki Sombhalo Wekholomu siqala, esinyathelweni sokuqala, khetha ifomethi yedatha Kunqunyelwe (ngezihlukanisi) bese ucindezela Olandelayo (Okwengeziwe). Esinyathelweni sesibili, khetha i-delimiter oyifunayo bese uchofoza Qeda (Lungile).

   

3. Shintsha isandiso kusuka . Csv on .txt. Ivula ifayela .txt ku-Excel izokwethula Iwizadi Yokungenisa Umbhalo, futhi uzokwazi ukukhetha i-delimiter oyifunayo, njengoba kuchazwe esigabeni Indlela Yokungenisa i-CSV ku-Excel.
4. Vula ifayela le-CSV elinesemicolon njengesihlukanisi usebenzisa i-VBA. Nali isampula lekhodi ye-VBA evula ifayela le-CSV ku-Excel esebenzisa isemicolon njengesihlukanisi. Ikhodi yabhalwa eminyakeni embalwa edlule ngezinguqulo zangaphambili ze-Excel (2000 kanye no-2003), kodwa uma ujwayelene kahle ne-VBA, akufanele ube nenkinga yokuyibuyekeza noma ukuyishintsha ukuze isebenze ngamafayela e-CSV ahlukaniswe ngokhefana.

Qaphela: Zonke izixazululo ezibonisiwe zishintsha kuphela i-delimiter yefayela le-CSV elinikeziwe. Uma ufuna ukushintsha isihlukanisi esimisiwe kanye unomphela, isixazululo esilandelayo sizokufanela.

5. Sishintsha izihlukanisi kuzilungiselelo zamazinga esifunda. Chofoza inkinobho Ikhaya (qala) bese ugijima Iphaneli yokulawula (Iphaneli yokulawula), chofoza into Isifunda nolimi (Izindinganiso zesifunda) > Izilungiselelo ezengeziwe (Izinketho ezengeziwe). Ibhokisi lengxoxo lizovuleka Enza ngendlela oyifisayo Ifomethi (Isilungiselelo sefomethi) lapho udinga ukukhetha ichashazi (.) lepharamitha Uphawu lwedesimali (I-Integer/Decimal Separator), bese usetha ikhoma (,) yepharamitha Isihlukanisi sohlu (Isihlukanisi sezinto zohlu).

Inothi Lomhumushi: Lezi zilungiselelo zinikezwe ukwenziwa kwasendaweni kwesiNgisi kwe-Excel (kanye nenani lamanye amazwe). Ngokwenza okwasendaweni, kuzovama kakhulu ukusebenzisa ikhoma njengesihlukanisi sedesimali kanye nesemikholoni ukuze kuhlukaniswe izinto zohlu.

5. Thepha kabili OKukuvala amabhokisi ezingxoxo – usuqedile! Kusukela manje kuqhubeke, i-Microsoft Excel izovula futhi ibonise wonke amafayela e-CSV (ahlukaniswe ukhefana) ngendlela efanele.

Qaphela: Ukusetha Iphaneli Yokulawula ye-Windows ibe izihlukanisi zamadesimali nezinto zohlu kuzoshintsha izilungiselelo zezinhlamvu ezimisiwe zazo zonke izinhlelo ezikukhompyutha yakho, hhayi i-Microsoft Excel kuphela.

Oziro abahamba phambili bayalahleka uma kuvulwa ifayela le-CSV ku-Excel

izimpawu: Ifayela lakho le-CSV liqukethe amanani anoziro abaholayo futhi lawo maziro ayalahleka lapho kuvulwa ifayela le-CSV ku-Excel.

Isizathu: Ngokuzenzakalelayo, i-Microsoft Excel ibonisa ifayela le-CSV ngefomethi General (Okuvamile), lapho oziro abaholayo bancishiswa khona.

Isinqumo: Esikhundleni sokuvula ifayela le-.csv ku-Excel, sebenzisa Iseluleki Sokungenisa Umbhalo njengoba senza ngaphambili ukuze uguqule ifayela le-CSV libe yi-Excel.

Esinyathelweni sesi-3 sewizadi, khetha amakholomu aqukethe amanani anoziro abaholayo bese ushintsha ifomethi yalawa makholomu ibe umbhalo. Lena yindlela oguqula ngayo ifayela lakho le-CSV libe yi-Excel, ugcine oziro besendaweni.

I-Excel iguqula amanani athile abe yizinsuku lapho ivula ifayela le-CSV

izimpawu: Amanye amanani kufayela lakho le-CSV abukeka njengezinsuku, futhi i-Excel izoguqula ngokuzenzakalelayo amanani anjalo ukusuka kufomethi yombhalo kuya kufomethi yedethi.

Isizathu: Njengoba kushiwo ngenhla, i-Excel ivula ifayela le-CSV ngefomethi General (Okuvamile), okuguqula amanani afana nedethi ukusuka kufomethi yombhalo kuya kufomethi yedethi. Isibonelo, uma uvula ifayela le-CSV eliqukethe ukungena ngemvume komsebenzisi, okufakiwe okuthi “Apr23” kuzoguqulelwa idethi.

Isinqumo: Guqula ifayela le-CSV libe yi-Excel usebenzisa Iwizadi Yokungenisa Umbhalo. Esinyathelweni sesi-3 sewizadi, khetha amakholomu anamarekhodi afana namadethi bese ushintsha ifomethi yekholomu ibe umbhalo.

Uma udinga ukuzuza umphumela ophambene, okungukuthi, kukholamu ethile, guqula amanani abe yizinsuku, bese usetha ifomethi. Usuku (Usuku) bese ukhetha ifomethi yedethi efanele ohlwini lokudonsela phansi.

Ungawangenisa kanjani amafayela e-CSV amaningi ku-Excel

Ngicabanga ukuthi uyazi ukuthi iMicrosoft Excel ikuvumela ukuthi uvule amafayela e-CSV amaningi usebenzisa umyalo Vula (Vula).

1. Kuthebhu ethuthukisiwe Ifilimu (Ifayela) chofoza Vula (Vula) futhi ohlwini lokudonsela phansi ngezansi kwesokudla sebhokisi lengxoxo, khetha Amafayela wombhalo (Amafayela ombhalo).
2. Ukuze ukhethe amafayela amaningi ngokulandelana, chofoza ifayela lokuqala, bese ucindezela bese ubamba Shift, chofoza ifayela lokugcina. Womabili lawa mafayela, kanye nakho konke okuphakathi, azokhethwa. Ukuze ukhethe amafayela angekho emugqeni, cindezela ukhiye Ctrl bese uchofoza ifayela ngalinye . Csvufuna ukuvula.
3. Uma wonke amafayela e-CSV afunwayo ekhethiwe, chofoza inkinobho Vula (Vula).

Le ndlela ilula futhi iyashesha, futhi singayibiza ngenhle kakhulu, uma kungenjalo esimweni esisodwa - ifayela ngalinye le-CSV livuleka ngale ndlela njengencwadi yokusebenzela ye-Excel ehlukile. Empeleni, ukushintshela emuva naphambili phakathi kwamafayela e-Excel amaningi avulekile kungase kuphazamise kakhulu futhi kube umthwalo.

Ngethemba ukuthi manje ungakwazi ukuguqula kalula noma yiliphi ifayela le-CSV libe yi-Excel. Uma unemibuzo noma ubunzima, zizwe ukhululekile ukungibhalela kumazwana. Futhi ngiyabonga ngokubekezela kwawo wonke umuntu okwazile ukufunda lesi sihloko eside kuze kube sekugcineni! 🙂