cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Highlighted
Level 1

Cannot export customer list to excel It says file is too big and list doesn't have filter option what should i do ?

 
2 Comments
Level 6

Cannot export customer list to excel It says file is too big and list doesn't have filter option what should i do ?

Highlighted
QuickBooks Team

Cannot export customer list to excel It says file is too big and list doesn't have filter option what should i do ?

Hi there, @Asad Tariq.

 

You can consider removing some columns you don't need to be displayed to export the customer list to Excel successfully. Let me guide you through the process.

 

Before we start, please know that there are size limits when exporting data to Excel. Here are the following:

 

  • Maximum of 1024 columns displayed
  • Maximum 400k cells with data
  • Maximum 10MB worth of data

If your data exceed the size limits, let's eliminate some columns that you don't need. Here's how:

 

If you're exporting the data from the Customer page, please follow the steps below:

 

  1. Click Sales from the left panel, then select Customers.
  2. On the page, click the Gear icon.
  3. Select a column that you don't need to be displayed.
  4. Then, click the export icon to export the data to Excel.1.PNG

If you're exporting it from the report, feel free to go along with the steps below:

 

  1. Click Reports from the left panel, then search for Customer Contact List.2.PNG
  2. In the report, click the Gear icon, then remove the unnecessary columns.3.PNG
  3. Select the export drop-down, and choose Export to Excel.4.PNG

You can read these articles for more details:

 

You can always get back to here in the Community if you have any other questions. I'm always here to help. Have a great day ahead.

Need to get in touch?

Contact us