PlainTextCSV_GoogleAppsScript

KO | EN

gitlite — search

#javascript #react #typescript #llm #android #machine-learning #nodejs #awesome #cli #vue #pytorch #security #mcp #open-source

PlainTextCSV_GoogleAppsScript

(★ 10)

Create a Google Sheet from a CSV file preventing auto-formatting of date and number fields

PlainTextCSV_GoogleAppsScript Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# PlainTextCSV_GoogleAppsScript
Create a Google Sheet from a CSV file preventing auto-formatting of date and number fields

By default, both Excel and Google Sheets auto-format date and numeric fields on import.  This can introduce errors in systems that expect these values to be retained as strings.

For example
`2016-04` is converted to a date `04/01/2016`

## Sample Screenshots
https://github.com/terrywbrady/PlainTextCSV_GoogleAppsScript/releases/tag/v1.0.0

## Installation
* Open Google Drive
* Create a new "Google Apps Script" and name it "CSV Upload"
* Load the 3 code files in this repository
* Click the "Deploy as Web App" button (cloud with an arrow in it)
* Execute the app as: User Running the Script
* Who has access: Choose the appropriate audience
* Save the URL to the deployed application (be sure the URL ends with /exec and not /dev)
* Share the URL with your users
* Users will need to authorize the application to write to Google Drive before running the application

## StackOverflow Thread
http://stackoverflow.com/questions/36605298/create-a-google-sheet-with-plain-text-cells-to-prevent-auto-format-of-strings

PlainTextCSV_GoogleAppsScript

PlainTextCSV_GoogleAppsScript Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

PlainTextCSV_GoogleAppsScript

PlainTextCSV_GoogleAppsScript Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README