Shigo da fitarwa fayilolin rubutu zuwa Excel

• Import
• Export

Wannan labarin ya bayyana yadda ake shigo da ko fitarwa fayilolin rubutu. Ana iya raba fayilolin rubutu ta waƙafi (.csv) ko shafuka (.txt).

Import

Don shigo da fayilolin rubutu, bi umarninmu:

1. A kan Babba shafin Fillet (Fayil) danna Bude (Bude).
2. Daga jerin saukewa zaþi Fayilolin Rubutu (Faylolin rubutu).
3. Don shigo da fayil…
   • CSV, zaɓi takarda mai tsawo . Csv Kuma danna Bude (Bude). Duka ne.
   • TXT, zaɓi takarda mai tsawo .txt da kuma danna kan Bude (Bude). Excel zai fara Mayen shigo da rubutu (Wizard na rubutu (shigo da)).
4. zabi Iyakance (tare da separators) kuma latsa Next (Ƙari).
5. Cire duk akwatunan rajistan sai dai kishiyar tab (Tab) kuma danna Next (Ƙari).
6. latsa Gama (Shirya).

Sakamako:

Export

Don fitar da littafin aikin Excel zuwa fayil ɗin rubutu, yi haka:

1. Bude daftarin aiki na Excel.
2. A kan Babba shafin Fillet (Fayil) danna Ajiye As (Ajiye azaman).
3. Daga jerin saukewa zaþi Rubutu (Yankakken Tab) (Faylolin rubutu (shafukan da aka iyakance)) ko CSV (An iyakance waƙafi) (CSV (rabu da waƙafi)).
4. latsa Ajiye (Ajiye).

Sakamako: Fayil na CSV (ƙayyadaddun waƙafi) da fayil ɗin TXT (shafi ƙayyadaddun).