Export Results from Developer Console - Query Editor?

  • I'm a huge fan of the Query Editor in the SFDC Developer Console:

    screenshot of query editor with results

    Is there a way to export the table of results as JSON/csv/excel or in some format that can be consumed by Excel?

    (I know that I can replicate the functionality in DemandTools or other tools, but sometimes when I've thrown up a query for debugging, it would be really handy to be able to export and manipulate the results.)

    The dev console was not built for this. You can copy your query and paste it in the Force.com data loader. Its a powerful tool.

  • The Developer Workbench will allow you to, among other things, build SOQL queries and save the results as CSV: https://workbench.developerforce.com/login.php

    Good call - I find the Developer Console quicker for quick exploration and debugging, but good to remember that I can always copy my query over to Workbench.

    Sadly the Developer Workbench is restricted, when it comes down to relationship or aggregate queries. There are often times, when the Developer console is the only way to get the results.

License under CC-BY-SA with attribution

Content dated before 7/24/2021 11:53 AM