Skip to main content
EcclesiaOne
Sign inSee insideGet started

Help centreThe parish officeBringing in old sacrament records from a spreadsheet

All articles

Bringing in old sacrament records from a spreadsheet

Turn a sheet of old Baptism, Confirmation, First Holy Communion or funeral entries into drafts the parish priest reads and signs.

For
Parish priest
Updated
21 November 2026
Read
2 min
Sections
5

Old entries kept in another system or typed into a spreadsheet can come in as drafts. Nothing enters a register unsigned: the parish priest reads and signs each draft, as for any new entry.

Read the sheet

  1. Open Sacraments, then From a spreadsheet under Old records.
  2. Choose the Register: Baptism, Confirmation, First Holy Communion or Funeral.
  3. In Copied from, write where the records came from, as the system and office were called. Every draft says it.
  4. Under The sheet, choose your Excel file (.xlsx) or a CSV file. The first sheet of an Excel file is read. It needs a heading above each column. Download a sample sheet shows the headings we read.
  5. Press Read the sheet. Nothing is added yet.

Answer what the page asks

  • Which box does each of these columns fill? A heading we do not know is asked about once. Choose its box, or Leave this column out.
  • How are the dates in this sheet written? When a date could be read two ways, such as 5/6/1998, choose Day first or Month first. No draft is made until you choose.
  • Who is this? When the register already has someone with that name, choose the right person or A new person.
  • Male or female? Asked for a new person when the sheet does not say.
  • A row with no date offers Type the date.

Dates that Excel stored as numbers are read as the dates they are.

Make the drafts

Press the button that says how many, for example Make 208 drafts. A long sheet is made a step at a time: keep the page open until it finishes. Rows still waiting for an answer stay on the sheet for later.

The drafts wait in each register for the parish priest to read and sign.

The same sheet brought in twice

Every row is checked against the drafts made from earlier sheets and against rows waiting in other open sheets. A repeat is left out, with the reason beside it, such as "Brought in before, on 3 December 2026". The count shows above the table before any draft is made.

Close a sheet

Press Close the sheet when you are done with it. Rows still waiting are let go. Drafts already made stay, each with where it was copied from.

Was this article helpful?

Bringing in records from another system

Still stuck?