Single Quote Prefix in Google Spreadsheet
When adding/updating cells in Google Spreadsheet, a single quote (
') was prefixed to the value.
This can be fixed by changing the
USER_ENTERED. There’re two options:
RAW: The values the user has entered will not be parsed and will be stored as-is.
USER_ENTERED: The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc.
If you’re using https://github.com/burnash/gspread, change the
Was this page helpful?