Hello Syed,

Thank you for reaching out to us.

Excel, CSV, Google Spreadsheet, XML, JSON, and PHP Array-based tables are all non-server-side tables that are directly linked to the source file.

This means that they fetch all the rows, output the entire table to the front-end all at once, and then split it into pages using JavaScript; all data processing (page switching, sorting, filtering) is done on the client’s computer by JavaScript.

Since the entire table is outputted to the front-end, the entire table will be seen by the Table Export Tools and there's no way to change this behavior for non-server-side tables. Only if you import the source file, to get a manual table, then you would be able to export only the visible rows.

Hi, Syed 

Sorry for all the waiting time.

For number of rows that gets exported, while using the Table Export Tools :

-  If the table is non-server-side,  or linked to a file-source; then all rows will be exported;

- If the table has server-side processing enabled, such as Manual tables ( they always have it "forced as enabled");

or SQL Tables ( for them you can toggle Server-side processing);

then it will only export the visible rows.

- If you use any filtering on the tables > only the filtered rows will be exported.

Let us know if you have any questions Thank you