Answers.Body: <p>In some cases I have found that saving a csv that has been edited and resaved results in this type of behaviour. Solution in those cases was just</p>
  
  <ul>
  <li>open the csv</li>
  <li>copy all content</li>
  <li>paste in new csv, save, close, do not reopen or edit etc</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-16T18:59:57.440Z
Answers.LastActivityDate: 2016-11-16T18:59:57.440Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>I would suggest that you take a look at the documentation: <a href="https://docs.civicrm.org/user/en/stable/common-workflows/importing-data-into-civicrm/" rel="nofollow noreferrer">Importing Data into CiviCRM</a></p>
  
  <p>Read through this and follow the steps carefully. Try to export a small number of contacts - i.e. the first ten or so. If you are able to import these then the problem may be with some of the data in the later records.</p>
  
  <p>You may need to change the export settings so that fields are separated by a semicolon (;) rather than a comma (,).</p>
  
  <p>You may find the answers to this related post helpful: <a href="https://civicrm.stackexchange.com/questions/10143/csv-file-import-problem-with-file-from-mac-ms-office?rq=1">CSV file import problem with file from Mac MS Office</a></p>
  
  <p>If you are still having trouble it would be helpful if you could paste an example of the CSV file to your post <strong>with dummy data replacing any real data</strong>.  Again, just the first few lines would be sufficient.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-16T16:15:04.557Z
Answers.LastActivityDate: 2016-11-16T16:15:04.557Z
Answers.LastEditDate: 2017-04-13T12:53:13.017Z
Answers.UserDisplayName: William Mortada
Body: <p>On a PC, I've downloaded a list into excel and saved it as a MS-DOS CSV file. When I go to Civi to import it, Civi says it's not saved as a CSV file.</p>
  
  <p>I've followed the same steps I have for a dozen other contact lists.</p>
  
  <p>What am I missing?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-16T19:46:22.323Z
Comments.Text: William's answer is a good one - but more broadly, this sounds like a "character encoding" issue.
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <contacts><import>
Title: Transferring CSV contacts Civi
ThreadText: # Transferring CSV contacts Civi
  
  (Asked by: username_0 on 2016-11-16)
  
  On a PC, I've downloaded a list into excel and saved it as a MS-DOS CSV file. When I go to Civi to import it, Civi says it's not saved as a CSV file.
  
  I've followed the same steps I have for a dozen other contact lists.
  
  What am I missing?
  
  **Tags:** contacts, import
  
  > **Comments:**
  > **username_1**: username_3's answer is a good one - but more broadly, this sounds like a "character encoding" issue.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-11-16. Score: 1
  
  In some cases I have found that saving a csv that has been edited and resaved results in this type of behaviour. Solution in those cases was just
  
  * open the csv
  * copy all content
  * paste in new csv, save, close, do not reopen or edit etc
  
  
  ---
  
  ### Answer by username_3 on 2016-11-16. Score: 1
  
  I would suggest that you take a look at the documentation: [Importing Data into CiviCRM](https://docs.civicrm.org/user/en/stable/common-workflows/importing-data-into-civicrm/)
  
  Read through this and follow the steps carefully. Try to export a small number of contacts - i.e. the first ten or so. If you are able to import these then the problem may be with some of the data in the later records.
  
  You may need to change the export settings so that fields are separated by a semicolon (;) rather than a comma (,).
  
  You may find the answers to this related post helpful: [CSV file import problem with file from Mac MS Office](https://civicrm.stackexchange.com/questions/10143/csv-file-import-problem-with-file-from-mac-ms-office?rq=1)
  
  If you are still having trouble it would be helpful if you could paste an example of the CSV file to your post **with dummy data replacing any real data**. Again, just the first few lines would be sufficient.
  
  
  ---
  
  