Blog Layout

Copy query results from Salesforce Developer Console and paste to Excel

Mike Arthur • Aug 16, 2016

Developer Console is a quick way to fire off a Salesforce SOQL query but there's no standard way to be able to copy the results and paste them into Excel. Using Workbench instead is one option but if you happen to be working in Dev Console there is a way to do it -

  • In your browser, Firefox in my case, right click on the Query Results and click 'Inspect Element'
  • In the inspector, find the div that starts '<div id="gridview...'
  • Untick 'moz-user-select' in the '.x-unselectable' section to the right
  • Now you can select and copy from the Query Results and paste into Excel

Thanks to Sergey Utko's reply on StackExchange - http://salesforce.stackexchange.com/questions/15328/export-results-from-developer-console-query-edit...

My Blog of Salesforce Stuff

by Mike Arthur 16 Oct, 2021
'XHR Failed' error when trying to install VS Code extension
by Mike Arthur 09 Jun, 2020
What is $A (dollar A) in Lightning Aura component framework? Is it a global variable? Where are the docs for $A?
by Mike Arthur 08 May, 2020
Authorise a Salesforce Connected App using OAuth 2.0 JWT Bearer Flow
by Mike Arthur 26 Apr, 2020
REST API Connection to Salesforce Connected App Using OAuth 2.0 Authentication from Postman
by Mike Arthur 23 Mar, 2020
How to create a Lightning tab menu with dropdown sub-menu
by Mike Arthur 27 Nov, 2018
How to show a month by month trend chart with multiple years on same chart
by Mike Arthur 06 Nov, 2018
What to do if you receive emails about expiring certificates
22 Aug, 2018
Process json strings when working with integrations
by Mike Arthur 22 Aug, 2018
If you're switching email accounts you can copy appointments from one calendar to the other
by Mike Arthur 22 Aug, 2018
When you search in Outlook 2016, how do you see in which folder you filed an email in the results?
More posts
Share by: