1. Add a Dynamic Data List Display portlet to your site.
2. Click on Add List icon.
3. Create a new list.
4. Add some records.
5. Go to Configuration and check in the Spreadsheet View.
After you saved you won't see the records.
When you go back from the Spreadsheet View, you will see your records.