Aligned

Import people from a spreadsheet

Whether your people live in a spreadsheet or in a system Aligned doesn't connect to, one CSV file brings them all in. You match the columns once, see a preview before anything lands, and running it again later updates people instead of duplicating them.

About 10 minutes Part of Aligned ChurchUpdated November 12, 2026
aligned.church/church
On **People**, press **Import** at the bottom right of **Directory**

1/6 · On People, press Import at the bottom right of Directory

Before you start: Save your list as a CSV file with a header row (any spreadsheet app can, usually under File → Save As or Download). Bringing people in from a file is free for every church.

Good to know

  • A Status column sets each person's status (visitor, member, staff or volunteer), and wording like “First-time guest” is understood. Other wording still comes in, as the person's status label. An import never overwrites a status you've already set.
  • Birthdays can be in the usual formats: 3/14/1985, 1985-03-14 or March 14, 1985.
  • Exported from Excel on Windows? Accented names like José come through correctly.
  • Donors and past gifts belong on the Giving tab, not here (see “Bring over donors and giving history”).

If it’s not working

It says “Cap is 2,000 rows per file — split larger exports”

Split the spreadsheet into parts and import each one. People already in are matched by email and updated, so overlap between parts is harmless.

It says “That file needs a header row plus at least one person”

The first row has to hold the column names (First Name, Email and so on), with people underneath. Add a header row, save as CSV again, and choose the file again.

The Import button stays grey

No name column was recognized, and the line under the preview says “Map a First name or Full name column to continue”. Rename the column that holds first names to “First Name”, or one that holds whole names to “Name”, save it as CSV again, and choose the file again.

It stopped partway with “Import failed”

The line says how many were already saved. Press Import again. It carries on from where it stopped instead of starting over.

I imported the wrong file

Type “undo the last import” in Manage's chat, beside the canvas. It names the import and how many people it added, and undoes it after you tap Undo this import. Those people are archived, not deleted.

Did this help?

Next, you might want to