Maitiro Ekugadzira Faira re .CSV muNotepad

Faira reCSV rinongoiva runyorowo zvako pasina zvimwe zvinorema. Izvi zvinoreva kuti haudi Excel kana Google Sheets kuti ugadzire rimwe. Notepad, kana notepad yepamhepo inomhanya, inoita basa racho mumatanho mashoma.

Chii chinonzi faira reCSV?

CSV inomirira Comma-Separated Values (Unhu hwakaparadzaniswa neKomajani). Inochengeta data mumitara yakati tandarate, uye hunhu hwega hwega mumutara unenge wakaparadzaniswa nekomajani. Zvirongwa zvezvemadhatabasa (spreadsheets), madhatabasa (databases), nezi-script zvinoverenga fometi iyi, zvichiita kuti ive imwe yenzira dzakanyanya kujairika dzekufambisa data pakati pezvirongwa zvakasiyana.

CSV iri nyore inoita seiyi:

Name, Age, City

John,28, New York

Sara,24, London

Mutara wega wega mutara wakazvimirira. Komajani yega yega inoratidza koramu nyowani.

Nhanho-ne-nhanho: Gadzira faira reCSV muNotepad

Nhanho 1: Vura Notepad

Vura Notepad pakombiyuta yako, kana shandisa notepad yepamhepo Yemahara kana uchida kudarika kushandisa app iri pakombiyuta yako.

Nhanho 2: Nyora misoro yemakoramu ako

Nyora misoro yako pamutara wekutanga, wakaparadzaniswa nekomajani. Semuenzaniso:

Product, Price, Quantity

Nhanho 3: Isa data yako

Isa mutara wega wega wedata pamutara mutsva, uchengetedze kurongeka kumwe chete nemisoro yako.

Product, Price, Quantity

Laptop,850,5

Mouse,20,30

Keyboard,45,15

Nhanho 4: Chengetedza faira racho uine chiwedzero che .csv

Enda kuFile, wobva wati Save As. Pakadonha menyu ye "Save as type", sarudza All Files. Tumidza faira rako zita rine chiwedzero che .csv, semuenzaniso inventory.csv. Kana ukasvetuka nhanho iyi, Notepad icharichengetedza sefaira re .txt, uye harizoverengwi sespredisheet.

Nhanho 5: Vura uongorore faira racho

Vura faira racho muExcel, Google Sheets, kana chero app yespredisheet kuti utarise kana makoramu nemitara zvakarongeka nenzira yawabvumirana nayo.

Kanganiso Dzinowanzoitika dzaUnofanira Kurega

• Komajani dzinopfuura kana kuwedzerwa mukati memunhu kana chinhu. Kana kukosha kacho kune komajani mukati maro, chimonere mukati memaviri ekumaka (double quotes), zvakadai se "New York, NY". Zvikasadaro ichapatsanurwa kuita makoramu maviri zvisiri izvo.

• Makoramu asingawirirani. Mutara wega wega unoda huwandu hwakafanana hwetsika semutara wemusoro. Komajani inorasika inoita kuti mutara wose usashande zvakanaka.

• Chiwedzero chefaira chisiriicho. Kuchengetedza se .txt pachinzvimbo che .csv zvinoreva kuti mapurogiramu espredisheet haachavuri nenzira kwayo.

• Nzvimbo dzisina basa pashure pemajani (Extra spaces). Zvimwe zvirongwa zvinoverenga nzvimbo iri pashure pekoma sechikamu chetsika yacho. Chengetedza komajani dziri pedyo netsika inotevera kunze kwekunge app yako yauri kushandisa ichida nzvimbo.

Mazano Anokurumidza

• Chengetedza mutara mumwe pamutara mumwe. Usapatsanure mutara mumwe pamitara miviri.

• Shandisa mutara wemusoro kuitira kuti ani nani anovura faira azive zvinoreva koramu yega yega.

• Kana uri kuvaka CSV huru, nyora muapp yespredisheet kutanga, wobva watumira kuCSV, kwete kunyora mazana emitara nemaoko.

• Wotova nedata muExcel uye unoda kuti rive CSV, kana zvichigumira ipapo? Shandisa mahara CSV kuenda kuExcel converter pachinzvimbo chekunyora zvakare zvese kubva pakutanga.

Mhedziso

Faira re CSV harina chimwe kunze kwemanyoro akaparadzaniswa nekoma akachengetedzwa nechiwedzero chakakodzera. Notepad inobata izvi pasina chero imwe software yekuwedzera. Nyora misoro yako, isa mitara yako, ichengetedze se .csv, uye yagadzirira kuvhurwa mune chero chishandiso chespredisheet.