PlumHelp
Help · Pipeline and deals

Importing deals

Bring your pipeline in from a spreadsheet. Each row becomes a deal, and nothing is added until you've checked the preview.

Everyone except viewers

Open Pipeline and select Import from a spreadsheet. 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. Save an older Excel file (.xls) or a Numbers file as .xlsx or CSV first.
  2. Match your columns. Plum guesses from your headers. Deal name is required; Company, Stage, Deal value (annual recurring), One-time amount, Expected close date and Next step are optional.
  3. Match your stages. Pick a Plum stage for each value in your stage column, or Don't import these. With no stage column, pick one stage for every deal.
  4. Check the preview. Rows that can't be imported are listed by row number with the reason.
  5. Select Import.

What Plum reads

  • Amounts such as $48,000, 48k or 1.2M.
  • Dates such as 2026-11-14, Nov 14, 2026 or 14 Nov 2026, and dates in Excel files as they are. Dates with slashes are read month first.
  • Companies are matched to accounts you already have by name, ignoring case and spacing. A company with no match becomes a new account.

What happens

Either every deal is added or none is. You are the owner of the deals and any new accounts. A deal already in Plum with the same name and company is left as it is, so importing the same sheet twice is safe. Afterwards, Pipeline says how many deals and accounts were added.

Your workspace's own deal fields each get a column too, matched to a spreadsheet column with the same name where there is one. Numbers, dates and yes-or-no values are read as such; a pick-list column matches on the names of its choices. 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. Deals imported into won, lost or nurture stages are on their account pages, not the pipeline list.

Related