Hello
I am a user who uses the app sheet well in Korea.
For normal writing operations, use the NOW() command to enter the appropriate time for the Korean time zone.
However, when I upload the CSV file, it will be registered as UTC time.
I'm curious how to type in GMT +9 instead of GMT 0.
Hi! I'm in Japan and have had to deal with various time-related issues in the past. I haven't, however, worked with CSV. Are you doing something like this?
Export CSV
https://www.appsheet.com/templates/How-to-export-data-to-csv?appGuidString=866b3f95-8d83-47a2-b015-8...
Or something like this?
Import a CSV file for this view
https://support.google.com/appsheet/answer/11510988?hl=en
Hi! I'm doing Import a CSV file.
I already changed the locale to Korea.
This is the screenshot
It's all about an hour of work
However, there is a nine-hour difference between the import CSV and write operations.
It sounds it reads the time from the server. One workaround.. add the time directly to your CSV file before it's imported.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |