So there is a way to do this... it's just a little 'hidden' that's all.
You will see that on the screenshot, there is 5812
items in the list, spread over 122 pages
, with 48 items
Simply click in the PAGE SIZE box and change the number to just a little over the TOTAL ITEMS (5900 in my case) and press ENTER.
This will refresh the list to show on ALL on 1 page
and then you can FILTER/Export ALL to Excel/do anything else you want to the data!
Hope this helps!