You will need the Import permission to use the import tools. Where your rows land, and which existing records you can write onto, follows your campus access.
To open the import tools, go to Settings & Tools > Tools/Utilities > Import Data (cog icon in the toolbar).
Warning: On every plan, including churches with one campus, a Campus value that does not match an existing campus stops the whole file. No import creates a campus any more. The message reads "[name]" was not found. Add the campus first, then import again. Correct the spelling in your file, or add the campus, then import again.
Start an import
Click + New Import. In the New Import window:
Choose the kind of data to import from the Type drop-down, for example People.
Under Data CSV File, click download template file for a starter template, or Browse... to upload your own file. The file must be in CSV format, a table of columns and rows saved with a .csv extension. If you have an Excel file, open it and save it as a .csv first.
If an Organization field appears, choose the organization the rows belong to. The Organization field below explains when it appears.
Review the column mappings, then click Import.
The template is optional. You can upload any CSV file, but the template is helpful for seeing the fields you can import. After you upload, the system maps the columns in your CSV to the fields it can import, making a best guess for each. We highly recommend reviewing those guesses and correcting them before importing.
Fill in any other mappings you would like to use. Fields left blank are not imported, and fields marked with a red star are required. If there are any errors when you import, a red message appears with the line number where the error occurred.
Tip: To see the fields and data types available for an import, upload your CSV first. The mapping screen then shows every available field, so you can use it as documentation for what each field accepts. It also helps to know how the record is organized in One Church before you import. The fields you map correspond to the same fields on the record, and you can map custom fields too.
Campuses and organizations in an import
Campus names
Campus names match ignoring case.
A name that does not exist stops the whole file, on every plan.
People, groups, connections, rooms and items refuse a name that two campuses or venues share.
Batches and designations look the name up inside the row's organization. A campus name held only by an archived organization refuses batch and designation rows.
A row that names a campus lands in that campus's organization, whatever the Organization field says.
No import file has an organization column, and organization names are never matched. The Organization field sends the organization itself.
The Organization field
If your account has two or more organizations, an Organization field appears in the New Import window when all of these are true:
two or more organizations are available to choose from
your campus selector does not name exactly one organization
the type is campaigns, batches, designations, transactions, chart or funds
you are not importing from an accounting page
there is no target batch
The import is blocked until you fill it in. The organization must be active and within your access, or the whole file is refused.
Note: If you are limited to two or more organizations, you name none, and your campus selector does not name one, the whole file is refused. Batch and designation files with a Campus column refuse only their blank rows.
Where each import gets its campus and organization
Import | Campus column | Organization comes from |
People, Businesses, Groups, Connections | Campus. A comma-separated list is allowed, and the first is primary. | None |
Designations, Batches | Campus. Must sit in one organization. | Organization field |
Transactions | None | Organization field or target batch |
Giving Campaigns | None | Organization field |
Giving Pledges | None | The campaign's |
Rooms, Resources | Location. One campus or venue, required once you have more than one campus or organization. | None |
Funds, Chart of Accounts | None | Organization field or books page |
Register, Journal Entries | None | Read from the accounts and funds |
Bank Statement Data | None | The chosen account's |
Emails, Phones, Addresses, Important Dates, Notes, Safeguards, Group Members, Positions, Metric Reports, Giving Envelopes | None | None |
Where a blank row lands
A row with a blank Campus cell is placed using your campus selector and your access:
If you have no campus or organization limit and nothing is selected, the row gets no campus.
If your campus selector holds a whole organization, the row is placed in that organization.
If your campus selector holds campuses, the row takes those campuses.
If you are limited, the row takes your campuses, or your organizations if you hold no active campus.
Money imports always stay inside one organization. A blank money row lands in the organization named in the Organization field, otherwise the single organization of its campus or of your campus selector, otherwise the only active organization you reach, otherwise your single organization, otherwise the default organization.
Gift imports
A row naming another organization's batch is refused, and the message tells you to use that batch as the target instead.
When you import into a target batch, the batch decides the organization. A target batch must be writable at its campuses, and cannot be archived, closed or automatic.
Designations match only inside the import's organization, plus internal designations. A code held only by another organization is refused. A name held only by another organization creates a new designation in this one.
If you are limited, each gift must be placed where you hold Limited Write Contributions.
Pledges match a campaign only in organizations you reach, and never an archived one. Two matches is an error.
If your access is limited
A campus you name must be active and within your access.
You cannot write onto an existing record outside your reach, and one such row refuses the whole file. Gifts and pledges are the exception: they can credit anyone in the account.
If you have a campus or organization limit, import history shows only the imports you ran. A campus override on its own does not narrow it.
Field types
When mapping fields, the data type for each field is shown underneath its label. A few common types:
Boolean - "Yes" or "No". Also accepts "Y" and "N", "True" and "False", "1" and "0", and "T" and "F".
Text - free text. Enter anything you like.
Drop-down - some fields correspond to drop-downs on the record. Enter the exact text from the drop-down. If you enter an option that is not in the drop-down, the system creates the new option automatically.
Importing people
Most of the time you will be importing people. Keep these tips in mind.
External ID
The External ID is an optional field that uniquely identifies the person outside of One Church. If you plan to upload other information tied to the person, such as notes, group membership or safeguards, include this field in your CSV. You can then use the same External ID in the other import tools to link that data to this person.
No two people can share the same External ID, and the system returns an error if they do. If none is specified, One Church generates its own.
Family ID
To group people into the same family, give them the same Family ID in your CSV. The value can be numbers or text. What matters is that everyone with the same value is placed in the same family. Choose a value that was not previously imported, or you will add these people to an existing family.
The Family ID in the file is not the ID of the family in One Church. It is simply a way to group people into households, typically the Family ID from your previous system. If you do not include a Family ID, the person is imported into their own family as the head of household.
People who have passed away
To bring in someone who has already passed away, put their date of death in the Deceased On column. In the People template this column is named Deceased Date. The mapping screen picks a column for Deceased On by itself when the header contains "deceased" or "death".
Each person with a Deceased On date is added as archived and marked deceased, with that date as their Deceased Date.
The date can't be later than today, or earlier than the row's Birthday. A date that breaks either rule, or a value that isn't a date, stops the whole file, and the error names the line.
Deceased On only applies to people the import creates. It doesn't change a profile that already exists. To mark an existing person deceased, use Mark deceased on their profile.
Deceased On is for people only, not businesses.
Dates of death can't come in as Important Dates. A People import that maps a date-of-death column or type, such as Date of Death, is refused, and so is an Important Dates import with a date-of-death Type. Use the Deceased On column instead.
See How do I mark a person as deceased? for what marking someone deceased changes.
Importing other data
All the other import tools follow the same layout. A few things to know:
Check the results of an import right away for errors, so you can redo it if needed.
Only one import runs per account at a time.
You can undo an import for up to two years from its 3-dots menu on the Import Data listing. Undoing makes it as if the import never happened, including removing any new drop-down values it added.
Only the person who performed an import, and Super Users, can download the original file used for that import.
If you would rather we import your data, click your user avatar in the top right of the toolbar and choose Request Data Import. How can I request for someone to import my data into One Church? explains more.
When an undo is refused
A limited importer may undo only their own imports, and not if any record has moved outside what they could delete.
Undo is refused if it touches archived books or money.
Undo is refused for entries locked by a close, bank match, void or adjustment.
Undo is refused for batches, campaigns, designations or events that gifts, pledges, recurring gift lines or event payments have used since the import.
Importing metric reports
To import metric values, choose Metric Reports from the Type drop-down. It is listed under the Other heading.
Note: If your metrics are organized into sub-metrics, identify each one by its full path, using a right arrow (>) between the levels, for example Attendance > Adults or Attendance > Children. Entering only the child name on its own does not tell One Church which parent the value belongs under.
Once the import finishes, your values appear on the Data tab under Reporting > Metrics. How do I use the Metrics Module? explains how to set up the metrics themselves.

