Skip to main content
EcclesiaOne
Sign inSee insideGet started

Help centreThe parish officeImporting your parishioners from a spreadsheet

All articles

Importing your parishioners from a spreadsheet

Bring in your parish list from an Excel file or a paste: check the families and the dates, then import. A long list is added a few hundred at a time.

For
Parish priest
Updated
21 November 2026
Read
3 min
Sections
6

You can bring in your whole parish list at once. Nobody is added until you have checked the families and pressed Import.

What your list needs

  • One person on each line, under a first line that names the columns. The columns can be in any order.
  • Surname, Given names and Sex for everyone. Everything else can be blank.
  • We also read Date of birth, Baptismal name, Confirmation name, Phone, WhatsApp, Email, Address, Household, Relationship, Marital status, State of origin, LGA and Village or hometown. Other columns are left out.

People with the same surname and address become one family. When your list has a Household column, the people with the same household are put together instead.

Bring in the list

  1. Open People and press Import.
  2. Press Choose a file and pick your Excel file (.xlsx), CSV or text file. The first sheet of an Excel file is read. You can also copy the rows in your spreadsheet, the line of column names too, and paste them in the box.
  3. Under How are the dates in your list written?, choose Day first (8/6/1981 is 8 June 1981) or Month first (6/8/1981 is 8 June 1981).
  4. Press Check the list.

Check the families and the dates

The page shows how many people are ready, the families it put together, and the people on their own.

  • Each family card says why the people are together. Untick a family to keep its members apart.
  • Lines left out lists any line with a problem, with what to fix. Fix them in your spreadsheet and import them later, or add those people one at a time.
  • Look at a few dates of birth. If the day and the month come out the wrong way round, choose the other way above and press Check the list again.

A date that could be read two ways. A date such as 5/6/1981 is 5 June day first and 6 May month first. When your list has one and you have not chosen how your dates are written, the page says so and Import stays off. Choose Day first or Month first, then check the list again.

Dates that Excel stored as numbers (such as 45321) are read as the dates they are.

Import

  1. Press the import button. It says how many people and households, for example Import 38 people in 14 households.
  2. Press Import again to confirm.

A long list is added a few hundred people at a time. The line beside the button says how far it has gone, for example "Adding part 3 of 12: 500 people added so far". Keep the page open until it finishes.

If the connection drops, the page stops and says so. Press Carry on. People already added are not added again.

Importing the same list again

You can safely import the same list again, for example after a power cut. Anyone already added from it, or already in the parish with the same name and date of birth, phone or email, is skipped and listed with the reason. The rest of their family joins the household they are already in.

Limits

Import up to 5,000 people at a time. If your plan has a member limit, the import must stay within it.

Was this article helpful?

In memoriam pages

Still stuck?