Yadda ake Canza Fayilolin Excel zuwa Tsarin CSV

CSV (Wakafi Rarraba Ƙimar) tsari ne na gama gari don adana bayanan tebur (lambobi da rubutu) a cikin rubutu na fili. Wannan tsarin fayil ɗin sananne ne kuma yana dawwama saboda gaskiyar cewa ɗimbin shirye-shirye da aikace-aikace sun fahimci CSV, aƙalla azaman madadin fayil ɗin don shigo da / fitarwa. Bugu da ƙari, tsarin CSV yana ba mai amfani damar duba fayil ɗin kuma nan da nan ya sami matsala tare da bayanan, idan akwai, canza madaidaicin CSV, faɗar ƙa'idodi, da sauransu. Wannan yana yiwuwa saboda CSV rubutu ne mai sauƙi, kuma ko da ƙwararren mai amfani zai iya fahimtarsa ​​cikin sauƙi ba tare da horo na musamman ba.

A cikin wannan labarin, za mu koyi hanyoyi masu sauri da inganci don fitar da bayanai daga Excel zuwa CSV kuma mu koyi yadda ake canza fayil ɗin Excel zuwa CSV ba tare da karkatar da duk haruffa na musamman da na waje ba. Dabarun da aka bayyana a cikin labarin suna aiki a duk nau'ikan Excel 2013, 2010 da 2007.

• Canza bayanai daga Excel zuwa tsarin CSV
• Fitarwa daga Excel zuwa tsarin CSV UTF-8 ko UTF-16
• Wasu hanyoyi don jujjuya daga Excel zuwa CSV (kiyaye haruffa na musamman)

Yadda ake Canza Fayil na Excel zuwa CSV

Idan kuna son fitar da fayil ɗin Excel zuwa wasu aikace-aikacen, kamar littafin adireshi na Outlook ko bayanan bayanai, da farko canza takaddar Excel zuwa fayil ɗin CSV, sannan shigo da fayil ɗin. . Csv zuwa wani aikace-aikace. Mai zuwa shine jagorar mataki zuwa mataki kan yadda ake fitar da littafin aikin Excel zuwa tsarin CSV ta amfani da kayan aikin Excel - "Ajiye azaman".

1. A cikin littafin aikin Excel, buɗe shafin fayil (Fayil) kuma danna Ajiye azaman (Ajiye azaman). Bugu da kari, akwatin maganganu Ajiye takarda (Ajiye azaman) ana iya buɗewa ta danna maɓallin F12.
2. a cikin Nau'in fayil (Ajiye azaman nau'in) zaɓi CSV (wanda waƙafi ya raba) (CSV (Wakafi iyaka)).Baya ga CSV (wanda aka iyakance waƙafi), akwai wasu zaɓuɓɓukan tsarin CSV da yawa:
   • CSV (wanda waƙafi ya raba) (CSV (Wakafi iyaka)). Wannan tsarin yana adana bayanan Excel azaman fayil ɗin rubutu mai waƙafi kuma ana iya amfani dashi a cikin wani aikace-aikacen Windows kuma a cikin wani nau'in tsarin aiki na Windows daban-daban.
   • CSV (Macintosh). Wannan tsari yana adana littafin aikin Excel azaman fayil mai iyaka don amfani akan tsarin aiki na Mac.
   • CSV (MS DOS). Ajiye littafin aikin Excel azaman fayil ɗin waƙafi don amfani a cikin tsarin aiki na MS-DOS.
   • unicode rubutu (Rubutun Unicode (*txt)). Wannan ma'auni yana samun goyan bayan kusan duk tsarin aiki na yanzu, gami da Windows, Macintosh, Linux, da Solaris Unix. Yana goyan bayan haruffa daga kusan duk na zamani har ma da wasu tsoffin harsuna. Don haka, idan littafin aikin Excel ya ƙunshi bayanai a cikin harsunan waje, Ina ba da shawarar ku fara adana shi a cikin tsari unicode rubutu (Rubutun Unicode (*txt)), sannan a canza zuwa CSV kamar yadda aka bayyana a baya a Fitarwa daga Excel zuwa UTF-8 ko UTF-16 CSV.

lura: Duk nau'ikan da aka ambata suna adana takardar Excel mai aiki ne kawai.

3. Zaɓi babban fayil don adana fayil ɗin CSV kuma danna Ajiye (Ajiye).Bayan danna Ajiye (Ajiye) akwatunan maganganu guda biyu zasu bayyana. Kada ku damu, waɗannan saƙonnin ba su nuna kuskure ba, haka ya kamata ya kasance.
4. Akwatin maganganu na farko yana tunatar da ku cewa Za a iya adana takardar yanzu a cikin fayil ɗin nau'in da aka zaɓa (Nau'in fayil ɗin da aka zaɓa baya goyan bayan littattafan aiki waɗanda ke ɗauke da zanen gado da yawa). Don ajiye takarda na yanzu kawai, danna kawai OK.Idan kana son adana duk zanen gado na littafin, sannan danna sokewa (Soke) kuma adana duk zanen gado na littafin daban-daban tare da sunayen fayilolin da suka dace, ko za ku iya zaɓar adana wani nau'in fayil ɗin da ke goyan bayan shafuka da yawa.
5. Bayan danna OK a cikin akwatin tattaunawa na farko, na biyu zai bayyana, yana mai gargadin cewa wasu fasaloli ba za su kasance ba saboda ba su da goyon bayan tsarin CSV. Wannan shine yadda yakamata ya kasance, don haka kawai danna A (Iya).

Wannan shine yadda za'a iya adana takaddar aikin Excel azaman fayil ɗin CSV. Mai sauri da sauƙi, kuma da wuya kowace matsala za ta iya tasowa a nan.

Fitarwa daga Excel zuwa CSV tare da rufaffen UTF-8 ko UTF-16

Idan takardar Excel ta ƙunshi kowane haruffa na musamman ko na ƙasashen waje (tilde, accent, da makamantansu) ko hieroglyphs, to, canza takardar Excel zuwa CSV ta hanyar da aka bayyana a sama ba zai yi aiki ba.

Ma'anar ita ce ƙungiyar Ajiye azaman > CSV (Ajiye azaman> CSV) zai sarrafa duk haruffa ban da ASCII (Ma'auni na Amurka don Musanya Bayanai). Kuma idan akwai ƙididdiga guda biyu ko dogayen dashes akan takardar Excel (canja wurin zuwa Excel, alal misali, daga takaddar Kalma lokacin kwafi / liƙa rubutu) - irin waɗannan haruffa kuma za a yanke su.

Magani Mai Sauƙi - Ajiye Sheet na Excel azaman Fayil ɗin Rubutu Unicode (.txt), sannan ku canza shi zuwa CSV. Ta wannan hanyar, duk haruffan da ba na ASCII ba za su kasance lafiyayyu.

Kafin in ci gaba, bari in ɗan yi bayanin manyan bambance-bambancen da ke tsakanin UTF-8 da UTF-16, ta yadda a kowane yanayi za ku iya zaɓar tsarin da ya dace:

• UTF-8 shi ne mafi ƙanƙantaccen ɓoyewa wanda ke amfani da 1 zuwa 4 bytes ga kowane hali. Mafi sau da yawa ana ba da shawarar yin amfani da wannan tsari lokacin da haruffan ASCII suka fi yawa a cikin fayil ɗin, saboda yawancin waɗannan haruffa suna buƙatar 1 byte na ƙwaƙwalwar ajiya. Wata fa'ida ita ce, shigar da fayil ɗin UTF-8 mai ɗauke da haruffan ASCII kawai ba zai bambanta ta kowace hanya daga fayil ɗin ASCII ɗaya ba.
• UTF-16 yana amfani da bytes 2 zuwa 4 don adana kowane hali. Lura cewa ba a kowane yanayi ba fayil UTF-16 yana buƙatar ƙarin sarari ƙwaƙwalwar ajiya fiye da fayil na UTF-8. Misali, haruffan Jafananci suna ɗaukar bytes 3 zuwa 4 a cikin UTF-8 da 2 zuwa 4 bytes a cikin UTF-16. Don haka, yana da ma'ana don amfani da UTF-16 idan bayanan sun ƙunshi haruffan Asiya, gami da Jafananci, Sinanci, da Koriya. Babban hasara na wannan rikodin shine cewa bai dace da fayilolin ASCII ba kuma yana buƙatar shirye-shirye na musamman don nuna irin waɗannan fayilolin. Yi la'akari da wannan idan kuna shirin shigo da fayilolin da aka samo asali daga Excel a wani wuri dabam.

Yadda ake Canza Fayil na Excel zuwa CSV UTF-8

A ce muna da takardar Excel tare da haruffan waje, a cikin misalinmu sunayen Jafananci ne.

Don fitar da wannan takardar Excel zuwa fayil ɗin CSV, yayin da muke adana duk hiroglyphs, za mu yi haka:

1. A cikin Excel, buɗe shafin fayil (Fayil) kuma danna Ajiye azaman (Ajiye azaman).
2. Shigar da sunan fayil a cikin filin Nau'in fayil (Ajiye azaman nau'in) zaɓi unicode rubutu (Rubutun Unicode (*.txt)) kuma danna Ajiye (Ajiye).
3. Bude fayil ɗin da aka ƙirƙira a kowane daidaitaccen editan rubutu, kamar Notepad.

lura: Ba duk masu gyara rubutu masu sauƙi ke goyan bayan haruffan Unicode ba, don haka wasu na iya bayyana azaman murabba'i. A mafi yawan lokuta, wannan ba zai shafi fayil ɗin ƙarshe ta kowace hanya ba, kuma kuna iya watsi da shi kawai ko zaɓi babban edita mai ci gaba, kamar Notepad++.

4. Tunda fayil ɗin rubutun Unicode ɗin mu yana amfani da harafin shafin azaman masu iyakancewa, kuma muna son musanya shi zuwa CSV (waƙafi mai iyaka), muna buƙatar maye gurbin haruffan shafin da waƙafi.

lura: Idan babu tsananin buƙatar samun fayil tare da maƙasudin waƙafi, amma kuna buƙatar kowane fayil na CSV wanda Excel zai iya fahimta, to ana iya tsallake wannan matakin, tunda Microsoft Excel daidai yake fahimtar fayiloli tare da mai iyakancewa - tabulation.

4. Idan har yanzu kuna buƙatar fayil ɗin CSV (rabu da waƙafi), to ku yi haka a cikin Notepad:
   • Zaɓi haruffan shafin, danna-dama akansa, kuma a cikin mahallin menu, danna Copy (Kwafi), ko kawai danna Ctrl + Ckamar yadda aka nuna a hoton da ke ƙasa.
   • latsa Ctrl + Hdon buɗe akwatin maganganu Canje (Maye gurbin) kuma liƙa halayen shafin da aka kwafi a cikin filin Wannan (Nemi me). A wannan yanayin, siginan kwamfuta zai matsa zuwa dama - wannan yana nufin cewa an saka alamar shafi. A cikin filin Than (Maye gurbin da) shigar da waƙafi kuma latsa Sauya duka (Maye gurbin duka).

   A cikin Notepad, sakamakon zai zama wani abu kamar haka:

   

5. Click fayil > Ajiye azaman (Fayil> Ajiye azaman), shigar da suna don fayil ɗin kuma a cikin jerin zaɓuka Encoding (Encoding) zaɓi UTF-8… Sannan danna maballin Ajiye (Ajiye).
6. Kaddamar da Windows Explorer kuma canza tsawo na fayil daga .txt on . Csv.Canja tsawo daban .txt on . Csv Kuna iya yin shi kai tsaye a cikin Notepad. Don yin wannan, a cikin akwatin maganganu Ajiye azaman (Ajiye azaman) a cikin filin Nau'in fayil (Ajiye azaman nau'in) zaɓi zaɓi Duk fayiloli (Duk fayiloli), kuma ƙara ".csv" zuwa sunan fayil a cikin filin da ya dace, kamar yadda aka nuna a cikin adadi na ƙasa.
7. Bude fayil ɗin CSV a cikin Excel, don wannan, akan shafin fayil (Filet) durƙusa Bude > Fayil ɗin rubutu (Buɗe> Fayilolin rubutu) kuma duba idan bayanan sun yi kyau.

lura: Idan fayil ɗin ku ana nufin amfani da shi a wajen Excel kuma tsarin UTF-8 buƙatu ne, to kada ku yi wani canje-canje a cikin takardar kuma kada ku sake ajiye shi a cikin Excel, saboda hakan na iya haifar da matsaloli tare da karanta rufaffiyar. Idan ba a nuna wani ɓangare na bayanan a cikin Excel, buɗe fayil iri ɗaya a cikin Notepad kuma gyara bayanan da ke cikinsa. Kar a manta da sake ajiye fayil ɗin a tsarin UTF-8.

Yadda ake Canza Fayil na Excel zuwa CSV UTF-16

Fitarwa zuwa fayil ɗin UTF-16 CSV yana da sauri da sauƙi fiye da fitarwa zuwa UTF-8. Gaskiyar ita ce Excel ta atomatik yana amfani da tsarin UTF-16 lokacin da kuka adana fayil ɗin azaman unicode rubutu (Rubutun Unicode).

Don yin wannan, ajiye fayil ɗin ta amfani da kayan aiki Ajiye azaman (Ajiye azaman) a cikin Excel sannan a cikin Windows Explorer, canza tsawo na fayil ɗin da aka ƙirƙira zuwa . Csv. Anyi!

Idan kuna buƙatar fayil ɗin CSV tare da ƙaramin ɗaki ko ƙaramin yanki a matsayin mai iyaka, maye gurbin duk haruffan shafi tare da waƙafi ko semicolons bi da bi a cikin Notepad ko kowane editan rubutu da kuka zaɓa (duba a baya a cikin wannan labarin don cikakkun bayanai kan yadda ake yin wannan).

Sauran Hanyoyi don Maida Fayilolin Excel zuwa CSV

Hanyoyin da aka bayyana a sama don fitar da bayanai daga Excel zuwa CSV (UTF-8 da UTF-16) na duniya ne, watau sun dace da aiki tare da kowane haruffa na musamman kuma a cikin kowane nau'i na Excel daga 2003 zuwa 2013.

Akwai sauran hanyoyi da yawa don sauya bayanai daga Excel zuwa tsarin CSV. Ba kamar hanyoyin da aka nuna a sama ba, waɗannan hanyoyin ba za su haifar da fayil ɗin UTF-8 mai tsabta ba (wannan baya shafi OpenOffice, wanda zai iya fitar da fayilolin Excel a cikin zaɓuɓɓukan shigar da UTF da yawa). Amma a mafi yawan lokuta, fayil ɗin da aka samu zai ƙunshi daidaitaccen saitin haruffa, wanda za'a iya jujjuya shi ba tare da wahala ba zuwa tsarin UTF-8 ta amfani da kowane editan rubutu.

Maida Fayil na Excel zuwa CSV Amfani da Google Sheets

Kamar yadda ya fito, yana da sauƙi don canza fayil ɗin Excel zuwa CSV ta amfani da Google Sheets. Idan har an riga an shigar da Google Drive akan kwamfutarka, bi waɗannan matakai guda 5 masu sauƙi:

1. A cikin Google Drive danna maɓallin Create (Ƙirƙiri) kuma zaɓi Table (Tattaunawa).
2. A kan menu fayil (Filet) durƙusa Import (Shigo).
3. Click Download (Loka) kuma zaɓi fayil ɗin Excel don loda daga kwamfutarka.
4. A cikin akwatin maganganu Incfayil ort (Shigo da fayil) zaɓi Sauya tebur (Maye gurbin maƙunsar bayanai) kuma danna Import (Shigo).

tip: Idan fayil ɗin Excel yana da ɗan ƙarami, to, don adana lokaci, zaku iya canja wurin bayanai daga gare ta zuwa maƙallan Google ta amfani da kwafi / manna.

5. A kan menu fayil (Filet) durƙusa Download as (Zazzage azaman), zaɓi nau'in fayil CSV – za a ajiye fayil ɗin akan kwamfutar.

A ƙarshe, buɗe fayil ɗin CSV da aka ƙirƙira a cikin kowane editan rubutu don tabbatar da cewa an adana duk haruffa daidai. Abin takaici, fayilolin CSV da aka ƙirƙira ta wannan hanyar ba koyaushe suke nunawa daidai a cikin Excel ba.

Ajiye fayil ɗin .xlsx azaman .xls sannan ka canza zuwa fayil ɗin CSV

Wannan hanyar ba ta buƙatar ƙarin sharhi, tunda komai ya riga ya bayyana daga sunan.

Na sami wannan mafita a ɗaya daga cikin dandalin da aka sadaukar don Excel, ban tuna wanne ba. A gaskiya, ban taɓa amfani da wannan hanyar ba, amma bisa ga yawancin masu amfani, wasu haruffa na musamman sun ɓace lokacin adanawa kai tsaye daga . Xlsx в . Csv, amma zauna idan farko . Xlsx ajiye as .xls, sannan kuma like . Csv, kamar yadda muka yi a farkon wannan labarin.

Ko ta yaya, gwada wannan hanyar ƙirƙirar fayilolin CSV daga Excel don kanka, kuma idan yana aiki, zai zama kyakkyawan tanadin lokaci.

Ajiye fayil ɗin Excel azaman CSV ta amfani da OpenOffice

OpenOffice babban buɗaɗɗen tushen aikace-aikace ne wanda ya haɗa da aikace-aikacen falle wanda ke yin babban aiki na fitar da bayanai daga Excel zuwa tsarin CSV. A haƙiƙa, wannan aikace-aikacen yana ba ku damar samun ƙarin zaɓuɓɓuka yayin canza maƙunsar bayanai zuwa fayilolin CSV (encoding, delimiters, da sauransu) fiye da yadda aka haɗa Excel da Google Sheets tare.

Kawai buɗe fayil ɗin Excel a cikin OpenOffice Calc, danna fayil > Ajiye azaman (Fayil> Ajiye azaman) kuma zaɓi nau'in fayil ɗin Rubutun CSV (Rubutun CSV).

Mataki na gaba shine zabar ma'auni Encoding (Settings Character) и Mai raba filin (Mai iyakance filin). Tabbas, idan muna son ƙirƙirar fayil ɗin UTF-8 CSV tare da waƙafi azaman masu iyakancewa, sannan zaɓi. UTF-8 kuma shigar da waƙafi (,) a cikin filayen da suka dace. Siga Mai raba rubutu (Mai iyakance rubutu) yawanci ana barin baya canzawa - alamomin magana ("). Danna gaba OK.

Hakazalika, don saurin juyawa mara zafi daga Excel zuwa CSV, zaku iya amfani da wani aikace-aikacen - LibreOffice. Na yarda, zai yi kyau idan Microsoft Excel ya ba da ikon daidaita saitunan lokacin ƙirƙirar fayilolin CSV.

A cikin wannan labarin, na yi magana game da hanyoyin da na sani game da canza fayilolin Excel zuwa CSV. Idan kun san ingantattun hanyoyi don fitarwa daga Excel zuwa CSV, da fatan za a gaya mana game da shi a cikin sharhi. Na gode da kulawa!