---
title: Sut i mewnforio fy ffeil CSV i Groop?
description: Mae mewnforio gan CSV yn caniatáu ichi uwchlwytho manylion defnyddwyr yn hawdd
---

[Skip to content](https://knowledge.groop.com/sut-mae-mewnforio-fy-ffeil-csv-i-groop#main-content)

English

Show submenu for translations

[More support](https://knowledge.groop.com/kb-tickets/new?hsLang=en)

![Groop-Black.svg\]](https://knowledge.groop.com/hubfs/Groop-Black.svg)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [More support](https://knowledge.groop.com/kb-tickets/new)
- Contact us

 Contact us

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base and Tutorials](https://knowledge.groop.com/?hsLang=en)
2. [Cymraeg/Welsh](https://knowledge.groop.com/cymraeg-welsh?hsLang=en)
3. [Pobl](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#pobl)

# Sut i mewnforio fy ffeil CSV i Groop?

## Mae mewnforio gan CSV yn caniatáu ichi uwchlwytho manylion defnyddwyr yn hawdd

Mae'r erthygl hon yn amlinellu'r gofynion ar gyfer mewnforio CSV o bobl i Groop. Fe welwch hefyd rai awgrymiadau llaw ar sut i fformatio'r data yn gywir.

1. Rhaid i'r ffeil fod ar ffurf CSV. Ni chefnogirestyniadau ffeil eraill ee. XLS.   
   Am wybodaeth ar sut i allforio CSV, gweler y dolenni isod -  
   Microsoft Excel - [https://support.office.com/ga-gb/article/import-or-export-text-txt-or-csv-files-5250ac4c -663c-47ce-937b-339e391393ba](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.office.com/en-gb/article/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba&usg=ALkJrhjpqpst53SchuNBn0z7KfXt2N7Hzg)Apple Numbers - [https://support.apple.com/en-gb/guide/numbers/tan3b922d4ad/mac](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.apple.com/en-gb/guide/numbers/tan3b922d4ad/mac&usg=ALkJrhjSguFGmcU0DBd_wXjzgRFF6BpEjA)
2. Nid oes angen yr holl feysydd sydd ar gael ond rydym yn argymell eich bod yn mewnforio cymaint o wybodaeth sy’n bosib, oherwydd na allwch uno data gan ddefnyddio ffwythiant mewnforio CSV yn ddiweddarach.
3. Rhaid i’r res gyntaf y daenlen gynnwys penawdau'r colofnau. Nid yw teitl y colofnau yn bwysig, ond os yw'r gell pennawd yn wag, anwybyddir y golofn gyfan
   
   | **Enw cyntaf** | **Enw olaf** | **E-bost** | **Ffôn** |
   | --- | --- | --- | --- |
   |  |  |  |  |
4. Rhaid i'r rolau a roddir i ddefnyddiwr fodoli’n eisoes, a rhaid iddynt fod yn cyfateb yn union
5. Rhaid i labeli a neilltuwyd i ddefnyddiwr fodoli eisoes a rhaid iddynt fod yn cyfateb yn union
6. Rhaid i'r dyddiad geni ac unrhyw faes dyddiad arall fod ar ffurf ISO 8601:
   
   2020-01-22  
   22 Ionawr 2020  
   Ionawr 22, 2020  
   22 Ionawr 20  
   Ionawr 22 20  
   2020/01/24  
   06/01/2020  
   06/01/20
   
   Nid yw MM / DD / BBBB yn gydnaws (fformat dyddiad yr UD)
   
   Ar gyfer dyddiadau sy'n cynnwys amseroedd, atodwch unrhyw un o'r enghreifftiau uchod gyda'r amser yn hh: mm, neu hh: mm: ss. I nodi cylchfa amser, defnyddiwch:
   
   2020-01-22T15: 20: 00 + 0200 '  
   2020-01-22T15: 20: 00Z' ar gyfer UTC  
   Am wybodaeth ar sut i fformatio celloedd yn awtomatig, gweler y dolenni isod -  
   Microsoft Excel - [https://support.office.com/ga-gb/article/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e#ID0EAACAAA=Windows](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.office.com/en-gb/article/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e&usg=ALkJrhgZWQzK3FOzyusrNPiqYjYiDrJ4rQ#ID0EAACAAA=Windows)Apple Numbers -[https://support.apple.com/ga-gb/guide/numbers/tan23393f3a/mac](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.apple.com/en-gb/guide/numbers/tan23393f3a/mac&usg=ALkJrhjd-bzq9MyLKESFQI-TYjW5LRg0Rg)
7. 2020-01-22  
   22 Ionawr 2020  
   Ionawr 22, 2020  
   22 Ionawr 20  
   Ionawr 22 20  
   2020/01/24  
   06/01/2020  
   06/01/20
   
   Nid yw MM / DD / BBBB yn gydnaws (fformat dyddiad yr UD)
   
   Ar gyfer dyddiadau sy'n cynnwys amseroedd, atodwch unrhyw un o'r enghreifftiau uchod gyda'r amser yn hh: mm, neu hh: mm: ss. I nodi cylchfa amser, defnyddiwch:
   
   2020-01-22T15: 20: 00 + 0200 '   
   2020-01-22T15: 20: 00Z' ar gyfer UTC
   
   Am wybodaeth ar sut i fformatio celloedd yn awtomatig, gweler y dolenni isod -  
   Microsoft Excel - [https://support.office.com/ga-gb/article/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e#ID0EAACAAA=Windows](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.office.com/en-gb/article/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e&usg=ALkJrhgZWQzK3FOzyusrNPiqYjYiDrJ4rQ#ID0EAACAAA=Windows)Apple Numbers -[https://support.apple.com/ga-gb/guide/numbers/tan23393f3a/mac](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://support.apple.com/en-gb/guide/numbers/tan23393f3a/mac&usg=ALkJrhjd-bzq9MyLKESFQI-TYjW5LRg0Rg)
8. Rhaid i unrhyw ddethol neu aml-ddethol fel Rhyw, Ethnigrwydd neu Faes Custom a grëwyd ar gyfer eich Groop, fodoli eisoes a rhaid iddo fod yn cyfateb yn union  
   Pan yn mewnforio gwybodaeth i un o'r meysydd diofyn, rhaid i'r mewnforio CSV gyd-fynd â'n system. Mae'r opsiynau sydd angen eu cynnwys yn y CSV i'w weld yn y tablau isod, a hefyd sut y bydd hynny'n cael ei arddangos yn Groop:  
     1. [Teitl](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#Title)
     2. [Rhywioldeb](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#Sexuality)
     3. [Ffydd / Cred](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#FaithBelief)
     4. [Dull Teithio](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#MethodofTravel)
     5. [Anabledd](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#Disability)
     6. [Rhyw](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#Gender)
     7. [Ethnigrwydd](https://translate.googleusercontent.com/translate_c?depth=1&hl=en&pto=aue&rurl=translate.google.com&sl=en&sp=nmt4&tl=cy&u=https://knowledge.groop.com/how-do-i-import-my-csv-file-into-groop&usg=ALkJrhji_2p_hv8Q-WQKFcxSNi1UJKk0hg#Ethnicity)
9. Gall colofnau nad oes eu hangen wrth fewnforio fod yn 'Ddi-ddynodedig'. Ni fydd y data hwn yn cael ei fewnforio

- Rhaid i gyfeiriadau e-bost fod yn unigryw, ni all cofnodion rannu cyfeiriad e-bost
- Ni fydd mewnforio yn uno nac yn golygu defnyddwyr presennol. Dim ond un cynnig cewch ar hwn

**Teitl**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| MR | Mr |
| MRS | Mrs |
| MS | Ms |
| MISS | Miss |
| MASTER | Master |
| DR | Dr |
| PROF | Prof |
| REV | Rev |
| MX | Mx |

**Rhywioldeb**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| HETRO\_STRAIGHT | Hetrosexual/Straight |
| LESBIAN | Lesbian |
| GAY | Gay |
| BISEXUAL | Bisexual |
| PANSEXUAL | Pansexual |
| QUESTIONING | Questioning Sexual |
| PREFER\_NOT\_TO\_SAY | Prefer Not To Say |
| OTHER | Other |
| UNKNOWN | Unknown/Not Specified |

 

**Ffydd / Cred**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| RELIGIOUS | Identifies as holding a faith or religious belief |
| NON\_RELIGIOUS | Doesn't identify as holding a faith or religious belief |
| PREFER\_NOT\_TO\_SAY | Prefer Not To Say |
| UNKNOWN | Unknown/Not Specified |

**Dull Teithio**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| BICYCLE | Bicycle |
| BUS | Bus |
| CAR | Car |
| ON\_FOOT | On Foot |
| TRAIN | Train |
| TRAM | Tram |

**Anabledd**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| MENTAL | Mental |
| PHYSICAL | Physical |
| NONE | None |

**Rhyw**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| MALE | Male |
| FEMALE | Female |
| PREFER\_NOT\_TO\_SAY | Prefer Not To Say |
| NOT\_IDENTIFY | Does not identify with gender assigned at birth |
| NON\_BINARY | Genderqueer/Non Binary |
| UNKNOWN | Unknown/Not Specified |
| TRANS | Trans |

**Ethnigrwydd**

| **Angen yn y Data CSV** | **Arddangos yn Groop** |
| --- | --- |
| WHITE\_BRITISH | White English/Welsh/Scottish/Northern Irish/British |
| WHITE\_IRISH | White Irish |
| WHITE\_GYPSY\_IRISH\_TRAVELLER | White Gypsy or Irish Traveller |
| WHITE\_ANY | Any other White background |
| WHITE\_BLACK\_CARIBBEAN | White and Black Caribbean |
| WHITE\_BLACK\_AFRICAN | White and Black African |
| WHITE\_ASIAN | White and Asian |
| ANY\_MIXED\_ETHNICITY | Any other Mixed/Multiple ethnic background |
| INDIAN | Indian |
| PAKISTANI | Pakistani |
| BANGLADESHI | Bangladeshi |
| CHINESE | Chinese |
| ANY\_ASIAN | Any other Asian background |
| BLACK\_AFRICAN | Black African |
| BLACK\_CARIBBEAN | Black Caribbean |
| ANY\_BLACK\_BACKGROUND | Any other Black/African/Caribbean background |
| ARAB | Arab |
| OTHER | Any other ethnic group |
| PREFER\_NOT\_TO\_SAY | Prefer Not to Say |
| UNKNOWN | Unknown/Not Specified |

[Os oes angen cymorth pellach gyda’ch CSV, cysylltwch â ni trwy ein cymorth sydd i'w gael yma](https://knowledge.groop.com/kb-tickets/new?hsLang=en)

- [Getting Started](https://knowledge.groop.com/getting-started?hsLang=en)
- [Cymraeg/Welsh](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#main-content)

    - [Dechrau Arni](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#dechrau-arni)
    - [GroopChat](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#groopchat)
    - [Fy GroopPay](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#fy-grooppay)
    - [Fy Digwyddiadau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#fy-digwyddiadau)
    - [Fy Nibynyddion](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#fy-nibynyddion)
    - [Gosodiadau Groop](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#gosodiadau-groop)
    - [Adroddiadau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#adroddiadau)
    - [Cyfathrebu](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#cyfathrebu)
    - [Adnoddau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#adnoddau)
    - [Gweinyddiaeth GroopPay](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#gweinyddiaeth-grooppay)
    - [Pobl](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#pobl)
    - [Digwyddiadau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#digwyddiadau)
    - [Rolau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#rolau)
    - [Labelau](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#labelau)
    - [Meysydd Golygiadwy](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#meysydd-golygiadwy)
    - [Hidlo ac Adrodd](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#hidlo-ac-adrodd)
    - [Dolenni Cofrestru](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#dolenni-cofrestru)
    - [Groops](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#groops)
    - [Ap Symudol](https://knowledge.groop.com/cymraeg-welsh?hsLang=en#ap-symudol)
- [GroopChat](https://knowledge.groop.com/groopchat?hsLang=en)
- [My GroopPay](https://knowledge.groop.com/my-grooppay?hsLang=en)
- [My Events](https://knowledge.groop.com/my-events?hsLang=en)
- [My Dependants](https://knowledge.groop.com/my-dependants?hsLang=en)
- [Groop Settings](https://knowledge.groop.com/groop-settings?hsLang=en#main-content)

    - [Stripe Payments](https://knowledge.groop.com/groop-settings?hsLang=en#stripe-payments)
- [Reports](https://knowledge.groop.com/reports?hsLang=en)
- [Communications](https://knowledge.groop.com/communications?hsLang=en)
- [Resources](https://knowledge.groop.com/resources?hsLang=en)
- [GroopPay Admin](https://knowledge.groop.com/grooppay-admin?hsLang=en)
- [People](https://knowledge.groop.com/people?hsLang=en#main-content)

    - [Interactions/Notes](https://knowledge.groop.com/people?hsLang=en#interactions-notes)
- [Events](https://knowledge.groop.com/events?hsLang=en)
- [Roles](https://knowledge.groop.com/roles?hsLang=en)
- [Labels](https://knowledge.groop.com/labels?hsLang=en)
- [Customisable Fields](https://knowledge.groop.com/customisable-fields?hsLang=en)
- [Filtering and Reporting](https://knowledge.groop.com/filtering-and-reporting?hsLang=en)
- [Registration Links](https://knowledge.groop.com/registration-links?hsLang=en)
- [Legacy System](https://knowledge.groop.com/legacy-system?hsLang=en)
- [Groops](https://knowledge.groop.com/groops?hsLang=en)
- [Mobile App](https://knowledge.groop.com/mobile-app?hsLang=en)
- [Dashboard](https://knowledge.groop.com/dashboard?hsLang=en)

[![Chill listening crop-3](https://knowledge.groop.com/hubfs/Groop-Black.svg "Chill listening crop-3")](https://knowledge.groop.com?hsLang=en)

Groop Knowledge Base and Tutorials

Copyright © 2026, Groop Ltd