Answers.Body: <p>It is a bit complicated. You will need to do at least 2 different imports, with external IDs. The CSVs for imports would look at this</p>
  <p>1st import</p>
  <pre><code>first_name, last_name, extID
  Jane, Doe, 1
  </code></pre>
  <p>2nd import</p>
  <pre><code>first_name, last_name, extID, Spouse-extID
  John, Doe, 2, 1
  </code></pre>
  <p>Take a look at <a href="https://civicrm.stackexchange.com/questions/38342/civicrm-5-29-0-import-relationships?rq=1">CiviCRM 5.29.0 - import relationships</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-02T09:34:59.390Z
Answers.LastActivityDate: 2021-02-02T09:34:59.390Z
Answers.UserDisplayName: Marko
Body: <p>I understand I need to convert a table into a csv file, but the contact table in question has both an individual and their spouse in the same record.  Now I can build a query that would only show me the individual's information, but once I import that information into civicrm how would I then import a list of spouses and get them to setup relationships, or will I just have to manually enter those in after importing the primary contact information?</p>
  
Tags: <data-import><csv>
Title: Importing Contacts from Access
ThreadText: # Importing Contacts from Access
  
  (Asked by: username_0 on 2021-02-02)
  
  I understand I need to convert a table into a csv file, but the contact table in question has both an individual and their spouse in the same record. Now I can build a query that would only show me the individual's information, but once I import that information into civicrm how would I then import a list of spouses and get them to setup relationships, or will I just have to manually enter those in after importing the primary contact information?
  
  **Tags:** data-import, csv
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-02-02. Score: 2
  
  It is a bit complicated. You will need to do at least 2 different imports, with external IDs. The CSVs for imports would look at this
  
  1st import
  
  ```
  first_name, last_name, extID
  Jane, Doe, 1
  
  ```
  
  2nd import
  
  ```
  first_name, last_name, extID, Spouse-extID
  John, Doe, 2, 1
  
  ```
  
  Take a look at [CiviCRM 5.29.0 - import relationships](https://civicrm.stackexchange.com/questions/38342/civicrm-5-29-0-import-relationships?rq=1)
  
  
  ---
  
  