Answers.Body: <p>Sounds like the issue is that <strong>CiviCRM doesn't recognise the contents of your Country column</strong> (for some rows).</p>
  
  <p>In the import UI, you should see an option to <strong>download rows with errors</strong>, and that CSV will report which exact country values CiviCRM does not recognise.</p>
  
  <p>Eg, CiviCRM would accept either <code>US</code> (<a href="https://en.wikipedia.org/wiki/ISO_3166-1" rel="nofollow">ISO-3166</a>), <code>United States</code> (CiviCRM's label) or <code>1228</code> (CiviCRM's DB ID), but if the CSV contains <code>United States of America</code> or <code>U.S.A</code>, then CiviCRM might not recognise that alternative.</p>
  
  <p>Cleaning this up is usually as simple as a <em>Find &amp; Replace</em> in your import spreadsheet before re-importing. You might then rinse and repeat (<code>N.Z</code> => <code>NZ</code> or <code>New Zealand</code>) for further countries, or other invalid data that needs cleanup.</p>
  
  <p>To get a working <em>import</em> format, try <em>exporting</em> a few contacts (even if you have to create a few first), then use the resulting CSV as basis for your next import.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-29T18:29:53.977Z
Answers.Text: Or if you have access to the db, have a look in civicrm_country for a full list of the ID, the 'name' and the ISO code (which I think is also accepted) i.e. US (chris if you agree maybe update your answer re ISO)
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-29T16:19:15.573Z
Answers.LastActivityDate: 2015-09-29T20:19:50.127Z
Answers.LastEditDate: 2015-09-29T20:19:50.127Z
Answers.UserDisplayName: Chris Burgess
Body: <p>I am getting a crazy import error message:</p>
  
  <blockquote>
    <p>Invalid value for field(s) : Addressee must be one of the configured format options. Check Administer >> System Settings >> Option Groups >> Addressee for valid values; State/Province; Country input value not in country table: The Country value appears to be invalid. It does not match any value in CiviCRM table of countries.</p>
  </blockquote>
  
  <p>What is wrong?</p>
  
Tags: <import><error>
Title: What does this import error mean? "Invalid value for field(s) : ... Country input value not in country table"
ThreadText: # What does this import error mean? "Invalid value for field(s) : ... Country input value not in country table"
  
  (Asked by: username_0 on 2015-09-29)
  
  I am getting a crazy import error message:
  
  > Invalid value for field(s) : Addressee must be one of the configured format options. Check Administer >> System Settings >> Option Groups >> Addressee for valid values; State/Province; Country input value not in country table: The Country value appears to be invalid. It does not match any value in CiviCRM table of countries.
  
  What is wrong?
  
  **Tags:** import, error
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-09-29. Score: 4
  
  Sounds like the issue is that **CiviCRM doesn't recognise the contents of your Country column** (for some rows).
  
  In the import UI, you should see an option to **download rows with errors**, and that CSV will report which exact country values CiviCRM does not recognise.
  
  Eg, CiviCRM would accept either `US` ([ISO-3166](https://en.wikipedia.org/wiki/ISO_3166-1)), `United States` (CiviCRM's label) or `1228` (CiviCRM's DB ID), but if the CSV contains `United States of America` or `U.S.A`, then CiviCRM might not recognise that alternative.
  
  Cleaning this up is usually as simple as a *Find & Replace* in your import spreadsheet before re-importing. You might then rinse and repeat (`N.Z` => `NZ` or `New Zealand`) for further countries, or other invalid data that needs cleanup.
  
  To get a working *import* format, try *exporting* a few contacts (even if you have to create a few first), then use the resulting CSV as basis for your next import.
  
  > **Comments:**
  > **username_2**: Or if you have access to the db, have a look in civicrm_country for a full list of the ID, the 'name' and the ISO code (which I think is also accepted) i.e. US (chris if you agree maybe update your answer re ISO)  
  
  ---
  
  