Spreadsheet data containing Google Forms Responses becomes difficult to read if there are a large number of columns. This script essentially transposes the data stored on Google Spreadsheets and stores it on a Google Doc, which is more legible.
- This installation is pretty manual since I never bothered to publish this on Google Chrome Store.
- Copy the contents of src/app.gs to your clipboard.
- Launch the Google Spreadsheet you are interested in.
- Launch Script editor from the Tools dropdown.
- Paste the script contents and save.
- Refresh the Spreadsheet and you're done!
- You'll need to authorize the script on your first usage.
- For large spreadsheets (>300 rows), please split the data across multiple sheets. The script may potentially crash if the data size is large.
- Run the script by selecting "Response to Docs".
- Enter to the file name for the doc you are saving your data to.
- Your doc is now saved under your local drive.
