What data types does Google Sheets support?
up vote
5
down vote
favorite
I haven't been able to find an answer online for this or in the Sheets documentation. What data types does a single cell in Google Sheets support?
For example here is what I've seen so far:
Is there a list of acceptable data types that Google Sheets accepts?
types google-sheets google-sheets-api
asked Jun 13 '17 at 23:56
David542
32.5k90245450
add a comment |
up vote
5
down vote
favorite
I haven't been able to find an answer online for this or in the Sheets documentation. What data types does a single cell in Google Sheets support?
For example here is what I've seen so far:
Is there a list of acceptable data types that Google Sheets accepts?
types google-sheets google-sheets-api
asked Jun 13 '17 at 23:56
David542
32.5k90245450
add a comment |
up vote
5
down vote
favorite
up vote
5
down vote
favorite
I haven't been able to find an answer online for this or in the Sheets documentation. What data types does a single cell in Google Sheets support?
For example here is what I've seen so far:
Is there a list of acceptable data types that Google Sheets accepts?
types google-sheets google-sheets-api
asked Jun 13 '17 at 23:56
David542
32.5k90245450
I haven't been able to find an answer online for this or in the Sheets documentation. What data types does a single cell in Google Sheets support?
For example here is what I've seen so far:
Is there a list of acceptable data types that Google Sheets accepts?
types google-sheets google-sheets-api
types google-sheets google-sheets-api
asked Jun 13 '17 at 23:56
David542
32.5k90245450
asked Jun 13 '17 at 23:56
David542
32.5k90245450
edited Jun 14 '17 at 1:53
asked Jun 13 '17 at 23:56
David542
32.5k90245450
asked Jun 13 '17 at 23:56
David542
32.5k90245450
asked Jun 13 '17 at 23:56
David542
32.5k90245450
32.5k90245450
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
Like you I was unable to find a definitive list of datatypes. However, through personal experience and testing, I verified that Google sheets supports the following data types:
- Decimal (up to 15 digits, scale from +308 to -308, also used to represent integers)
- Double precision floating point numbers
- String (max length: 50,000 characters)
- Boolean (TRUE and FALSE)
- Error code (e.g. #N/A, #DIV/0!, and #REF!)
Note: Dates, Times, and Datetimes are stored as Decimals.
Arrays can also be used in Google Sheets. Arrays behave similar to the way they do in Excel, but Sheets does not restrict the user from editing cells in an array the way that Excel does.
answered Jun 14 '17 at 2:01
Austin D
4,61711930
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
add a comment |
up vote
1
down vote
A good corollary is that the Date, Time and Datetime are represented, and can be processed as, numbers (I don't know whether Decimal or FP). In this case the date is represented as the integer part, as number of days since Dec 31, 1899, and time as the fractional.
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
Like you I was unable to find a definitive list of datatypes. However, through personal experience and testing, I verified that Google sheets supports the following data types:
- Decimal (up to 15 digits, scale from +308 to -308, also used to represent integers)
- Double precision floating point numbers
- String (max length: 50,000 characters)
- Boolean (TRUE and FALSE)
- Error code (e.g. #N/A, #DIV/0!, and #REF!)
Note: Dates, Times, and Datetimes are stored as Decimals.
Arrays can also be used in Google Sheets. Arrays behave similar to the way they do in Excel, but Sheets does not restrict the user from editing cells in an array the way that Excel does.
answered Jun 14 '17 at 2:01
Austin D
4,61711930
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
add a comment |
up vote
2
down vote
accepted
Like you I was unable to find a definitive list of datatypes. However, through personal experience and testing, I verified that Google sheets supports the following data types:
- Decimal (up to 15 digits, scale from +308 to -308, also used to represent integers)
- Double precision floating point numbers
- String (max length: 50,000 characters)
- Boolean (TRUE and FALSE)
- Error code (e.g. #N/A, #DIV/0!, and #REF!)
Note: Dates, Times, and Datetimes are stored as Decimals.
Arrays can also be used in Google Sheets. Arrays behave similar to the way they do in Excel, but Sheets does not restrict the user from editing cells in an array the way that Excel does.
answered Jun 14 '17 at 2:01
Austin D
4,61711930
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
Like you I was unable to find a definitive list of datatypes. However, through personal experience and testing, I verified that Google sheets supports the following data types:
- Decimal (up to 15 digits, scale from +308 to -308, also used to represent integers)
- Double precision floating point numbers
- String (max length: 50,000 characters)
- Boolean (TRUE and FALSE)
- Error code (e.g. #N/A, #DIV/0!, and #REF!)
Note: Dates, Times, and Datetimes are stored as Decimals.
Arrays can also be used in Google Sheets. Arrays behave similar to the way they do in Excel, but Sheets does not restrict the user from editing cells in an array the way that Excel does.
answered Jun 14 '17 at 2:01
Austin D
4,61711930
Like you I was unable to find a definitive list of datatypes. However, through personal experience and testing, I verified that Google sheets supports the following data types:
- Decimal (up to 15 digits, scale from +308 to -308, also used to represent integers)
- Double precision floating point numbers
- String (max length: 50,000 characters)
- Boolean (TRUE and FALSE)
- Error code (e.g. #N/A, #DIV/0!, and #REF!)
Note: Dates, Times, and Datetimes are stored as Decimals.
Arrays can also be used in Google Sheets. Arrays behave similar to the way they do in Excel, but Sheets does not restrict the user from editing cells in an array the way that Excel does.
answered Jun 14 '17 at 2:01
Austin D
4,61711930
edited Jun 14 '17 at 2:15
answered Jun 14 '17 at 2:01
Austin D
4,61711930
answered Jun 14 '17 at 2:01
Austin D
4,61711930
answered Jun 14 '17 at 2:01
Austin D
4,61711930
4,61711930
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
add a comment |
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
thanks for this. When does Sheets use a Decimal and when does it use Double? Also, could you please show an example of how to enter in an array?
– David542
Jun 14 '17 at 2:24
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
Sheets seems to have a preference hierarchy of types, preferring Decimal > Double > String. I'll update my answer tomorrow, but for the moment see the following link for an example of an array in Sheets: support.google.com/docs/answer/3094292?hl=en
– Austin D
Jun 14 '17 at 3:05
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
@David542 - to enter an array you need to enter a formula, e.g. ={1, 2, 3}
– ttarchala
Jun 14 '17 at 7:10
add a comment |
up vote
1
down vote
A good corollary is that the Date, Time and Datetime are represented, and can be processed as, numbers (I don't know whether Decimal or FP). In this case the date is represented as the integer part, as number of days since Dec 31, 1899, and time as the fractional.
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
add a comment |
up vote
1
down vote
A good corollary is that the Date, Time and Datetime are represented, and can be processed as, numbers (I don't know whether Decimal or FP). In this case the date is represented as the integer part, as number of days since Dec 31, 1899, and time as the fractional.
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
add a comment |
up vote
1
down vote
up vote
1
down vote
A good corollary is that the Date, Time and Datetime are represented, and can be processed as, numbers (I don't know whether Decimal or FP). In this case the date is represented as the integer part, as number of days since Dec 31, 1899, and time as the fractional.
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
A good corollary is that the Date, Time and Datetime are represented, and can be processed as, numbers (I don't know whether Decimal or FP). In this case the date is represented as the integer part, as number of days since Dec 31, 1899, and time as the fractional.
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
answered Jun 14 '17 at 7:13
ttarchala
2,0731929
2,0731929
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f44533300%2fwhat-data-types-does-google-sheets-support%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
