[SalesForce] 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.)

Best Answer

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

Related Solutions

[SalesForce] Correct Date format for Developer Console Query Editor

Try:

SELECT Site__c, Cluster__c, Date__c, Num_Att_records__c 
FROM Session__c  
Where Session__c.SiteProgram__r.Name = 'Brattleboro' AND Date__c = 2012-11-06

Note the leading 0 on the 06.

The format is YYYY-MM-DD, so you need to pad the extra 0.

[SalesForce] Query Builder in Developer Console

No, the query / SOQL capabilities of the dev console are fairly rudimentary. Your best bet is to stick with the Eclipse plugin or look at either Workbench (http://workbench.developerforce.com) or google for Simon Fells Pocket SOQL explorer.

Best Answer

Related Solutions

[SalesForce] Correct Date format for Developer Console Query Editor

[SalesForce] Query Builder in Developer Console

Related Topic