I have a txt file available on the web which contains tab separated values (TSV/CSV) like this:

> 
> Product\_Id`tab`Color`tab`Price`tab`Quantity  
> Item1        `tab`Red  `tab`$5.2 `tab`5  
> Item2        `tab`Blue `tab`$7.5 `tab`10
> 
> 
> 

I imported the txt file into a Google Spreadsheet using the `IMPORTDATA(url)` formula. The problem is that now I need to split the text to columns. I tried the following formulas without success:

```
Split(A1,"\t")
Split(A1,"    ")
Split(A1,"<tab>")

```

another thing I tried is to to use the `Substitute` function, but I just can't figure out how to match the `Tab` character in Google Spreadsheets?