How to export and download CSV file?

I am facing issues with download CSV files, can you please tell me straight forward or best approach to download csv without using Route.

I want to download using same serverconnect, and i am using paged query i want all records in csv not for particular page.