Yadda Ake Ƙirƙirar Fayil ɗin .CSV a Notepad

Fayil ɗin CSV rubutu ne kawai na yau da kullun. Wannan yana nufin ba kwa buƙatar Excel ko Google Sheets don ƙirƙirar ɗaya. Notepad, ko saurin notepad na yanar gizo, yana yin aikin cikin ƴan matakai kaɗan.

Menene fayil ɗin CSV?

CSV yana nufin Comma-Separated Values (dabi'u masu rarrabuwa da wakafi). Yana adana bayanai a cikin layuka, inda kowane ƙima a cikin layi yake rarrabuwa da wakafi. Ayyukan takaddun kididdiga (spreadsheet), bayanan bayanai, da rubutun shirye-shirye duk suna karanta wannan tsarin, wanda ke sa ya zama ɗaya daga cikin hanyoyin da suka fi dacewa don matsar da bayanai tsakanin kayan aiki.

Wani sauƙaƙan CSV yana kama da haka:

Suna, Shekaru, Birni

John, 28, New York

Sara, 24, London

Kowane layi layin bayanan kansa ne. Kowane wakafi yana nuna sabon shafi.

Mataki-mataki: Ƙirƙirar fayil ɗin CSV a Notepad

Mataki na 1: Buɗe Notepad

Buɗe Notepad a kwamfutarka, ko amfani da kyautar notepad na yanar gizo idan kana son tsallake amfani da manhajar kwamfuta.

Mataki na 2: Rubuta taken shafukanka

Rubuta takenka a layi na farko, rarrabe su da wakafi. Misali:

Samfuri, Farashi, Adadi

Mataki na 3: Ƙara bayanan ka

Ƙara kowane layin bayanai a sabon layi, kiyaye tsari ɗaya da takenka.

Samfuri, Farashi, Adadi

Laptop, 850, 5

Mouse, 20, 30

Keyboard, 45, 15

Mataki na 4: Ajiye fayil ɗin da tsawo na .csv

Je zuwa File, sannan Save As. A cikin menu na "Save as type", zaɓi All Files. Sanya wa fayil ɗinka suna da tsawon .csv, misali inventory.csv. Idan ka tsallake wannan matakin, Notepad zai adana shi azaman fayil ɗin .txt, kuma ba za a karanta shi azaman takardar kididdiga ba.

Mataki na 5: Buɗe kuma duba fayil ɗin

Buɗe fayil ɗin a cikin Excel, Google Sheets, ko kowace manhajar takaddun kididdiga don tabbatar da cewa shafuka da layuka sun daidaita yadda kake tsammani.

Kurakurai na gama-gari da za a guji

• Ƙarin wakafi a cikin ƙima. Idan ƙima kanta tana ɗauke da wakafi, sanya ta a cikin alamun magana (double quotes), kamar "New York, NY". In ba haka ba, zai rabu zuwa shafuka biyu bisa kuskure.

• Rashin daidaito a shafuka. Kowane layi yana buƙatar adadin ƙimar iri ɗaya da layin taken. Rashin wakafi ɗaya yana ɓata dukkan layin.

• Tsawon fayil ɗin da ba daidai ba. Adanawa azaman .txt maimakon .csv yana nufin manhajar takaddun kididdiga ba za ta buɗe shi daidai ba.

• Ƙarin sarari bayan wakafi. Wasu kayan aikin suna karanta sarari bayan wakafi azaman wani ɓangare na ƙimar. Kiyaye wakafi kusa da ƙima mai zuwa sai dai idan manhajar da kake nufi tana tsammanin sarari.

Ƴan shawarwari

• Ajiye layi ɗaya a kowane layin rubutu. Kada ka raba layi ɗaya zuwa layuka biyu.

• Yi amfani da layin take don kowa ya san abin da kowane shafi yake nufi.

• Idan kana gina babban CSV, rubuta shi a cikin manhajar takaddun kididdiga tukuna, sannan ka fitar da shi zuwa CSV, maimakon buga ɗaruruwan layuka da hannu.

• Kuna da bayanai a cikin Excel kuma kuna son su zama CSV, ko akasin haka? Yi amfani da kyautar mai canza CSV zuwa Excel maimakon sake buga komai.

Kammalawa

Fayil ɗin CSV ba komai ba ne illa rubutu da aka raba da wakafi wanda aka adana da tsawon fayil ɗin da ya dace. Notepad yana sarrafa shi ba tare da wata ƙarin software ba. Buga takenka, ƙara layukanka, adana shi azaman .csv, kuma zai kasance a shirye don buɗewa a kowace manhajar takaddun kididdiga.