+ Start a Discussion
Nathan Prats 17Nathan Prats 17 

SOQL Query with Sum directly in Excel


I'd like to do reporting outside Salesforce. I need to be able to run a SOQL Query that return a Sum(Amount) directly in Excel. I know I can do this with Conga Composer but I can't use this tool. I tried with Excel Connector but it doesn't work = it returns rows. 

Anyone has an idea ? 

NagendraNagendra (Salesforce Developers) 
Hi Nathan,

Description: You can make use of Workbench which is a powerful, web-based suite of tools designed for administrators and developers to interact with Salesforce organizations via the Force.com APIs.

A need might arise to export the SOQL query results of workbench to an Excel sheet so that you can analyze the data. There is no standard way or a button which is available for users to export the query result. 

Resolution: Please check with below salesforce help document for your reference which has step by step explanation with screenshots. Hope this helps.

Please mark this as solved if it's resolved so that it gets removed from the unanswered queue which results in helping others who are encountering similar issue.