#ExcelTools #ExportportalReporttoExcel

Question

Hi, I am usign Export Portal Report To Excel, but only export 1000 registers and my Report contains 9k registers. Someone, can i help me?? 
 
 Regards

Colton Beck · Answer

There&#x27;s likely a 1000 row limit in place on this smart service. Try batching and looping an a!queryProcessAnalytics() call to pull this data into process. Once all the data is present, pass it into an Export to Excel smart service contained in the Excel Tools plugin. This should get you what you need. 
 
Please keep in mind that it&#x27;s not a good idea to pull thousands of rows into process, as this can have performance implications.