I find a lot of -especially new- users on the site are having difficulties on sharing a demo sheet so they can be easily helped if any at all.

So, what is the right way to share a demo test sheet?

  • 1
    I like this a lot! It was very helpful with modifying my question. The only quibble I have is that this question's title may be taken to mean "How to share it with other people in general" instead of "how to share a sheet to help people answer a question more quickly/fully on WebApps."
    – aschultz
    Jan 31 '20 at 18:10
  • @aschultz Well... Hmmm. I believe it will help other people as well. We are not the only site helping out. And anyway I wanted it to be brief and easy to remember. Any other suggestions? Jan 31 '20 at 18:16

The correct way to publicly share a Google test sheet

Please follow the steps:

  • Prepare your sheet.

    Before sharing your sheet make sure you fill in all the information needed. That is:

    • Include only but all necessary demo data excluding any sensitive data.
    • Not too little, not too much. Do not overload the sheet. No need to have 500 rows and 50 columns. As well as not just 2 rows and 1 column. Just as much as needed.
    • Place in the spreadsheet -as well as in the question- the essential information for others to fully understand your issue.
    • Give an example of your expected results.
    • Include your efforts thus far. (It shows good will and determination)
  • Share your spreadsheet

Correct way to publicly share a Google test sheet

  • Let us know.

    After you shared your sheet, do let us know.
    • Check your answer for possible mistakes and add additional clarifications if any needed.
    • Edit/Update your answer including the copied link to the spreadsheet.
    • Alert the person who asked for it by leaving a comment for them under your question (@name some text).
    • Do NOT just add the link in the comment
  • 1
    By sharing a spreadsheet, a questioner is also publicly exposing their email address. I suggest that you add a warning to your answer along the lines that "You should be aware that sharing your spreadsheet will unavoidably expose your email address.""
    – Tedinoz
    Mar 17 '20 at 13:26
  • @Tedinoz (Please correct me if I am wrong.) I believe your observation is incorrect. What is shown is the name one chose to be publicly shown under one's Google account. Most certainly neither one's email nor one's real name. Mar 21 '20 at 4:06
  • 1
    I do understand your comment, and it was certainly news to me when it was brought to my attention. This post on StackOverflow Meta has the instructions- the one's regarding using the api. Let me know how you get on.
    – Tedinoz
    Mar 22 '20 at 19:48
  • 1
    The problem with sharing it editable is that anyone can trash the sheet. Surely it's better just to share it read-only and let people make their own copies to work on?
    – PhilHibbs
    Apr 16 at 20:48
  • 1
    @marikamitsos I didn't mean "deleted", I meant trashed in the sense of "wrecked, destroyed, made useless".
    – PhilHibbs
    Apr 18 at 10:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.