title: R- import CSV file, all data fall into one (the first) column
body: <p>I'm new, and I have a problem: </p>
  
  <p>I got a dataset (csv file) with the 15 columns and 33,000 rows. </p>
  
  <p>When I view the data in Excel it looks good, but when I try to load the data
  into R- studio I have a problem: </p>
  
  <p>I used the code: </p>
  
  <pre><code>x &lt;- read.csv(file = "1energy.csv", head = TRUE, sep="")
  View(x)
  </code></pre>
  
  <p>The result is that the columnnames are good, but the data (row 2 and further) are
  all in my first column. </p>
  
  <p>In the first column the data is separated with ; . But when i try the code: </p>
  
  <pre><code>x1 &lt;- read.csv(file = "1energy.csv", head = TRUE, sep=";")
  </code></pre>
  
  <p>The next problem is: Error in read.table(file = file, header = header, sep = sep, quote = quote,  : 
    duplicate 'row.names' are not allowed</p>
  
  <p>So i made the code: </p>
  
  <pre><code>x1 &lt;- read.csv(file = "1energy.csv", head = TRUE, sep=";", row.names = NULL)
  </code></pre>
  
  <p>And it looks liked it worked.... But now the data is in the wrong columns (for example, the "name" column contains now the "time" value, and the "time" column contains the "costs" value.</p>
  
  <p>Does anybody know how to fix this? I can rename columns but i think that is not the best way.</p>