Answers.Body: <p>Your name sounds Dutch, what often happens to me is that if you open this file with Excel and save it again, it is saved with ; in stead of ,</p>
  
  <p>Could that be the case?</p>
  
  <p>It also is possible it is saved as an Excel file in stead of .csv</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-13T13:34:54.867Z
Answers.Text: That's right, i am Dutch ;-).<br/>I have opened the file and saved it bak top csv. I also tried to copy and paste the data into a new csv file, with , as text separator. I also tried to create another file with the same data, but with text seperator ;. ,<br/>In Civicrm i changed Import Field Separator to ; and tried to import again. Same error.<br/>Both times i saved the file as CSV. Do you have other suggestions i can try?
Answers.UserDisplayName: Hilco Regterschot
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-13T14:34:38.627Z
Answers.Text: please send me (part of) your .csv file
Answers.UserDisplayName: Catorghans
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-13T14:53:23.713Z
Answers.Text: It is very possible that you have the wrong encoding. To be able to see that you have to send the CSV file, which is what @Catorghans already offered :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-14T08:17:17.950Z
Answers.Text: I have send the file to @Catorghans. There was nothing wrong with the file. I have asked my client if Catorghans can get access to the site and server, so he can take a look.
Answers.UserDisplayName: Hilco Regterschot
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-13T13:24:13.337Z
Answers.LastActivityDate: 2016-04-13T13:24:13.337Z
Answers.UserDisplayName: Catorghans
Body: <p>I am trying to import a csv file as a test into Civicrm. I first exported the exact same file from Civicrm, and then i tried to import the exact same file. When i click on Continue, i get an error "Input file must be in CSV format". 
  I have this error code:</p>
  
  <pre><code>Array
  (
      [name] =&gt; Map1.csv
      [type] =&gt; 
      [tmp_name] =&gt; 
      [error] =&gt; 6
      [size] =&gt; 0
  )
  </code></pre>
  
  <p>Can someone tell me what to do? </p>
  
  <p>With kind regards,
  Hilco Regterschot</p>
  
Tags: <contacts><import>
Title: Input file must be in csv format
ThreadText: # Input file must be in csv format
  
  (Asked by: username_0 on 2016-04-13)
  
  I am trying to import a csv file as a test into Civicrm. I first exported the exact same file from Civicrm, and then i tried to import the exact same file. When i click on Continue, i get an error "Input file must be in CSV format". 
  I have this error code:
  Array
  (
      [name] => Map1.csv
      [type] => 
      [tmp_name] => 
      [error] => 6
      [size] => 0
  )
  
  Can someone tell me what to do? 
  With kind regards,
  username_0
  
  **Tags:** contacts, import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-04-13. Score: 2
  
  Your name sounds Dutch, what often happens to me is that if you open this file with Excel and save it again, it is saved with ; in stead of ,
  
  Could that be the case?
  
  It also is possible it is saved as an Excel file in stead of .csv
  
  > **Comments:**
  > **username_0**: That's right, i am Dutch ;-).<br/>I have opened the file and saved it bak top csv. I also tried to copy and paste the data into a new csv file, with , as text separator. I also tried to create another file with the same data, but with text seperator ;. ,<br/>In Civicrm i changed Import Field Separator to ; and tried to import again. Same error.<br/>Both times i saved the file as CSV. Do you have other suggestions i can try?  
  > **username_1**: please send me (part of) your .csv file  
  > **username_2**: It is very possible that you have the wrong encoding. To be able to see that you have to send the CSV file, which is what @username_1 already offered :-)  
  > **username_0**: I have send the file to @username_1. There was nothing wrong with the file. I have asked my client if username_1 can get access to the site and server, so he can take a look.  
  
  ---
  
  