When I export my list from SharePoint, there are extra items showing up in the excel sheet that are not in the list. Why is this?

  • Patrick: did you find a solution to your "hidden items"? I have the same issue and I'm lost on how to reconcile. I also noticed that in the exported list, the file size for my "hidden items" shows as 0 (zero) bytes. I've just chosen to ignore these items, but it is disturbing to see them when I do the export. Any help would be great.
    – SwimChick
    Commented Jun 10 at 15:39

1 Answer 1


Excel can not invent the data for the extra rows. It has to come from your list. The most likely reason why you don't see these rows in SharePoint is that a filter is applied on your list. It could be a different view, but in theory, if you start from a given view, the Excel export should apply to the same view.

  • I've checked recycle bin and all filters to make sure it wasn't hiding somewhere, still can't find it Commented Oct 10, 2019 at 17:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.