Test Cases For Excel Import Functionality - Bulk Upload Test Cases

.

 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.

Hope !!! The above Test cases for import functionality are helpful for you...

Team,

QA acharya

Tags: Test cases for import, Excel upload test cases, Bulk upload test cases, Excel upload Test cases, 

Test Cases For Bulk upload Functionality 

.