Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question; this will greatly increase the chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
7 votes
2 answers
23k views

What's the biggest .csv file you can import into a Google Sheets?

I'm trying to upload/import a 7 MB .csv file to Google Sheets without much luck. What's the largest file size that you can import?
user avatar
  • 2,091
36 votes
11 answers
52k views

How to calculate weighted averages in Google Sheets?

I have a Google Sheets where products are listed as rows and attributes as columns. Each product's attribute is rated on a scale of 1-10. My last column is an average of these values (i.e. =Average(B2:...
user avatar
  • 30k
66 votes
12 answers
90k views

How to pass a range into a custom function in Google Spreadsheets?

I want to create a function which takes in a range... something like: function myFunction(range) { var firstColumn = range.getColumn(); // loop over the range } A cell would reference it using: ...
user avatar
  • 30k
8 votes
2 answers
70k views

Is it possible to use a loop in Google Spreadsheets?

I have the following document: +---+-----------+ | | A | +---+-----------+ | 1 | Foo (100) | | 2 | Bar (30) | | 3 | Baz (50) | +---+-----------+ I'd like to use a REGEXEXTRACT to extract ...
user avatar
  • 30k
2 votes
1 answer
1k views

How to plot time series graph with categories?

I've data in Google Spreadsheets, with columns as follows: DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2 For example: 22.12.2010 APPLES 1 20 23.12.2010 APPLES 100 20 23.12.2010 ORANGES 32 12 I need ...
user avatar
13 votes
3 answers
21k views

How to label points in a scatter plot?

I've tried using the built-in scatter plot chart and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
user avatar
20 votes
3 answers
99k views

How do I lookup a value from another sheet in Google Docs?

I have a page which looks like this: ╔═══╦════════╦══════╦═══╗ ║ A ║ B ║ C ║ D ║ ╠═══╬════════╬══════╬═══╣ ║ 1 ║ User A ║ 144 ║ ║ ║ 2 ║ User B ║ 5478 ║ ║ ║ 3 ║ User A ║ 2156 ║ ║ ╚═══╩══...
user avatar
  • 30k
6 votes
2 answers
8k views

How do I add a hyperlink to a cell in Google Spreadsheets?

In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet? I don't see any corresponding toolbar button or ...
user avatar
  • 30k
3 votes
3 answers
2k views

How exactly does sharing work in Google Drive?

I have an Excel spreadsheet I made to track my own scores for an Xbox game I play (TrialsHD, if you are curious). I've made it available to other players so they can track their own scores, but it ...
user avatar
  • 273
9 votes
1 answer
9k views

Cross-reference sheets on Google Spreadsheets

I can just do B12 to reference a field on the same sheet I'm working on, but how do I reference B12 on another sheet?
user avatar
  • 193
3 votes
1 answer
3k views

How to extract information from the subject line and add to Google Sheets?

I'd like to be able to extract tasks from the subject line of an email in Gmail (using some sort of custom syntax) and then insert the task as a row in a shared Google Sheets. Currently the best way ...
user avatar
  • 133
82 votes
6 answers
200k views

How to add days to a date

I'm using a Google Spreadsheet to perform calculations and I'd like to do some simple date math. For example, TODAY() add 7 days. I don't see any functions to do it and some quick stabs in the ...
user avatar
68 votes
6 answers
242k views

Formatting a cell with word wrap without switching modes?

How can one format a cell to have word wrap in Google Sheets? I've tried Shift+Enter, but that doesn't seem to work. One thing I know works is to place the spreadsheet into List Mode and then if you ...
user avatar
  • 2,091
2 votes
1 answer
4k views

In Google Sheets in List View, can you add rows to the bottom instead of the top? [closed]

I've been using Google Sheets in List View (View->List View on the menu bar) as I have a fixed number of columns in my spreadsheet. I'd like to add new rows to the end of the List instead of at the ...
user avatar
  • 2,091
-1 votes
1 answer
819 views

Writing a spreadsheet script

The above link is a picture of the Google Docs spreadsheet that I am working on. Basically it is a sale ticket for a small appliance parts store. I need to be able to select a range of rows and have ...
user avatar
  • 7
4 votes
1 answer
4k views

Pass Data to Form to Store in Google Spreadsheet

I am collecting addresses in a Google Spreadsheet using a web form. But I am collecting those addresses for multiple purposes. I would like to store an "identifier" in the spreadsheet which I can pass ...
user avatar
5 votes
2 answers
13k views

Password protect a Google Sheets

Is there a way to secure a Google Sheets?
user avatar
  • 386
9 votes
8 answers
43k views

How to lock/protect cells in Google Spreadsheets

I created very simple spreadsheet application in Google Spreadsheet for my mom. But I really need to lock/protect the cell with formulas so she cannot edit them. Every time I told her to try new ...
user avatar
  • 949
22 votes
2 answers
31k views

How do I specify "everything except the top row" as a range?

I have Sheet1, which is automatically being updated via form entries. I'm making Sheet2, which is a self-sorting version of Sheet1 (it intended to be a copy of Sheet1 but sorted by a column). Ideally ...
user avatar
  • 329
1 vote
1 answer
112 views

How to dash a whole row if a cell is OK?

I have a cell that can be OK, ERROR or WARNING. When it is changed to OK I want to modify the whole row in some way. I was thinking about to dash all cells. Is it possible? Or is there something I ...
user avatar
  • 111
2 votes
3 answers
4k views

How can I chart based on day and month using dates in Google Sheets?

I have a Google spreadsheet that has values like: 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
user avatar
9 votes
2 answers
55k views

Inserting a New Sheet in a Google Spreadsheet

How can I insert a new blank sheet (a new tab) into an existing Google Spreadsheet? I'm able to duplicate those that already exist on the bottom, but I can't find the menu option to insert a sheet. ...
user avatar
3 votes
2 answers
278 views

What would I use to write a formula only once and have it work on multiple sheets?

I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within ...
user avatar
-1 votes
1 answer
2k views

Embedding an Excel-like spreadsheet with formula calculations? [closed]

I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say three cells with the input of a number) where then a fourth cell will calculate the sum of the square of the three ...
user avatar
  • 1,390
2 votes
1 answer
2k views

How can I make tabs show in Google Spreadsheets?

I copy code from an editor into a Google Spreadsheets cell. Unfortunately, it left-aligns the code making it hard to read. However, when I double-click on it to edit it, the tabs are still there (...
user avatar
85 votes
10 answers
320k views

How can I make some data on a Google Sheets auto-sorting?

Let's say I want Google Sheets to automagically sort some data, for example column C. How do I do that? I know that I can manually sort data by right-clicking and selecting Sort data, but this is ...
user avatar
3 votes
2 answers
8k views

Laying out dates in Google Sheets charts

I have a Google Sheets with measurements made at different dates. The data looks like this: 2010-09-01 80 2010-09-02 79 2010-09-10 81 I want the points that make up the data to be laid out so that ...
user avatar
  • 1,394
12 votes
5 answers
6k views

How to do a simple set operation in Google docs spreadsheet?

Suppose I have some names in cells B1:B3, and a full list of all the names in A1:A4, is it possible for me to generate a list of names in A1:A4 that don't appear in B1:B3? E.g. Cells A1:A4 have "A", "...
user avatar
  • 638
3 votes
3 answers
22k views

Why don't Google Sheets graphs lay out my points correcty?

When I try to make a simple graph of some points in a Google Sheets said points do not end up where I want them to in the graph. Using data like this I expect a straight line in my graph: col A col ...
user avatar
  • 1,394
36 votes
14 answers
127k views

Can I change cell padding in Google Spreadsheets?

I don't want to stretch all rows and columns to make them more readable than they are by default...
user avatar
  • 759
4 votes
2 answers
4k views

Google Spreadsheet: Use cell referencing in "Change Color Based on Rules"

In "Change Color Based on Rules", one can specify the text color to be any color as long as certain rules are followed: My question is, instead of hard-coding the values, can I use cell reference? In ...
user avatar
  • 1,375
76 votes
17 answers
112k views

In a Google Spreadsheet, how can I force a row to be a certain height?

In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell. I have tried "resize row" but no matter how many pixels I put in, the row expands ...
user avatar
2 votes
3 answers
2k views

How to embed a Google Spreadsheet inside a post in my blog?

I have a public Google Spreadsheet in Google Drive and want to display it within my blog post (people can directly see it, not only a link to the sheet). How can I do that? Please help! I'm using ...
user avatar
  • 3,426
115 votes
2 answers
234k views

How to convert rows into columns in Google Spreadsheets?

I have a spreadsheet in Google Docs with two data rows and lots of columns like so: Is it possible to easily convert these rows into two columns and lots of rows (obviously retaining all information ...
user avatar
  • 3,698
10 votes
6 answers
29k views

What are the refresh characteristics of the Google Spreadsheet Import functions?

The imported data is not always up to date with the source pages when I load the spreadsheet. When this happens, F5 refresh does not help. Nor does Ctl-F5. Apparently there is some kind of caching ...
user avatar
  • 219
4 votes
1 answer
10k views

Figuring out who is the owner of a Google Spreadsheets form

I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
user avatar
  • 30k
2 votes
2 answers
2k views

Graphs with Google Spreadsheets - collapse data into one 'category'

I have a set of data which is similar to the following: Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00 I'd like to be able to use this data to create ...
user avatar
  • 297
8 votes
4 answers
13k views

Creating an online form - by Importing the questions from a spreadsheet? [closed]

I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question. I want to turn these questions into an online form (like ...
user avatar
  • 1,390
3 votes
3 answers
3k views

Calculated range based upon some criteria

Given this layout: +--------+ +--------+ | A | B | | A | B | +----+---+ +----+---+ | 1 | | | 1 | 6 | | 2 | | | 2 | | | 3 | | => | 3 | | | | | ...
user avatar
  • 5,290
19 votes
7 answers
81k views

Google Docs Time report - How to add hours?

I use a Google Docs spreadsheet to keep track of the time I spend on projects. It's formatted in 3 columns: the time I started, the time I finished, and the total hours spent for that session (...
user avatar
  • 293
20 votes
2 answers
26k views

How can I change the input format for dates in Google Docs' spreadsheet?

The input string for dates in Google Docs's spreadsheet app seems to be set to en_US, which is quite unnatural to me. How can I change the input format?
user avatar
4 votes
1 answer
7k views

Google Spreadsheets Enter/Return Key Behavior

In Microsoft Excel, the default behavior of pressing the Enter (return) key is this: If you are in a cell, and tab over as you input data, at the end of the series when you click Enter, the ...
user avatar
  • 150
5 votes
2 answers
12k views

Plot Multiple Graph in Google Spreadsheet

I know how to plot a graph in google spreadsheet. But how to plot multiple graphs, with different X and Y values in Google Spreadsheet?
user avatar
  • 1,375
7 votes
6 answers
34k views

Is there a way to link emails from Google Sheets?

I'm trying to find a way to link to an email from my Google Sheets. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works best). It ...
user avatar
6 votes
6 answers
25k views

How do I make a field display a calendar for picking a date

Previously, in Google Spreadsheet, I've seen date fields that, when clicked on, display a calender for selecting a date. How can I reproduce this?
user avatar
  • 303
41 votes
11 answers
156k views

Is there any way to create a timestamp in a Google Spreadsheet?

I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.: 2010-07-17 23:45:44 Is there a way to do this in a Google Spreadsheet?
user avatar
4 votes
1 answer
2k views

Google Docs brings Firefox to a grinding halt

I've found recently that when I open a not-too-large* spreadsheet in Google Docs, within about 5 minutes of leaving it in a background tab, Firefox starts hogging 100% processor time. Closing the main ...
user avatar
  • 171
83 votes
5 answers
94k views

Embed Google Spreadsheet in Google Document

Is it possible to embed a Google Spreadsheet into a Google Document à la Microsoft Excel and Microsoft Word? How about a chart from a Spreadsheet?
user avatar
  • 51.2k
4 votes
2 answers
2k views

No force-reload tip on Google Sheets?

So I'm running nightly tasks to generate some custom statistics for my site and copy the statistics in .csv format to separate server via SCP. Then I use these .csv files in Google Sheets to display ...
user avatar
  • 243
1 vote
1 answer
11k views

Take SUM of colored cells in a column in Google Spreadsheets?

I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background. Is it possible to create a ...
user avatar
  • 159