Te kawemai i tētahi rārangi manuhiri mai i te ripanga

Mēnā kei Google Sheets, kei Excel, kei Numbers, kei tētahi atu taputapu whakautu rānei tō rārangi manuhiri, kaweakehia hei CSV, kātahi ka kawemai.

E rua ngā huarahi hei whakarite i te kōnae

• Tikiake i te papanga CSV mai i te mata kawemai, ka whakakī ai. Kei ngā tīwae te ingoa tuatahi, te ingoa whānau, te waea, te īmēra, te rōpū/whānau, te momo manuhiri, te reo, te whakaaetanga +1, ngā kōrero kai me ētahi atu āpure nāu ake. Ehara i te mea me whakakī ngā tīwae katoa.
• Whakamahia āu ake pane. Tukuatu i te kōnae kei a koe; ka tono te mata whai muri kia whakaritea e koe ō tīwae ki ā mātou (“Waea pūkoro → Waea”, “Kāinga → Rōpū”).

I mua i te kawemai o tētahi mea

Ka kite koe i tētahi tirohanga tōmua me ngā raru kua tohua:

• ngā tāngata tārua pea;
• ngā nama waea hē (ka tirohia ngā nama, ka hurihia ki te hanga ā-ao);
• ngā wāhitau īmēra hē;
• ngā uara tauhou (he momo manuhiri, he reo rānei kāore e mōhiotia e mātou);
• ngā raraunga e ngaro ana.

Whakatikahia ngā rārangi i reira tonu, pekea rānei. E kore tētahi mea e tae ki tō huihuinga kia whakaū rā anō koe, nō reira e kore tētahi ripanga hē e ruke i ngā rekoata kino ki tō rārangi.

Ngā whānau i roto i te ripanga

Tuhia te ingoa rōpū ōrite ki te tīwae Rōpū mō te katoa o te whānau, ā, ka kawemaitia rātou hei pōwhiri kotahi me ōna manuhiri maha.