Importing your members
If your members are in a spreadsheet, you can bring them all into Pilaster at once. You see a preview of every row first, and nothing is saved until you confirm.
The short version
- Go to Members and click Import CSV. Save your spreadsheet as a .csv file with column names in the first row.
- Only a business name column is required. Most common column names are recognized.
- Set up your dues levels first. Level names in the file must match them.
- A business already in your member list is skipped, never updated.
- Imported members don't get a welcome email, onboarding emails or a portal invitation.
Before you import
- Create your dues levels on the Membership Levels page. The import matches the level in each row by name, ignoring capitals. A row whose level doesn't match comes in with no level, and the preview warns you.
- Check Chamber Settings, Renewals. Reminder emails are on for a new chamber. An imported active member on a paid level whose renewal date is coming up, or recently passed, can get a renewal reminder once they are in. One whose renewal date is more than the Lapse after days in the past is marked lapsed. Fix the renewal dates in your file, or turn reminders off until you are ready.
- If you are in evaluation mode, evaluation data is cleared when you go live, so you will import your real list again then. See Evaluation mode.
Preparing the file
On the Import Members page, Download a template gives you a CSV with every column the import recognizes and one sample row. You don't have to use it: columns are matched by name, loosely, so an export from another system usually works as it is.
The file can have up to 5,000 rows and be up to 5 MB. Split a bigger list into several files. Files saved by Excel, including ones that use semicolons instead of commas, are read correctly.
Columns the import recognizes
Each column name is matched without regard to capitals or punctuation. Some of the names that work:
- Business name (required): Business Name, Business, Company, Organization, Member or Name.
- Business details: Email, Phone, Website, Address, Address 2, City, State, ZIP, Country and Notes.
- Level: Tier, Level, Membership Level, Membership Type or Plan.
- Industry: Industry, Category, Business Category or Sector.
- Status: Status, Membership Status or Member Status.
- Dates: Join Date, Joined or Member Since; and Renewal Date, Renews, Expires, Expiration Date or Due Date.
- One contact: First Name and Last Name, or a single Contact Name column; Contact Email, Contact Phone (or Mobile or Cell) and Title.
Columns with other names are ignored, and the preview lists them. If two columns could mean the same thing, the first one is used.
A column named only "Name" is read as the business name, and "Email" as the business's email. Name the person's columns First Name, Last Name and Contact Email so they land on the contact.
How values are read
- Status: Active, Current, Member, Paid or Yes mean Active. Lapsed, Expired, Past Due, Overdue or Inactive mean Lapsed. Cancelled, Resigned, Dropped or Former mean Cancelled. Applicant, Pending, Prospect or Applied mean Applicant. A blank status is Active. Anything else is imported as Active with a warning.
- Dates: 2026-03-01, 3/1/2026, 03/01/26, Mar 1, 2026 and March 1, 2026 all work. A date in another form is an error for that row.
- Renewal date: if it is blank and there is a join date, it is set one billing period after the join date. With neither, the member has no renewal date.
- Industry: an industry you don't have yet is created, and the preview lists them first.
- Website: "example.com" is saved as https://example.com.
Previewing and importing
Choose your file and click Preview. You see:
- Counts of rows To import, Skipped and with Errors.
- Which of your columns were used and what they became, the columns ignored, and new industries to create.
- A row-by-row list marked Will import, Import with warnings, Skipped or Error, with the reason. Rows that need your attention come first.
If it looks right, click Import, which shows how many members it will create. Otherwise fix the spreadsheet and click Choose a Different File.
Rows with errors aren't imported, but the rest are. Typical errors are a missing business name, a date that can't be read, or an email address that isn't valid.
Duplicates
A row is skipped when its business name, ignoring capitals, matches a business already in your member list, or an earlier row in the same file. Existing members are never changed by an import, so you can't use it to update records. Edit those on each member's page.
Archived members aren't in your member list, so a business you archived is imported again as a new member.
What an import creates
Each row becomes a member business with the status, level, industry and dates from the file. If the row has a contact name or contact email, that person is added as the member's contact, marked primary and billing. A row can carry one contact; add others on the member's page afterwards.
What an import doesn't do
- It doesn't send welcome emails or start onboarding emails. Imported members are treated as members who joined long ago.
- It doesn't invite contacts to the member portal. Invite them from the Contacts section on each member's page. See The member portal.
- It doesn't record payments or credit. Record past payments by hand if you need them. See Dues and payments.
- It doesn't import logos, descriptions, hours or social links. Members can add those in the member portal.
Who can import
Owners, admins and staff. For board members and volunteers, Import CSV is locked.