Python Connector for Google Sheets

Data types - Python Connector for Google Sheets

Data types

The following table describes the supported Google Sheets data types and their mapping to the Python data types. The type codes returned in the description cursor attribute can be used in the addtypecast() cursor method.

Google Sheets data type Type code Python data type

Integer Number

3013

int

Decimal Number

3008

float

Checkbox

3004

bool

Text

3017

str

Date and time

3007

datetime.datetime

© 2022-2026 Devart. All Rights Reserved. Request Support Python Connectors Forum Provide Feedback