Can you export a view into Excel without creating a report? - Answers - Salesforce Trailblazer Community
Ask Search:
Tanya WallsTanya Walls 

Can you export a view into Excel without creating a report?

I need to export a view into Excel without creating a report.  Is that able to be done?
C DC D
You cannot export list view, you will need to create a report and export the report into excel.
You can add your view criteria to your report and it will give you the same result.

also It is worth voting this idea:
http://success.salesforce.com/ideaView?c=09a30000000D9xt&id=08730000000Bp1yAAC
Steve MolisSteve Molis
You can't do a straight export, but you can print a List View (if the feature has been enabled in the User Interface) and you can copy&paste a List View into a spreadsheet.  But you're much better off just using a Report.
Javier GonzalezJavier Gonzalez
The hackish way to do it is to click on the Pintabe View icon on the top right of the list, then select and copy paste into Excel.
Krystal TamKrystal Tam
This needs to be an idea so everyone can vote!
Rob NelsonRob Nelson
Here is the idea, go vote for it - https://success.salesforce.com/ideaView?id=08730000000BqpbAAC&sort=2 - it has 9720 points (so 972 upvotes) suggested 8 years ago, so I won't be holding my breath waiting for it. 
Eric PolichukEric Polichuk

Salesforce Data Exporter. Extension for Chrome that does exactly what you need.

https://chrome.google.com/webstore/detail/salesforce-data-exporter/fimhgbeiaffioifgjfcfjnphifipknao

Wes SnowWes Snow
Yes, a new tool called Ascendix Search allows you to export views to excel without a report and more: https://goo.gl/fLsmUH
Ford BenFord Ben
The following AppExchange app allows you to export from any view, it also got mass update/edit/delete/create and much more...

The app: https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009uXwyEAE
The provider: http://www.zaapit.com/page/smart-tables

A screenshot of the export process:
Export exmaple
 
Mireia ParésMireia Parés
is it possible to use the Chrome data exporter in the lightning version? Thanks!
Eric RayburnEric Rayburn
Hi Mireia,
It has almost been a year since you posted your question
Data Exporter is amazing
https://chrome.google.com/webstore/detail/salesforce-data-exporter/fimhgbeiaffioifgjfcfjnphifipknao
switch from lightning to classic refresh and you can export your list view 
Denise CrosbyDenise Crosby
@Eric Ezra Rayburn,
I tried the solution you mentioned. The chrome extension just sits there and says "Exporting" forever. I can't get it to work.
Ford BenFord Ben
Use the following app:
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009uXwyEAE
http://www.zaapit.com/page/smart-tables
zaapit export from list view
Eric PolichukEric Polichuk
Try https://chrome.google.com/webstore/detail/columncopy/lapbbfoohlcmlbdaakldmmallcbcbpjb?hl=en
It's a good alternative when installing an app is not an option and when Salesforce data exporter is not working properly. You can copy a column or an entire table. The only drawback is it copies 1 page at a time. 
Ford BenFord Ben
It is better to install an app from the AppExchange vs. an unknown source (AppExchange apps pass a security review and salesforce's internal verification process):
https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009uXwyEAE
http://www.zaapit.com/page/smart-tables
User-added image
 
Denise CrosbyDenise Crosby
Too bad there has to be an additional fee for this type of basic functionality. I will create some reports and see if that will satisfy the users for now. Thanks for the info