To export your data to spreadsheets, first enable the edit mode from the top right side of your app.
Now, follow these steps:
Enable Edit mode to start exporting your table.
Click on the Options tab located on the right-hand side of the menu.
Scroll down and select Import & Export
Click on Full Export this base's data to download the data as an Excel file.
With this export option, you can download responses, whether it’s the full data set or a customized view.
If you want to export the latest data and new responses, click on "Download latest export" link: