function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Johnny Li 6Johnny Li 6 

Export the Account details to the Excel format

I would like to export my company database under the account (around 2500+ customers information) from salesforce to excel format. How can I do it, please? Kindly give me the brief instruction and I would work it out from here.
ShirishaShirisha (Salesforce Developers) 
Hi Johny,

Greetings!

You can use dataloader or Workbench to export the data from salesforce in Bulk.

Reference for dataloader :https://help.salesforce.com/articleView?id=sf.loader_configuring_bulk_api.htm&type=5

Reference for Workbench:https://salesforceoke.blogspot.com/2019/05/salesforce-workbench-export-csv.html

Please mark it as best answer if it helps you to fix the issue.

Thank you!

Regards,
Shirisha Pathuri
Johnny Li 6Johnny Li 6
Thanks for your info! It seems doesn't work. Do you have the video click that I can follow on the demostration? 
CharuDuttCharuDutt
Hii Johnny Li 6
Try The Following Steps
1: Go to setup Search "Export" in Quick Find Box
2: Select "Data Export"   after That Click on "Export Now" Button.
3: Select the object of which you want the Data and Click "Start Export" Button
4: After the Progress Completed Click On Download Option In  Under The Action.    Accounts Database Will Be in  Zip File  in Excel Format

Please Mark it as Best Answer If It Helps.
Thank you!
Johnny Li 6Johnny Li 6
Thanks a lot! Looks better after I followed your instructions, but unfortunately all my contact details are losing out the company names in the csv sheet. I do suspect the Company Names was fallen into the "Accounts" and those contact details (e.g. Person's Name, Telephone, Fax, Email address) are fallen into the "Contacts" in the csv sheet. Once I export the Account Database and the "Accounts" do only have the Company Name and "Contacts" do only have Person's Name, Telephone, Fax, Email address". Therefore, I cannot identify which contact persons are belonging to which company? How can I merge these two parts together into the same excel sheet, please? I am looking forward to your fruitful assistance. Thank you so much! 
Thomas FolThomas Fol
You can Export the account details to the CSV format automatically using the Skyvia no-code platform. Skyvia also allows you to save data to file storage or SFTP/FTP. It is freemium
Read here (https://skyvia.com/data-integration/salesforce-data-loader)