title: How to import CSV-file with Microsoft Excel 2016?
body: <p>I try to import a CSV-file in Excel. The program has funny default properties. It puts the content of the rows all in one column including the commas. Lets say the file content is (test.csv):</p>
  
  <pre><code>1, 2, 3
  4, 5, 6
  </code></pre>
  
  <p>What I expect Excel to do is to put each number into a separate field using the comma as separators. However, the excel table has only two fields each containing 3 numbers including the commas, something like this (not what I want):</p>
  
  <pre><code>"1, 2, 3"
  "4, 5, 6"
  </code></pre>
  
  <p>What do I have to change in Excel settings so that it does this standard task correctly?</p>