title: Google Spreadsheet importing CSV with arbitrary date formatting?
body: <p>I'm trying to figure out what are the options for dealing with CSV file which has inconsistent locale dates formatting? The spreadsheet set to recognize MMM-dd-yyyy as a valid date (via spreadsheet settings) and CSV file has dd-MMM-yyyy. a) Can I write a custom CSV loader which will process/fix the data before putting it into a spreadsheet? b) Can I access (via API) a raw cell text (avoiding automatically converted 'wrong' date string) and fix it as necessary? c) any other solution? Thanks in advance!</p>