O365 - Export list to excel limitation

Hi, I have two big SharePoint list. One with 20 000 items, that I can export without problem with the export excel button. Another one with only 11 000 items, which I can't export because of ...

SharePoint Online

Ramona Badea
May 24, 2018
Hello :),
One easy way of overcoming this issue would be to change the default view filter for your list default Allitems.aspx.
This way when you go back and click on "Export to Excel" your list should be imported (despite the threshold).

You have multiple options to get over this error tho:

- Use Indexed Columns & filtered views

- Orgzanize your items into folders and do it separately
- Limit the items on display

- Edit the default view

*Note: Excel only allows 52,000 rows imported from SPO.

Ramona Badea

Former Employee

May 24, 2018

Hello :),
One easy way of overcoming this issue would be to change the default view filter for your list default Allitems.aspx.
This way when you go back and click on "Export to Excel" your list should be imported (despite the threshold).

You have multiple options to get over this error tho:

- Use Indexed Columns & filtered views

- Orgzanize your items into folders and do it separately
- Limit the items on display

- Edit the default view

*Note: Excel only allows 52,000 rows imported from SPO.