title: Parse tab separated text file in Google Sheets
body: <p>I have a txt file available on the web which contains tab separated values  (TSV/CSV) like this:</p>
  
  <blockquote>
    <p>Product_Id<code>tab</code>Color<code>tab</code>Price<code>tab</code>Quantity<br>Item1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<code>tab</code>Red&nbsp;&nbsp;<code>tab</code>$5.2&nbsp;<code>tab</code>5<br>Item2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<code>tab</code>Blue&nbsp;<code>tab</code>$7.5&nbsp;<code>tab</code>10</p>
  </blockquote>
  
  <p>I imported the txt file into a Google Spreadsheet using the <code>IMPORTDATA(url)</code> formula. The problem is that now I need to split the text to columns. I tried the following formulas without success:</p>
  
  <pre><code>Split(A1,"\t")
  Split(A1,"    ")
  Split(A1,"&lt;tab&gt;")
  </code></pre>
  
  <p>another thing I tried is to to use the <code>Substitute</code> function, but I just can't figure out how to match the <code>Tab</code> character in Google Spreadsheets?</p>