Test Cases For Excel Import Functionality - Test Scenarios for Bulk Upload

Test Cases For Import Functionality

Test Cases for Upload Data From Excel Sheet

How to Upload Bulk Data From Excel Sheets?

Here!!! Important Test Cases for import functionality are given...

First Download the excel Format (Download the sample excel sheet to upload bulk data)
Now verify whether the column names are as per requirement or not.
Verify the excel sheet name as per requirement or not.
Verify that when excel sheet is password protected.
Check that user is able to type for all columns or not.
Verify that when the user enters valid data in all the fields and tries to upload the excel sheet.
Check that data are properly showing in all the field (on the webpage) or not.
Check that when the user edits the data uploaded from the excel sheet are properly bound or display or not (text boxes, Dropdowns, Checkboxes, etc).
Check that when the user enters data only in the mandatory column and uploads excel.
Check that when the user enters data only in the non-mandatory field and tries to upload excel.
Verify that the alert message showing or not when the user enters data only in the non-mandatory field and tried to upload excel
Verify whether the alert message showing as per requirement or not.
Check that when the user entered data for one user and uploads.
Check that when the user entered data in mass and uploads the excel sheet.
Check that when trying to upload an excel sheet without entering any data.
Check that when the user tried to upload the excel sheet by changing the file name.
Check that when the user tried to upload the excel sheet by changing the file name with a special character.
Check that when the user tried to upload an excel sheet by entering the invalid data in all columns.
Verify that when users do not select any value from the dropdown column and try to upload.
Check that when the user entered the numeric value in the column that accepts only the alphabet through the webpage.
Check that when copying values and pasting in an excel sheet and trying to upload.
Check the combination-paste value in one field and manually enter the other and tried to upload.
Check that if preview options are working or not(if applicable)
Check that the cont showing or not.
Check if the row has any wrong value or user entered any wrong value when the user uploads showing in red color or not. (If applicable) .
Verify whether the confirmation message showing or not when a user successfully uploads the bulk data from the excel sheet.
Check that the confirmation message is as per the requirement met or not.
Verify the control when the user successfully uploads the data.
Check whether the data uploaded from the excel sheet shows on grids or not.
Verify the alert message when the user entered any wrong value in any column and user tried to upload.
Verify that the user is able to understand the mistake in the excel sheet by getting an alert.
Verify when the user selects an invalid extension file.
Verify the Size limit of the excel sheet.
Check whether the alert message showing or not when the user selects an invalid extension file.
Check whether the alert message showing or not when the user selects a file more than the defined size.