Do NOT share spreadsheets/images as the only source of data. Use markdown TEXT tables instead. Use this tag for Google Sheets questions that involve the use of spreadsheet formulas. Use together with tags such as [google-sheets] for broader visibility, [array-formulas], [google-query-language] or [custom-functions]+[google-apps-script] when the formula includes a custom function written in [google-apps-script]. Avoid use with [excel] and [excel-formulas].
Resources:
Sharing your data:
Sharing your data helps other community members in visualizing your data. This can be done through
- Tables(Mandatory):
Markdown help can be found here. You can easily create a table using the formula:=ARRAYFORMULA("|"&A1:G20), if you want to shareA1:G20. However, the first rowA1:G1must be a header row AND the second rowA2:G2should only contain dashes--in all the cells.
CSV:
Use File > Export to csvPublished Google sheets(in addition to text table):
In the sheets file, click File > Share > Publish to web.Share to others(in addition to text table):
In the sheets file, click File > Share to others > Anyone with link. Note, however that sharing Google sheets this way makes your email address visible to public.Screenshots(in addition to text table):
This shows your data structure but makes it hard for anyone to copy data from the question for testing
If questions depends on external links/images, they will be closed. Text tables is mandatory.
Related tags
- google-sheets - Product main tag
- array-formulas - for array formulas
- google-query-language - for questions about Google sheets query
- custom-functions+google-apps-script - for custom functions
