All docs

CRM & PEOPLE

Import opportunities

Load your existing pipeline into UpSight from a spreadsheet.

If your deals live in a spreadsheet or another CRM, you can bring them in so opportunity tracking starts with your real pipeline. This is done by asking Uppy, with the rows pasted into chat.

To bring in the people on those deals, see Import people and organizations. To work with the deals afterward, see CRM and opportunities.

Import opportunities from a spreadsheet

Use this to load an existing pipeline so you start with your real deals. Opportunities are imported through Uppy in chat. The Import CSV screen under People does not import deals.

  1. Copy the rows from your spreadsheet, including the header row. Clear headers work best, such as deal ID, opportunity name, account, amount, stage, close date and next step.
  2. Open Uppy, type "Import these as opportunities:", paste the rows below it, and send.
  3. Uppy reads the table, matches the columns, and imports the deals. It creates an organization for any account it does not know yet.
  4. Open Opportunities to check the new deals.

What columns work

Opportunity name is the only essential one. Others UpSight understands include deal ID, account, amount and currency, stage, close date, confidence, next step, source, description, forecast category, contact name or email, owner and pipeline.

Good to know

  • Include a deal ID column. Rows whose ID is already in the project are skipped, so you can safely import the same sheet twice.
  • Contacts and owners are matched to people and teammates that already exist. If there is no match, the deal still imports without that link.
  • Import adds new opportunities. It does not update existing ones.
  • Use the same stage names throughout, and dates as YYYY-MM-DD.