SOLVED

O365 - Export list to excel limitation

%3CLINGO-SUB%20id%3D%22lingo-sub-197223%22%20slang%3D%22en-US%22%3EO365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197223%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20big%20SharePoint%20list.%20One%20with%2020%20000%20items%2C%20that%20I%20can%20export%20without%20problem%20with%20the%20export%20excel%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20one%20with%20only%2011%20000%20items%2C%20which%20I%20can't%20export%20because%20of%20the%20thresold%20limitation.%20I%20think%20they%20might%20be%20a%20configuration%20somewhere%2C%20but%20can't%20find%20out%20where%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20list%20I%20can%20export%20is%20an%20old%20one%2C%20can't%20remember%20what%20sort%20of%20configuration%20I%20did.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20hekp%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390768%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390768%22%20slang%3D%22en-US%22%3EThanks%20Ramona%2C%20that%20makes%20sense.%20Seems%20difficult%20to%20find%20an%20official%20MS%20article%20specifically%20on%20the%20Export%20to%20Excel%20limitations.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-390764%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-390764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F309357%22%20target%3D%22_blank%22%3E%40jasonthe%3C%2FA%3E%20-%20Honestly%2C%20at%20the%20present%20moment%2C%20I%20can't%20say%20exactly..%20(you%20could%20ask%20someone%20from%20MS%20Support%20if%20there%20still%20exists%20a%20precise%20limit)%3CBR%20%2F%3EWhat%20I%20know%20is%20that%20there%20is%20a%20limit%20and%20that%20it%20depends%20on%20the%20type%20of%20fields%20that%20you%20have%20on%20the%20list.%20It%20is%20not%20a%20number%20of%20lines%20that%20define%20the%20limit%2C%20because%20each%20type%20of%20field%20can%20have%20different%20sizes..%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389786%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131685%22%20target%3D%22_blank%22%3E%40Ramona%20Badea%3C%2FA%3E%26nbsp%3BMy%20team%20was%20able%20to%20export%20a%20list%20with%20~68000%20items.%20Has%20this%20limitation%20been%20increased%3F%20Is%20there%20a%20new%20official%20max%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197599%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197599%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BThat%20was%20this%2C%20I%20had%20a%20filter%20on%20my%20default%20view%20for%20one%20list%20but%20not%20for%20the%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197421%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197421%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20option%20is%20to%20use%20MS%20Access%20with%20a%20link%20to%20an%20External%20Table%20that%20is%20pointing%20to%20your%20SP%20List%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197410%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197410%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3A)%2C%26nbsp%3B%3CBR%20%2F%3EOne%20easy%20way%20of%20overcoming%20this%20issue%20%3CSTRONG%3Ewould%20be%20to%20change%20the%20default%20view%20filter%20for%20your%20list%20%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3Edefault%20Allitems.aspx.%3C%2FSTRONG%3E%3CBR%20%2F%3EThis%20way%20when%20you%20go%20back%20and%20click%20on%20%22Export%20to%20Excel%22%20your%20list%20should%20be%20imported%20(despite%20the%20threshold).%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EYou%20have%20multiple%20options%20to%20get%20over%20this%20error%20tho%3A%3C%2FP%3E%0A%3CP%3E-%20Use%20Indexed%20Columns%20%26amp%3B%20filtered%20views%3C%2FP%3E%0A%3CP%3E-%26nbsp%3BOrgzanize%20your%20items%20into%20folders%20and%20do%20it%20separately%26nbsp%3B%3CBR%20%2F%3E-%20Limit%20the%20items%20on%20display%3C%2FP%3E%0A%3CP%3E-%20Edit%20the%20default%20view%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E*Note%3A%20Excel%20only%20allows%20%3CSPAN%3E52%2C000%26nbsp%3Brows%20imported%20from%20SPO.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34818iDD6EE931C47C4DCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture1.JPG%22%20title%3D%22Capture1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34817i2AAF1B0D6D09B492%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture2.JPG%22%20title%3D%22Capture2.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197338%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197338%22%20slang%3D%22en-US%22%3EHave%20you%20tried%20to%20add%20any%20index%20to%20the%20problematic%20list%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-464637%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-464637%22%20slang%3D%22en-US%22%3ENote%202%3A%20The%20limit%20of%2052%2C000%20rows%20imported%20from%20SPO%20might%20not%20still%20be%20accurate%20at%20the%20present%20moment%20of%20time.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-840330%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20-%20Export%20list%20to%20excel%20limitation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840330%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI've%20a%20list%20with%20350.000%20items.%20I%20created%20list%20view%20like%20your%20did%20but%20it%20exported%20only%204000%20items.%20How%20can%20I%20export%20all%20items%20into%20excel%3F%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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 the thresold limitation. I think they might be a configuration somewhere, but can't find out where ?

 

The list I can export is an old one, can't remember what sort of configuration I did.

 

Thanks for your hekp

8 Replies
Have you tried to add any index to the problematic list?
Best Response
Solution

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.

 

Capture1.JPGCapture2.JPG

Another option is to use MS Access with a link to an External Table that is pointing to your SP List

 That was this, I had a filter on my default view for one list but not for the other.

 

Thanks a lot

@Ramona Badea My team was able to export a list with ~68000 items. Has this limitation been increased? Is there a new official max?

@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.. :) 

Thanks Ramona, that makes sense. Seems difficult to find an official MS article specifically on the Export to Excel limitations.
Hi,
I've a list with 350.000 items. I created list view like your did but it exported only 4000 items. How can I export all items into excel?