How to copy entire Salesforce report when only visible screen data copies

using Coefficient excel Add-in (500k+ users)

Learn how to copy entire Salesforce reports beyond the 30-row visible screen limitation. Get complete datasets with all rows and formatting preserved.

salesforce to google sheets connector

“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.”

5 star rating coeff g2 badge

When you copy data from a Salesforce report, you’re only getting the 30-50 rows visible on your screen, not the complete dataset. This happens because browsers can only copy DOM elements currently rendered in the viewport.

Here’s how to access your entire report data without the visible screen limitations that plague standard copy-paste operations.

Import complete Salesforce reports using Coefficient

CoefficientSalesforce’sSalesforceconnects directly toAPI to import entire reports into Google Sheets or Excel. Unlike copy-paste which only grabs visible screen data,reports through Coefficient can include thousands of rows with all original formatting and data types preserved.

How to make it work

Step 1. Connect Coefficient to your Salesforce org.

Install Coefficient from the Google Workspace Marketplace or Microsoft AppSource. Click “Add Data” and select Salesforce from the list of available integrations. You’ll need API access permissions in your Salesforce org to establish the connection.

Step 2. Select “Import from Existing Report.”

Choose this option from the Salesforce import menu. You’ll see a list of all reports available in your org, including those with thousands of rows that would be impossible to copy manually.

Step 3. Choose your target report and import the complete dataset.

Select the report you want to import and click “Import.” Coefficient will pull all rows from the report, regardless of size, maintaining the original data structure and field relationships from Salesforce.

Step 4. Set up automatic refreshes to keep data current.

Configure scheduled refreshes (hourly, daily, or weekly) so your spreadsheet stays synchronized with the latest Salesforce data. This eliminates the need for repeated manual copying as your reports update.

Get your complete datasets without the copy-paste hassle

Try CoefficientThis approach transforms tedious 30-row copying into single-click complete dataset imports. You’ll have access to all your Salesforce report data with preserved formatting and automatic updates.to eliminate visible screen limitations entirely.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies