title: How to choose the delimiter for splitting text into columns?
body: <p>I have a DSV file and each row corresponds to one instance/piece of text as normal. Specifically, I have my own delimiter <code>###</code> instead of the default (i.e., comma <code>,</code>). However, when I open the DSV by using Google Sheets, these tools always display the DSV file by splitting automatically by default delimiter. It causes a mess because some columns may contain several commas.</p>
  
  <p>How can I disable the trigger that splits the text into columns automatically and only use my own delimiter?</p>
  
  <p>My DSV is like below:</p>
  
  <pre><code>a###b###c###d,e,f,g###h,",",j
  h###i,j,k###l###m###n,"[o,p]"
  q,r###s###c,u###v,w###x,y,'z,'
  </code></pre>
  
  <p>As suggested, I have tried to copy the content directly to a newly created Google sheet, however, I got the error as below due to the size of the content.</p>
  
  <blockquote>
    <p>There was a problem<br>
    Your input contains more than the maximum of 50000 characters in a single cell.</p>
  </blockquote>