Shigo abubuwan da ke cikin fayil ɗin CSV zuwa Excel

CSV sanannen tsawo ne na fayil wanda galibi ana amfani dashi don musayar bayanai tsakanin shirye-shiryen kwamfuta daban-daban. Mafi sau da yawa, babu buƙatar buɗewa da gyara irin waɗannan takaddun. Koyaya, a wasu lokuta, masu amfani na iya fuskantar irin wannan aikin. Excel yana ba ku damar yin wannan, amma sabanin daidaitattun fayiloli a cikin tsari xls и XLSX, kawai buɗe takarda ta danna linzamin kwamfuta sau biyu ba koyaushe yana ba da sakamako mai inganci ba, wanda zai iya haifar da bayyanar da kuskure. Bari mu ga yadda zaku iya buɗe fayilolin CSV a cikin Excel.

Buɗe fayilolin CSV

Da farko, bari mu gano menene takardu a cikin wannan tsari.

CSV gajarta ce da ke tsaye ga "Dabi'u Masu Raba Waƙafi" (na nufin "darajar da aka raba ta waƙafi").

Kamar yadda sunan ke nunawa, waɗannan takaddun suna amfani da masu iyakancewa:

• waƙafi – a cikin Turanci versions;
• semicolon - a cikin nau'ikan shirin.

Lokacin buɗe daftarin aiki a Excel, babban aiki (matsala) shine zaɓi hanyar ɓoye bayanan da aka yi amfani da shi lokacin adana fayil ɗin. Idan an zaɓi ɓoyayyen ɓoye ba daidai ba, mai amfani zai iya ganin yawancin haruffa waɗanda ba za a iya karantawa ba, kuma za a rage amfanin bayanin. Bugu da ƙari, maƙasudin da aka yi amfani da shi yana da mahimmanci. Misali, idan an adana daftarin aiki a cikin sigar Turanci sannan kuka yi ƙoƙarin buɗe ta a cikin sigar, ingancin bayanan da aka nuna zai yi wahala sosai. Dalilin, kamar yadda muka ambata a baya, shi ne cewa nau'o'in nau'i daban-daban suna amfani da maɓalli daban-daban. Bari mu ga yadda za mu guje wa waɗannan matsalolin da yadda ake buɗe fayilolin CSV daidai.

Hanyar 1: Danna sau biyu ko ta hanyar menu na mahallin

Kafin ci gaba zuwa ƙarin hadaddun hanyoyin, bari mu dubi mafi sauƙi. Yana aiki ne kawai a lokuta inda aka ƙirƙiri / adana fayil ɗin kuma buɗe shi a cikin sigar shirin, wanda ke nufin cewa bai kamata a sami matsala tare da ɓoyewa da masu iyakancewa ba. Akwai zaɓuɓɓuka biyu masu yiwuwa, za mu kwatanta su a ƙasa.

An saita Excel azaman tsoho shirin don buɗe fayilolin CSV

Idan haka ne, zaku iya buɗe takaddar kamar kowane fayil - danna sau biyu kawai a kai.

An ba da wani shirin don buɗe fayilolin CSV ko ba a sanya su gaba ɗaya ba

Algorithm na aiki a cikin irin waɗannan yanayi shine kamar haka (amfani da Windows 10 a matsayin misali):

1. Muna danna-dama akan fayil ɗin kuma a cikin mahallin mahallin da ke buɗewa, mun tsaya kan umarnin "Don budewa da".
2. A cikin menu na taimako, tsarin zai iya ba da shirin Excel nan da nan. A wannan yanayin, danna kan shi, sakamakon abin da fayil ɗin zai buɗe (kamar danna sau biyu akan shi). Idan shirin da muke buƙata ba ya cikin jerin, danna kan abu "Zaɓi wani app".
3. Wani taga zai bayyana inda zamu iya zaɓar shirin (don faɗaɗa jerin zaɓuɓɓukan da ake da su, kuna buƙatar danna maɓallin "Ƙarin Apps") wanda kake son bude takardar. Neman abin da muke bukata kuma danna OK. Don sanya Excel ya zama tsohuwar aikace-aikacen wannan nau'in fayil, da farko duba akwatin da ya dace.
4. A wasu lokuta, lokacin da ba a iya samun Excel a cikin wannan taga, danna maɓallin "Nemi wani app akan wannan kwamfutar" a karshen jerin.
5. Wani taga zai bayyana akan allon da za mu je wurin shirin a kan PC, yi alama fayil ɗin da za a iya aiwatarwa tare da tsawo. Exe kuma danna maɓallin "Buɗe".

Ko da wanene daga cikin hanyoyin da aka kwatanta a sama, sakamakon zai zama buɗe fayil ɗin CSV. Kamar yadda muka ambata a sama, za a nuna abun cikin daidai ne kawai idan maɓalli da masu rarrabawa sun dace.

A wasu lokuta, wani abu kamar wannan na iya bayyana:

Saboda haka, hanyar da aka bayyana ba koyaushe ta dace ba, kuma muna ci gaba zuwa na gaba.

Hanyar 2: Aiwatar da Mayen Rubutun

Bari mu yi amfani da kayan aikin da aka haɗa cikin shirin - Rubutu Jagora:

1. Bayan buɗe shirin kuma ƙirƙirar sabon takarda, don samun damar duk ayyuka da kayan aikin yanayin aiki, canza zuwa shafin. "Bayanai"inda muka danna maballin "Samun bayanan waje". Daga cikin zaɓuɓɓukan da suka tashi, zaɓi "Daga rubutu".
2. Za a buɗe taga da muke buƙatar kewaya zuwa wurin da fayil ɗin da muke son shigo da shi yake. Bayan yin alama, danna maɓallin "Shigo".
3. The Rubutu Jagora. Bincika idan an zaɓi zaɓi "tare da separators" don siga "Tsarin bayanai". Zaɓin tsarin ya dogara ne da ɓoyayyen da aka yi amfani da shi lokacin adana shi. Daga cikin mafi mashahuri Formats ne "Cyrillic (DOS)" и Unicode (UTF-8). Kuna iya fahimtar cewa an yi zaɓin da ya dace ta hanyar mai da hankali kan samfoti na abubuwan da ke ƙasan taga. Dace a yanayinmu Unicode (UTF-8). Sauran sigogi galibi ba sa buƙatar tsari, don haka danna maɓallin "Dalee".
4. Mataki na gaba shine ayyana halin da ke aiki azaman mai iyakancewa. Tun da an ƙirƙiri / adana takaddun mu a cikin sigar shirin, muna zaɓar "Semicolon". Anan, kamar yadda yake a cikin zaɓin ɓoyewa, muna da damar gwada zaɓuɓɓuka daban-daban, kimanta sakamakon a cikin yankin samfoti (zaku iya, a tsakanin sauran abubuwa, ƙididdige halin ku ta zaɓi zaɓin. “Wani”). Bayan saita saitunan da ake buƙata, sake danna maɓallin. "Dalee".
5. A cikin taga ta ƙarshe, galibi, ba kwa buƙatar yin kowane canje-canje ga daidaitattun saitunan. Amma idan kuna son canza tsarin shafi, fara danna shi a ƙasan taga (filin "Sample"), sannan zaɓi zaɓin da ya dace. Danna lokacin da aka shirya "Shirya".
6. Wani taga zai bayyana inda zamu zaɓi hanyar shigo da bayanai (a kan wani data kasance ko akan sabon takarda) sannan danna OK.
   • a cikin yanayin farko, ya kamata ka saka adireshin tantanin halitta (ko barin ƙimar da aka saba) wanda zai zama ɓangaren hagu na sama na abun da aka shigo da shi. Kuna iya yin haka da hannu ta hanyar shigar da haɗin kai ta amfani da madannai, ko kuma kawai ta danna kan tantanin halitta da ake so akan takardar (ya kamata siginan kwamfuta ya kasance a cikin filin da ya dace don shigar da bayanai).
   • lokacin da kuka zaɓi zaɓin shigo da kaya akan sabuwar takardar, ba kwa buƙatar tantance masu daidaitawa.
7. Komai yana shirye, mun sami damar shigo da bayanan fayil ɗin CSV. Ba kamar hanyar farko ba, zamu iya lura cewa an mutunta ginshiƙan ginshiƙan, la'akari da abubuwan da ke cikin sel.

Hanyar 3: ta hanyar menu "Fayil".

Kuma hanya ta ƙarshe da zaku iya amfani da ita ita ce:

1. Bayan fara shirin, zaɓi abu "Buɗe".Idan an riga an buɗe shirin a baya kuma ana yin aiki akan takamaiman takarda, je zuwa menu "Fayil".Danna kan umarni "Buɗe" zuwa jerin umarni.
2. Danna maɓallin "Bita"don zuwa taga shugaba.
3. Zaɓi tsari "Duk fayiloli", je wurin da aka adana takardunmu, yi masa alama kuma danna maɓallin "Buɗe".
4. Abin da muka sani zai bayyana akan allon. Mayen shigo da rubutu. Sai mu bi matakan da aka zayyana a ciki Hanyar 2.

Kammalawa

Don haka, duk da rikitarwa na bayyane, shirin Excel yana ba ku damar buɗewa da aiki tare da fayiloli a cikin tsarin CSV. Babban abu shine yanke shawara akan hanyar aiwatarwa. Idan, lokacin buɗe daftarin aiki akai-akai (danna sau biyu ko ta menu na mahallin), abubuwan da ke cikin sa sun ƙunshi haruffa marasa fahimta, zaku iya amfani da Wizard Text, wanda ke ba ku damar zaɓar yanayin ɓoye da ya dace, wanda kai tsaye yana shafar daidaitaccen bayanan da aka nuna.