How to Import Opportunities Using a Single CSV File

Why Import Opportunities with a CSV?

CSV imports are ideal when you have a lot of deals to bring into BizStackPro at once—like migrating from another CRM, syncing external spreadsheets, or standardizing pipeline tracking.

• Centralize opportunity data into one pipeline system
• Reduce manual entry with bulk imports
• Create new opportunities, update existing ones, or do both
• Include custom fields for richer reporting
• Catch issues early with preview + error reporting

Prepare Your CSV Before Uploading

A clean file prevents import failures and makes mapping faster.

• Keep the file under 30 MB and include a header row.
• Include mandatory fields (commonly: Contact ID, Opportunity Name, Pipeline Name).
• If you’re updating existing opportunities, include the Opportunity ID for each row.
• Remove extra spaces, inconsistent formatting, and duplicate rows before importing.

Import Opportunities (Step-by-Step)

1. Open Opportunities and start the Import flow.
2. Choose whether you want to Create, Update, or Create + Update.
3. Upload your CSV file.
4. Map each CSV column to the correct BizStackPro field (including custom fields if needed).
5. Review the preview to confirm data is landing in the right fields.
6. Run the import, then monitor progress and issues using Show Stats (errors + warnings).

File Structuring and Field Formatting

Formatting issues are one of the most common causes of import errors. Use the rules below to keep your file compatible.

• Date fields: Use supported formats: mm/dd/yyyy, yyyy/mm/dd, mm-dd-yyyy, or yyyy-mm-dd.
• Multi-select / checkbox fields: Separate values with commas, semicolons, or periods.
• Single-option (radio) fields: Enter one valid option exactly as it appears in the system.
• Tags: Separate multiple tags with commas, semicolons, or periods.
• Phone fields: Prefer E.164 format, or consistent standard formatting (avoid mixed styles in one column).
• Numbers / money: Use consistent numeric formatting throughout the column.

Troubleshoot Common Import Errors

• Required fields missing: Add the mandatory columns and ensure they’re populated for every row.
• Invalid Contact ID: Confirm the Contact ID exists in BizStackPro before importing.
• Could not parse date: Fix the date format to match one of the supported formats.
• Invalid dropdown value: Match values exactly to existing system options (or add the option first).
• Duplicate unique property: Remove duplicates where a field must be unique.

Best Practices for Large Imports

• Split big files into smaller chunks for easier troubleshooting.
• Import new opportunities first, then run a separate update import if needed.
• Don’t refresh the page while an import is processing.
• Use Show Stats to review errors and warnings after the run.