)
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.”
Copy-paste only captures 30 rows because browsers can only copy visible DOM elements, and Salesforce uses pagination to improve page performance. The remaining rows exist in the database but aren’t rendered in your current viewport.
This visible screen limitation is a fundamental browser constraint, but there’s a way to access your complete datasets without the 30-row restriction.
Access complete datasets beyond browser limitations using Coefficient
CoefficientSalesforce’sSalesforce’seliminates the 30-row copy-paste limitation by connecting directly todata layer rather than copying from the rendered interface. When you import a report through Coefficient, you’re accessing the complete dataset fromAPI, not the limited viewport display.
How to make it work
Step 1. Install Coefficient and connect to Salesforce.
Add Coefficient to Google Sheets or Excel from their respective app stores. Connect to your Salesforce org using your existing login credentials and API access permissions.
Step 2. Choose “Import from Existing Report” from the Coefficient menu.
Select this option to see all available reports in your Salesforce org. You’ll have access to reports with hundreds or thousands of rows, not just the 30 visible on screen.
Step 3. Import your complete dataset in one operation.
Select your target report and click import. Coefficient will pull all rows from the report while preserving original data formatting and field types. No manual page navigation required.
Step 4. Enable automatic updates for ongoing data access.
Set up scheduled refreshes so your spreadsheet automatically updates when the underlying Salesforce data changes. This eliminates the need to repeatedly copy 30-row chunks as your data grows.
Transform your data workflow from chunks to complete datasets
Try CoefficientThis approach changes your workflow from repeatedly copying 30-row sections to importing entire datasets in one operation. You get access to all your data with preserved formatting and automatic updates.to eliminate copy-paste limitations.
