I uploaded 31 2-column .tsv files. Each line of the file had one TAB character and one NEWLINE character.
27 of them imported correctly. 4 imported as if they were .csv files, the TAB character being treated as column data, and the commas in the text of the cells being treated as delimiters, so there were many more columns than 2 created. At first, I didn't have column headers in the first row, and the first rows contained commas, and I wondered if that might be the problem, but after adding column headers as an additional first row, and reimporting, the problem persisted. What, besides the original file name, is Google using to decide what format the original file is, such that it ignores the explicit .tsv extension, and uses the .csv importer (apparently)? -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
