PlumHelp
Help · Accounts and contacts

Importing contacts and companies

Bring the people you work with in from a spreadsheet. Each row becomes a contact under their company's account, and nothing is added until you've checked the preview.

Everyone except viewers

Open Bring your data, linked from the Get set up checklist on the Overview, from Integrations and from the other import pages, and select Contacts and companies. It works with Excel, Google Sheets and Numbers.

  1. Choose an Excel (.xlsx) or CSV file, or copy the rows from your spreadsheet, header row included, paste them in and select Continue. In an Excel file, the first sheet is read.
  2. Match your columns. Plum guesses from your headers. Every column is optional, but each person needs a name or an email: First name, Last name, or a Full name that Plum splits into the two, and Email, Phone, Job title, Company and Company website or domain.
  3. Check the preview. Rows that can't be imported are listed by row number with the reason.
  4. Select Import.

How companies are matched

  • A company whose website or domain matches an account's domain joins that account. Plum reads https://www.acme.com/about as acme.com.
  • Otherwise, a company joins the account with the same name, ignoring case and spacing.
  • A person with no company but a work email joins the account that has their email's domain. Addresses at gmail.com, outlook.com and other public mailboxes never match an account.
  • A company with no match becomes a new account, with its domain if the sheet gives one.

What Plum reads

  • Full names such as Ada Lovelace, or Lovelace, Ada. The first word is the first name and the rest is the last name, unless there is a comma.
  • Emails are kept in lower case. Something in the email column that isn't an address is reported, not imported.
  • Dates in Excel files are read as dates. In CSV files, dates such as 2026-11-14, Nov 14, 2026 or 14 Nov 2026 are read; dates with slashes are read month first.

What happens

Either every contact is added or none is. You are the owner of the contacts and of any new accounts. Someone whose email is already in Plum is left as they are, and so is the same person appearing twice in the sheet, so importing the same sheet twice is safe. Afterwards, the page says how many contacts and accounts were added.

Your workspace's own contact fields each get a column too, matched to a spreadsheet column with the same name where there is one. A row whose value doesn't fit, or that leaves a required field empty, is reported and left out.

You can import up to 2,000 rows at a time. Older Excel files (.xls) and Numbers files need saving as .xlsx or CSV first.

Related