Faylka CSV waa qoraal caadi ah oo keliya. Taas macnaheedu waa inaysan ku baahnayn Excel ama Google Sheets si aad u abuurto. Notepad, ama buug-xusuus qor online ah oo degdeg ah, online notepad, ayaa shaqada qabanaya dhowr tillaabo.
Sida Loo Abuuro Faylka .CSV ee Notepad-ka
Jul 3, 20263 min read
Waa maxay faylka CSV?
CSV waxay ka dhigan tahay Qiimayaasha Is-raacsan ee Comma-da (Comma-Separated Values). Waxay kaydisaa xogta safaf, iyadoo qiima kasta oo saf ku jira uu u kala soocanyahay comma (,). Apps-ka xisaabta (Spreadsheets), database-yada, iyo qoraallada barnaamijyada ayaa dhammaarkood akhriya qaabkan, taas oo ka dhigaysa mid ka mid ah siyaabaha ugu caansan ee xogta loogu wareejiyo qalabka kala duwan.
CSV fudud wuxuu u eegaa sida tan:
Name, Age, City
John,28, New York
Sara,24, London
Kadir kasta waa saf. Comma kasta waxay calaamad u tahay tiir cusub.
Tillaabo-tillaabo: Ku abuur faylka CSV gudaha Notepad
Tillaabada 1aad: Fur Notepad
Fur Notepad-ka kombiyuutarkaaga, ama isticmaal bilaash online notepad haddii aad rabto inaad ka gudubto app-ka desktop-ka.
Tillaabada 2aad: Ku qor madaxyada tiirarkaaga (Headers)
Ku qor madaxyadaada safka koowaad, oo ay kala soocayaan commayo. Tusaale ahaan:
Product, Price, Quantity
Tillaabada 3aad: Ku dar xogtaada
Ku dar saf kasta oo xog ah saf cusub, adigoo ilaalinaya isla habkii madaxyadaada.
Product, Price, Quantity
Laptop,850,5
Mouse,20,30
Keyboard,45,15
Tillaabada 4aad: Keydi faylka oo geli kordhinta (extension) .csv
Tag File, dabadeed Save As. Liiska hoos u dhaca ee "Save as type", dooro All Files. U bixi faylkaaga magac wata kordhinta .csv, tusaale ahaan inventory.csv. Haddii aad ka boodho tillaabadan, Notepad wuxuu u kaydin doonaa sida fayl .txt ah, mana loo akhrin doono si la mid ah xaashida xisaabta (spreadsheet).
Tillaabada 5aad: Fur oo hubi faylka
Fur faylka Excel, Google Sheets, ama app kasta oo spreadsheet ah si aad u xaqiijiso in tiirarka iyo safafka ay u siman yihiin sidii aad filaysay.
Cilladaha Caadiga ah ee La Adeegsado in La Iska Ilaaliyo
Commayo dheeraad ah oo ku jira qiime. Haddii qiimaha laftiisu uu leeyahay comma, ku dhex duub xigashooyin laba-laaban (double quotes), sida "New York, NY". Haddii kale waxay si khaldan ugu kala bixi doontaa laba tiir.
Tiirar aan iswaafaqayn. Saf kasta wuxuu u baahan yahay tiro la mid ah qiimayaasha safka madaxa (header row). Comma maqan waxay kharribaysaa safka oo dhan.
Kordhinta faylka oo khaldan. Kaydinta .txt halkii laga dhigi lahaa .csv waxay la macno tahay in apps-ka spreadsheet-ku aysan si sax ah u furi doonin.
Meelo bannaan (spaces) oo dheeraad ah oo ka dambeeya commayada. Qalabka qaar ayaa akhriya booska ka dambeeya comma qayb ka mid ah qiimaha. Commayada ku hay agagaarka qiimaha xiga ilaa iyo inta app-kaaga bartilmaameedka ah uusan filayn boosaf bannaan.
Talooyin Degdeg ah
Hay hal saf saf walba. Ha u qaybin hal saf laba saf.
Saf madax ah isticmaal si qof kasta oo furaya faylka uu u ogaado waxa tiir kasta u taagnaa.
Haddii aad dhisayso CSV weyn, ku qor app spreadsheet marka hore, ka dibna u dhoofso CSV, halkii aad gacanta ku qori lahayd boqollaal saf.
Horey ma u haysataa xogta Excel oo aad u baahan tahay sida CSV, ama dhanka kale? Isticmaal bilaash CSV to Excel converter halkii aad wax walba dib u qori lahayd.
Gunaanad
A CSV faylku wax kale ma aha oo anigu ahayn qoraal comma lagu kala soocay oo lagu keydiyay kordhinta saxda ah. Notepad wuxuu maamulaa iyada oo aan loo baahnayn software dheeraad ah. Ku qor madaxyadaada, ku dar safafkaaga, keydi sida .csv, wuxuuna diyaar u yahay in lagu furo qalab kasta oo spreadsheet ah.