Testpad: Importing from spreadsheets

	B	C	D	E	F	G	H	J	L	N
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 THIS	WHICH WOULD IMPORT LIKE THIS
10		Title	Tests					COPY/PASTE THESE CELLS
11	1	Normal login						Normal 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	2	Bad login						Bad 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 THIS	WHICH WOULD IMPORT LIKE THIS
24		Title	Steps		Expected Results			COPY/PASTE THESE CELLS
25	1	Normal 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			Normal 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	2	Bad 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			Bad 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	3	Blank 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			Blank 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 THIS	WHICH WOULD IMPORT LIKE THIS
31	Test ID	Reference	Title	Pre-conditions	Steps	Test Data	Expected Results	COPY/PASTE THESE CELLS
32	T123	https://some.jira.com/browse/REQ123	Normal login	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter	username: test1, password: pass2	Login suceeds and test user's dashboard is displayed	T123 Normal login // ref: https://some.jira.com/browse/REQ123 // 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	T124	https://some.jira.com/browse/REQ123	Bad login	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter	username: test1, password: wrongpass	Login rejected, stays on ./login page with warning saying username or password wrong	T124 Bad login // ref: https://some.jira.com/browse/REQ123 // 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	T125	https://some.jira.com/browse/REQ123	Blank password	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter	username: test1	Login rejected, stays on ./login page with warning saying username or password wrong	T125 Blank password // ref: https://some.jira.com/browse/REQ123 // 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 THIS		WHICH WOULD IMPORT LIKE THIS
40	Test ID	Reference	Title	Pre-conditions	Steps	Test Data	Expected Results		COPY/PASTE THESE CELLS
41	T123	https://some.jira.com/browse/REQ123	Normal login	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Enter valid password 4. Press enter	username: test1, password: pass2	Login suceeds and test user's dashboard is displayed	Normal 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	T124	https://some.jira.com/browse/REQ123	Bad login	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Enter invalid password 4. Press enter	username: test1, password: wrongpass	Login rejected, stays on ./login page with warning saying username or password wrong	Bad 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	T125	https://some.jira.com/browse/REQ123	Blank password	Test account exists with known username and password	1. Load /login page 2. Enter valid username 3. Ensure password empty 4. Press enter	username: test1	Login rejected, stays on ./login page with warning saying username or password wrong	Blank 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