Can you export a view into Excel without creating a report? - Answers - Salesforce Trailblazer Community
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?
Chris O DaviesChris O Davies
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
Ben FordBen Ford
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 Ezra RayburnEric Ezra 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.
Ben FordBen Ford
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. 
Ben FordBen Ford
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
Christie BreenChristie Breen
My boss just asked me today if there was a way to export selected items in the leads list view to excel. I knew what fields he needed so I made the following visualforce page (Obviously you won't have my custom fields). Probably could do something snazzier, getting the fields selected in the current list view or something, but this did what he needed it to do.

I then just made a list button that opened the vp page and added it to the List View Search Layout

VF Page
<apex:page readOnly="true" standardController="Lead" recordSetVar="leads"  extensions="ExcelExportLeadButton" showHeader="false"  applyHtmlTag="false" contentType="application/vnd.ms-excel#leads.csv" applyBodyTag="false" lightningStylesheets="false"  standardstylesheets="false" cache="false">
"email","additional email","first name","last name","company","overall rating"
<apex:repeat value="{!selectedLeads}" var="lead">
"{!lead.email}","{!lead.Additional_Email__c}","{!lead.firstname}","{!lead.lastname}","{!lead.company}","{!lead.Score__c}"
</apex:repeat>
</apex:page>

Controller:
public with sharing class ExcelExportLeadButton {
    private ApexPages.StandardSetController standardController;
    public List<Lead> selectedLeads {get;set;}
    public ExcelExportLeadButton(ApexPages.StandardSetController standardController)
    {
        this.standardController = standardController;
        selectedLeads = (List<Lead>) standardController.getSelected();
        List<ID> ids=new List<ID>();
        for(Lead l :selectedLeads) {
            ids.add(l.id);
        }
        selectedLeads=[select email, additional_email__c, firstname, lastname, company, score__c, id from Lead where id in :ids order by email];
    }
}

And my test
@istest
public class ExcelExportTest {
  static testmethod void controllerTest() {
		Lead l=new Lead(Company='Testing', FirstName='Joe', LastName='Smith', email='no2@way.com');
        insert l;
      	Lead l2=new Lead(Company='Testing2', FirstName='Joe2', LastName='Smith', email='no3@way.com');
        insert l2;
      	List<Lead> leads=[select email, additional_email__c, firstname, lastname, company, score__c, id from Lead];
     	
 		ApexPages.StandardSetController sc = new ApexPages.StandardSetController(leads);
     	ExcelExportLeadButton ex= new ExcelExportLeadButton(sc);
	    System.assert(ex.selectedLeads !=null);

    }
}

 
Rahul SharmaRahul Sharma
Hi all, those who are tired of looking for workarounds and exploring AppExchange apps, I have created an application that will exactly do your job, and it's free of cost too! 

Follow this linkhttps://github.com/rahulsharma-github/Export2Excel

Please appreciate the hard work by marking this answer as best if you find this solution helpful
Kristopher HollenKristopher Hollen
Rahul your solution does not seem to support communities. Is there a way for your solution to work within custom Object List views in communities? we have followed the information in your Git but have not been able to successfully get it to function from the community standpoint as the List View buttons in Salesforce do not support Visualforce Pages sourced as a URL.
 
Ben FordBen Ford
Hi Kristopher,

Did you try the following app? it is native app and you can customize everything (you can put a smart list anywhere and customize the fields, buttons, colors, groupings, etc...).

https://appexchange.salesforce.com/listingDetail?listingId=a0N30000009uXwyEAE
http://www.zaapit.com

Export to xls /. csv