Unable to export all items from list on sharepoint online

New Contributor

Hello everyone,


here is my case:


I am tracking leave request of employee using list on sharepoint online. I need to export to excel all items created in this list. But when i click "export to excel" and save result as query.jpy, run it, it only shows 1 item, not all off items in that list. But it shows all items when i click export to csv. Please show me how to fix it? These are pics:


all items:


export to excel query.jpy:



export to csv:



Thank you so much.

0 Replies