Forum Discussion
O365 - Export list to excel limitation
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.
jasonthe - Honestly, at the present moment, I can't say exactly.. (you could ask someone from MS Support if there still exists a precise limit)
What I know is that there is a limit and that it depends on the type of fields that you have on the list. It is not a number of lines that define the limit, because each type of field can have different sizes.. :)
