Test Cases For Excel Import Functionality

.

Import Functionality Test Cases

Hello Folks, 

In this tutorial, we will learn how to write import functionality Test Cases. We will also learn about positive test scenarios and Negative test scenarios.

What Are the Test Cases For Import Functionality? 

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 the requirement or not.

• Verify the Excel sheet name as required.

• Verify that the Excel sheet is password-protected.

• Check whether the user is able to type in all columns or not.

• Verify that when the user enters valid data in all the fields, they try to upload the Excel sheet.

• Check that the data is properly showing in all the fields (on the webpage) or not.

• Check that when the user edits the data uploaded from the Excel sheet is properly bound or displayed or not (text boxes, Dropdowns, Checkboxes, etc).

• Check that when the user enters data only in the mandatory column and uploads an Excel file. 

• Check that when the user enters data only in the non-mandatory field and tries to upload an Excel file. 

• Verify that the alert message shows or does not show when the user enters data only in the non-mandatory field and tries to upload Excel file

• Verify whether the alert message is showing as per the requirement or not. 

• Check that when the user enters data for one user and uploads.

• Check that when the user enters data in bulk and uploads the Excel sheet. 

• Check that when trying to upload an Excel sheet, without entering any data. 

• Check that when the user tries to upload the Excel sheet by changing the file name is changed. 

• Check that when the user tries to upload the Excel sheet by changing the file name includes a special character. 

• Check that when the user tried to upload an Excel sheet, by entered 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 enters a numeric value in a column that accepts only the alphabet, through the webpage. 

• Check that when copying values and pasting them into an Excel sheet, and trying to upload. 

• Check the combination-paste value in one field, manually enter the other and try to upload. 

• Check if the preview options are working or not(if applicable) 

• Check whether the count is showing or not. 

• Check if the row has any wrong value or user entered any wrong value when the user uploads, showing in red colour or not. (If applicable) . 

• Verify whether the confirmation message is showing or not when a user successfully uploads the bulk data from the Excel sheet. 

• Check that the confirmation message is as per the requirements met or not. 

• Verify the control when the user successfully uploads the data. 

• Check whether the data uploaded from the Excel sheet shows on the grids or not. 

• Verify the alert message when the user enters any wrong value in any column, and the user tries 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 is showing or not when the user selects an invalid extension file.

• Check whether the alert message is showing or not when the user selects a file larger than the defined size.

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

Team,

QA acharya

Share Your Knowledge With Us -
Mail your content to qaacharya.in@gmail.com

Test Cases For Bulk Upload Functionality