)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce’s native export functionality caps out at 50,000 records per export, creating a major bottleneck when you need to extract large lead databases for analysis or backup purposes.
Here’s how to bypass this limitation completely and export your entire lead database without restrictions.
Export unlimited leads using Coefficient
Coefficient connects directly to Salesforce’s API rather than using the standard UI export tools, which means it completely bypasses the 50,000 record limitation. You can import all your leads directly to Salesforce or Excel without hitting export restrictions.
How to make it work
Step 1. Connect Coefficient to your Salesforce org.
Install the Coefficient add-on in Google Sheets or Excel. Click “Import from Apps” and select Salesforce. Authenticate using your Salesforce credentials to establish the API connection.
Step 2. Choose your import method based on your needs.
For all leads with custom field selection, use “From Objects & Fields” and select the Lead object. For specific lead segments, use “Custom SOQL Query” to write targeted queries. If you have existing reports, use “From Existing Reports” to import any Salesforce lead report regardless of size.
Step 3. Select all desired fields and apply any filters.
Choose which lead fields to include in your export. You can select standard fields like Name, Company, Email, Status, and Source, plus any custom fields your organization has created. Apply filters if you need specific lead segments rather than your entire database.
Step 4. Handle API limitations if they apply.
If MFA is enabled on your org, you’ll hit a 2,000 row limit unless you include a unique ID field in your import. For larger datasets, create multiple filtered imports and combine them, or work with your Salesforce admin to temporarily adjust API limits.
Step 5. Set up automatic refreshes to keep data current.
Schedule your import to refresh automatically on a daily, weekly, or custom schedule. This maintains a live connection to your Salesforce data without needing to manually re-export when new leads are added.
Keep your lead data current without manual exports
The key advantage over native Salesforce exports is that your data stays current automatically. Start exporting your complete lead database today without hitting arbitrary record limits.
