Dear Branon,
You can use Power Query (About Power Query in Excel - Microsoft Support). You can directly import you collected Kobo surveys into an Excel workbook and create your Pivot table, later you can click the update button and all your new survey will import to excel workbook and your tables will update. If you have any question, please let me know
