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 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? – marikamitsos Jan 31 at 18:16
  • 2
    Does this not belong on the meta site? – ahorn Mar 11 at 6:52

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
| improve this answer | |
  • 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 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. – marikamitsos Mar 21 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 at 19:48
  • @Tedinoz (Sorry for the late reply.) I believe the answer says it all. In any case, using the word "ethical" (which includes and mainly used about morality issues) is completely out of context (see moral vs ethical or ethical vs unethical). So the question posed is the best example itself. Meaning, instead of trying to explain in chat or endless comments going back and forth what the -usually- newcomer wants, one asks for a "demo sheet" which has nothing to do with ethics. – marikamitsos Apr 8 at 17:28
  • Clearly we have to agree to disagree on this score. – Tedinoz Apr 8 at 22:51

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.