Checklist for Data Entry with Google Sheets

So you have decided to create a format in a Google Sheets file and have people fill data by collaborating in the same file.

Follow this checklist to make sure you have covered all bases!

1. Have you made sure that Google Sheets is the most suitable tool for the job? Are you sure that this data cannot be entered using a Google Form?

2. Have you ensured that the format you have created is suitable for the data that you want to collect? Are you sure that you are collecting a reasonable amount of data?
   2.1 Have you asked someone who is not associated with this project to take a look at the data entry format? Did they understand how to enter the data on their own without your help?
   2.2 Are you 110% sure that your format is easy to understand?

3. Have you checked that the necessary data validation rules are in place? Are you sure that only the expected data will be input by the respondents?

4. Do you have a list of all the people with whom you will share this Google Sheets file? Are you sure that they will know how to fill the format?
   4.1 Have you added protection to sheets/ranges to prevent unwanted edits?
   4.2 Have you set a deadline for the data entry process? Has this date been communicated with the respondents?

5. Have you decided if you are going to conduct a pilot test of the questionnaire? Is there a good reason for that decision?

6. Is there a plan in place for how the collected data will be analysed and reported?