This blog post might help you https://www.mendix.com/blog/limits-and-offsets/ . it is about using limit and offset in your retrieve :)
Thanks 😊 …turns out I just needed to use Export to CSV rather than Export to Excel