In case you have no access to the workbench, can we download the query result from the Developer Console?
Build a Query in Developer Console
Open Developer Console, File > Open > Objects > select an object > click Open (or double click the object name).
Select the fields by hold the Ctrl key (and Shift key) for Windows users, then hit the Query button, Id field will be auto-added.
Click the Execute button, developer console will open a tab with the query result.
Thank you but the "Copy element" doesn't work because when I tried to Paste it into Excel, it includes the HTML tags. None of the other Copy/Paste options worked. Could you please clarify the Excel version and the exact Paste option you're choosing. I ended up doing the query in the Workbench and exporting as CSV but I may not always have access to the workbench, so this could be very helpful to someone. I hope Salesforce will add this functionality out of the box someday.ReplyDelete
I just try and it works, it is simply a copy and paste.Delete
I am using Microsoft Excel version 2102 (Build 13801)
It took me a good 15 tries (and because I am stubborn, I kept doing it over and over and over again). I honestly don't know what I did differently the last time because, come on, this is copy and paste. But it didn't work the first bunch of times.ReplyDelete
assume you manage to get it works!Delete
I did. Thank you for this information. Very helpful.Delete
awesome, glad to hear it 😊Delete
Johan, this article was very helpful for me and your outlined solution worked for me.ReplyDelete
awesome, glad to hear!Delete
Is it just me or does it only grab the first 2,000 records?ReplyDelete
I am not sure how to get more 2K in Developer Console query editor, but you can use workbench to get all records https://workbench.developerforce.com/login.phpDelete
Use workbench application and download it as excel.ReplyDelete
Thank you for posting this. Works perfectly.ReplyDelete