ABCDEFGHIJKLMNOPQ
1
Spreadsheet Import Examples
2
This document uses a few examples to help you learn how to get your spreadsheet-based test plans into Testpad.
3
Also check out the blog post for more discussion on these ideas
4
The goal is to copy/paste a single column into Testpad. And to do that, you will most likely have to invent a new column that uses a formula to aggregate the other columns.
5
The example columns in this doc all use Google Sheets formula. Everything here is possible in Excel too, but the function names are a bit different.
6
Most of these examples are modelling "test cases", complete with steps and expected outcomes. If you are starting from scratch, writing new tests, then Testpad strongly recommends you don't go for Test Cases like this, and instead just list out simple/terse/concise prompts of what you want to test; more like a guide for exploratory testing than spelling out every action in minute detail - your test plans will be faster to write, easier to maintain, and the freedom to explore and experiment around each item will uncover more bugs than the fully presecriptive route.
7
Don't hestitate to contact support@ontestpad.com if you have any questions or would like help with any of this - or go one step further and send in some sample spreadsheets (confidentiality assured) and we'll show you how best to import it.
8
Example 1
9
IF YOUR TEST PLAN LOOKS A BIT LIKE THIS...THEN YOU COULD MAKE A NEW DERIVED COLUMN LIKE THISWHICH WOULD IMPORT LIKE THIS
10
TitleTestsCOPY/PASTE THESE CELLS
11
1Normal loginNormal login
12
Valid user name and password work Valid user name and password work
13
User can login immediately after changing password User can login immediately after changing password
14
Username with unicode characters works Username with unicode characters works
15
User can login immediately after changing username User can login immediately after changing username
16
2Bad loginBad login
17
Invalid user name is rejected Invalid user name is rejected
18
Invalid password is rejected Invalid password is rejected
19
Blank password is rejected Blank password is rejected
20
Blank username is rejected Blank username is rejected
21
=IF(ISTEXT(C11),C11,CONCATENATE(" ",D11))
22
Example 2
23
IF YOUR TEST PLAN LOOKS A BIT LIKE THIS...THEN YOU COULD MAKE A NEW DERIVED COLUMN LIKE THISWHICH WOULD IMPORT LIKE THIS
24
TitleStepsExpected ResultsCOPY/PASTE THESE CELLS
25
1Normal login1. Load /login page
2. Enter valid username
3. Enter valid password
4. Press enter		Login suceeds and test user's dashboard is displayedNormal login
1. Load /login page
2. Enter valid username
3. Enter valid password
4. Press enter
Login suceeds and test user's dashboard is displayed
26
2Bad login1. Load /login page
2. Enter valid username
3. Enter invalid password
4. Press enter		Login rejected, stays on ./login page with warning saying username or password wrongBad login
1. Load /login page
2. Enter valid username
3. Enter invalid password
4. Press enter
Login rejected, stays on ./login page with warning saying username or password wrong
27
3Blank password1. Load /login page
2. Enter valid username
3. Ensure password empty
4. Press enter		Login rejected, stays on ./login page with warning saying username or password wrongBlank password
1. Load /login page
2. Enter valid username
3. Ensure password empty
4. Press enter
Login rejected, stays on ./login page with warning saying username or password wrong
28
=CONCATENATE(C10,"
",REGEXREPLACE(D10,"\n","
"),"
",E10)
29
Example 3
30
IF YOUR TEST PLAN LOOKS A BIT LIKE THIS...THEN YOU COULD MAKE A NEW COLUMN LIKE THISWHICH WOULD IMPORT LIKE THIS
31
Test IDReferenceTitlePre-conditionsStepsTest DataExpected ResultsCOPY/PASTE THESE CELLS
32
T123https://some.jira.com/browse/REQ-123Normal loginTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Enter valid password
4. Press enter		username: test1, password: pass2Login suceeds and test user's dashboard is displayedT123 Normal login
// ref: https://some.jira.com/browse/REQ-123
// assume: Test account exists with known username and password
// use: username: test1, password: pass2
1. Load /login page
2. Enter valid username
3. Enter valid password
4. Press enter
=> Login suceeds and test user's dashboard is displayed
33
T124https://some.jira.com/browse/REQ-123Bad loginTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Enter invalid password
4. Press enter		username: test1, password: wrongpassLogin rejected, stays on ./login page with warning saying username or password wrongT124 Bad login
// ref: https://some.jira.com/browse/REQ-123
// assume: Test account exists with known username and password
// use: username: test1, password: wrongpass
1. Load /login page
2. Enter valid username
3. Enter invalid password
4. Press enter
=> Login rejected, stays on ./login page with warning saying username or password wrong
34
T125https://some.jira.com/browse/REQ-123Blank passwordTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Ensure password empty
4. Press enter		username: test1Login rejected, stays on ./login page with warning saying username or password wrongT125 Blank password
// ref: https://some.jira.com/browse/REQ-123
// assume: Test account exists with known username and password
// use: username: test1
1. Load /login page
2. Enter valid username
3. Ensure password empty
4. Press enter
=> Login rejected, stays on ./login page with warning saying username or password wrong
35
=CONCATENATE(B32," ",D32,"
// ref: ",C32,"
// assume: ",E32,"
// use: ",G32,"
",REGEXREPLACE(F32,"\n","
"),"
=> ",H32)
36
37
38
Example 3b
39
IF YOUR TEST PLAN LOOKS A BIT LIKE THIS...THEN YOU COULD MAKE 3 NEW COLUMNS LIKE THISWHICH WOULD IMPORT LIKE THIS
40
Test IDReferenceTitlePre-conditionsStepsTest DataExpected ResultsCOPY/PASTE THESE CELLS
41
T123https://some.jira.com/browse/REQ123Normal loginTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Enter valid password
4. Press enter		username: test1, password: pass2Login suceeds and test user's dashboard is displayedNormal login
--1. Load /login page
--2. Enter valid username
--3. Enter valid password
--4. Press enter
=> Login suceeds and test user's dashboard is displayed		Test ID: T123

https://some.jira.com/browse/REQ123

Assumes: Test account exists with known username and password

Test data: username: test1, password: pass2
42
T124https://some.jira.com/browse/REQ123Bad loginTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Enter invalid password
4. Press enter		username: test1, password: wrongpassLogin rejected, stays on ./login page with warning saying username or password wrongBad login
--1. Load /login page
--2. Enter valid username
--3. Enter invalid password
--4. Press enter
=> Login rejected, stays on ./login page with warning saying username or password wrong		Test ID: T124

https://some.jira.com/browse/REQ123

Assumes: Test account exists with known username and password

Test data: username: test1, password: wrongpass
43
T125https://some.jira.com/browse/REQ123Blank passwordTest account exists with known username and password1. Load /login page
2. Enter valid username
3. Ensure password empty
4. Press enter		username: test1Login rejected, stays on ./login page with warning saying username or password wrongBlank password
--1. Load /login page
--2. Enter valid username
--3. Ensure password empty
--4. Press enter
=> Login rejected, stays on ./login page with warning saying username or password wrong		Test ID: T125

https://some.jira.com/browse/REQ123

Assumes: Test account exists with known username and password

Test data: username: test1
44
=CONCATENATE(D41,"
--",REGEXREPLACE(F41,"\n","
--"),"
=> ",H41)		=CONCATENATE("Test ID: ",A12,"

",B12,"

Assumes: ",D12,"

Test data: ",F12)
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100