title: Excel for Mac: Run Web Query with Text to Columns
body: <p>I'm making a Web Query on Excel by doing the following:</p>
  <ol>
  <li><p>Create a Word file, paste the web URL.</p>
  </li>
  <li><p>Save the Word as .iqy with .txt format.</p>
  </li>
  <li><p>Choose MS-DOS as coding.</p>
  </li>
  <li><p>Create an Excel file and click &quot;Data &gt;Get External Data &gt;Run Web Query</p>
  </li>
  </ol>
  <p><a href="https://i.stack.imgur.com/s9KwB.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s9KwB.jpg" alt="Data" /></a></p>
  <p>Is there a way to separate the text by columns when running the query?</p>
  <p>Thank you.</p>