Google Spreadsheet is a web-based application that was introduced by Google in the Year 2006. Google acquired the software from 2Web Technologies which had originally created the idea of online-based spreadsheets. Google spreadsheet is available in all the browser platforms and as a mobile-based application too.
Google Spreadsheet is a boon to every QA who likes to maintain proper documentation while testing. Earlier I used to use excel sheet for all QA tasks, but I realized that google spreadsheet is much better when you need to share it to different QA's who are required to edit the sheet. It saves time as multiple users can edit the file in the same session. I just have 2 and half years of experience but I am going to make sure I clearly explain each formula with different examples in the coming posts. I would also explain how with simple Javascript knowledge, you can be a better google app-script QA.
Google Spreadsheet is a boon to every QA who likes to maintain proper documentation while testing. Earlier I used to use excel sheet for all QA tasks, but I realized that google spreadsheet is much better when you need to share it to different QA's who are required to edit the sheet. It saves time as multiple users can edit the file in the same session. I just have 2 and half years of experience but I am going to make sure I clearly explain each formula with different examples in the coming posts. I would also explain how with simple Javascript knowledge, you can be a better google app-script QA.
Understanding how to access Google Spreadsheets is also necessary if you have never used google spreadsheets. Below are the steps to create a new google spreadsheet.
1. If you have a Gmail account then you can access the google drive by clicking on the link below
If you do not have a Gmail account then you need to create one to access it.
2. Click on the New button.
3. Click on Google Sheets
4. Voilà! You have successfully created a new google spreadsheet. Congratulations :)
5. You can name your Spreadsheet by clicking on Untitled spreadsheet
6. Type any name as you wish, I have named my spreadsheet as Teaching Google Spreadsheet
Fun Fact: You can add 9500 characters to the name field. But, I have crashed the browser by continuously adding around 2 Lakh characters :D