Export SOQL Query to Excel & Google Sheets

If you’re a user of Salesforce and enjoy writing SOQL to get data out of your salesforce instance then you’re probably also frustrated that there is no export option on the Developer console in Query Editor and certainly no easy way to sync data to Excel, Google Sheets, Airtable or other platforms. In this tutorial we’re going to show you how.

What We’ll Cover

  • Live based tool to enter a SOQL query and either export to CSV or Google Sheets
  • How to setup your own SOQL Exports into Excel, Airtable or Google Sheets
  • How to have your SOQL query run on a schedule and continuously update
  • Links to some other helpful Salesforce developer content for people who love data

Export SOQL Query

SyncWith works with 100,000s of business to enable them to sync data from any API, here’s an example of the tech running live in this web page:
  • OAuth to your SF instance
  • Enter a SOQL query (with a default example provided)
  • Get a Google Sheet with the SOQL query setup to sync
  • Download a CSV

Preview

Expand nested data, rename and delete columns

Column 1
Column 2
Column 3
Column 4
Column 5
     
     
     

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Setup Exports to Sheets, Excel or Airtable

Syncwith provides addons for Excel, Google Sheets and Airtable to sync and export SOQL queries to your platform of choice, to see how easy it is we can take a look at doing this in Google Sheets:
If you’re interested in doing exports to either of these platforms please check out our in depth guide to exporting dynamically from Salesforce or get started right away by installing our add on / extension for either of these platforms:

Export SOQL Query on a Schedule

notion image
Want your SOQL query to run and export every hour, or every day - no problem, simply set your refresh schedule and enjoy data that is always as up to date as you need it to be.

More Helpful Salesforce Developer Data Content