Google Spreadsheet importing CSV with arbitrary date formatting? -


I am trying to figure out which options to deal with the CSV file that are incompatible locale date formatting ? Is the DD-MMM-validated spreadsheet and CSV file set to identify MMM-dd-yyyy as valid date (through spreadsheet settings) a) Can I write a custom CSV loader in the data spreadsheet Will it fix / fix before inserting? B) Can I use a raw cell text (via API) (automatically change the 'wrong' date string) and fix it as needed? C) Any other solution? thank you in advanced!

I do not think there is a good solution to this problem

  1. You can upload a file without converting it to your Google Docs / Drive and then read it.

  2. Or you can insert, search and replace an apostrophe before each date using a regular text editor on your computer. The apostrophe prevents the content of a cell being parsed by a spreadsheet and as such (such as text) is omitted.

Comments

Post a Comment