cancel
Showing results for 
Search instead for 
Did you mean: 
Asad Tariq
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 2
Fiat Lux - ASIA
Level 15

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

Mark_R
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