Excel Export Test Scenarios

This functionality is very common in most of the enterprises, where the user needs to export all the records in excel,

Checkout the below mentioned scenarios, you can also tweak it according to your own needs and scenarios.

Test Scenarios For Excel Export Functionality

1. The file should get exported in the proper file extension.
2. The file name for the exported Excel file should be as per the standards, For Example, if the file name is using the timestamp, it should get replaced properly with an actual timestamp at the time of exporting the file.
3. Check for date format if exported Excel file contains the date columns.
4. Check number formatting for numeric or currency values. Formatting should be the same as shown on the page.
5. The exported file should have columns with proper column names.
6. Default page sorting should be carried in the exported file as well.
7. Excel file data should be formatted properly with header and footer text, date, page numbers, etc. values for all pages.
8. Check if the data displayed on a page and exported Excel file is the same. → in our case we are giving only export functionality for first 1000 records, check that 1000 records are present
9. Check export functionality when pagination is enabled.
10. Check if the export button is showing proper icon according to the exported file type, For Example, Excel file icon for xls files
11. Check export functionality for files with very large size.
12. Check export functionality for pages containing special characters. Check if these special characters are exported properly in the Excel file.

13. Check the count of records present in exported Excel, In my case i have seen the count is different in search and exported excel.

Leave your comments down below if there is any scenario that you would like to update.