Import tsv using IMPORTDATA in google docs, delimiter wrong (treated as csv)

Question

I want to import a tsv file to a spreadsheet in Google Docs. The file has tab separated values but it is not named *.tsv Since it contains some values with a comma, it is treated as a csv. Is there a way to set a delimiter flag? The IMPORTDATA function should cover both csv and tsv.

Abhishek Ram Abhishek Ram · Accepted Answer · 2014-02-13T05:30:12

I am assuming that you are using the parseCsv function under the Utilities library. The function takes comma as the default delimiter, however you do have the option to specify a custom delimiter using the overloaded function parseCsv(csv, delimiter). In your case you must keep in mind that the delimiter needs to be specified explicitly in bot h cases, the program has no way of automatically figuring out the delimiter.

Import tsv using IMPORTDATA in google docs, delimiter wrong (treated as csv)

1 Answers