Data Cleaning Best Practices in Sheets

Part of a series on preparing Google Forms survey data for analysis in Jamovi. This video provides an overview of best practices for data cleaning in Google Sheets, including why creating new columns with formulas is preferable to find and replace, demonstrated with an example of converting text responses into binary values to make transformations easier to verify and error-check. When you are done cleaning your data, download your Google Sheet to a .CSV by going to File -- Download -- Comma Separated Values (.csv). DO NOT USE EXCEL. Then open your .CSV file in jamovi: https://youtu.be/putvHX5HGmw. You will create total scores in jamovi, unless you are categorizing data with subscale means and IF statements. Other Videos in this Playlist: Linking Google Forms to Sheets: https://youtu.be/Z4AXfXrjW44 Naming Variables in Sheets (for uploading to Jamovi): https://youtu.be/sb6SMcsq7wI Transforming Informed Consent & Eligibility Variables in Sheets: https://youtu.be/_LxyUR9Qbik Cleaning “Other” Gender Responses in Sheets: https://youtu.be/QWMya7Rdq14 Coding Ordinal Variables in Sheets Using Nested IF Statements: https://youtu.be/uvZhwPHCfoI Scoring Likert-Type Text Responses in Sheets: https://youtu.be/83uZzuG15lo Reverse Scoring Likert-Type Numeric Responses in Sheets: https://youtu.be/ulZjUuJbn_o Calculating Subscale Means in Sheets with IF Statements: https://youtu.be/DeXATQM0P0Y Categorizing Data with Subscale Means and IF Statements: https://youtu.be/3wXHMArX0Ck