If you want to load 500 rows at once in the spreadsheet, then you need to go to advanced settings, and then go to speed and performance.
Note, this depends on your server capacity. Some servers will not be able to handle 500 rows at once and our plugin will automatically revert to 10 rows per batch if we detect that your server is overloaded.
Enter 500 in the “Load rows faster: Number of rows to load per batch”
