Answers.Body: <p>This has been answered before indeed: <a href="https://civicrm.stackexchange.com/questions/19056/noob-query-importing-contacts-and-membership">noob query : Importing contacts and membership</a>
  and here: <a href="https://docs.civicrm.org/user/en/latest/membership/manual-entry-of-memberships/" rel="nofollow noreferrer">https://docs.civicrm.org/user/en/latest/membership/manual-entry-of-memberships/</a>
  Thanks for the exchange:-)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-03T09:38:01.460Z
Answers.LastActivityDate: 2020-03-03T09:38:01.460Z
Answers.UserDisplayName: user3635986
Body: <p>I'm new to CiviCRM and have a somewhat noob question about importing membership data from a spreadsheet.
  We have this data in a way that each row is a company with organizational data (membership type and date and tax number..etc) and some of the columns in this row have also individuals (employees of the company) in them with their contact details in other columns.
  How should we start the importing is my question. Should I first import our members as organizations and then do another import for the individuals...all into contacts? How to connect these to the companies? Does it work with say based on ID-s that I give to the companies beforehand?
  Also how to import these same companies to the membership module?</p>
  
  <p>I'm using latest Joomla and CiviCRM.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-03T08:08:31.670Z
Comments.Text: I am so new I didn't spend enough time reading this:-) https://civicrm.stackexchange.com/questions/19056/noob-query-importing-contacts-and-membership.
Comments.UserDisplayName: user3635986
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-03T08:21:53.963Z
Comments.Text: if that is enough of an answer we can either mark this as a duplicate question, or we (you) could add that link as your own answer
Comments.UserDisplayName: petednz - fuzion
Tags: <civimember><import>
Title: How to import members spreadsheet
ThreadText: # How to import members spreadsheet
  
  (Asked by: username_0 on 2020-03-03)
  
  I'm new to CiviCRM and have a somewhat noob question about importing membership data from a spreadsheet.
  We have this data in a way that each row is a company with organizational data (membership type and date and tax number..etc) and some of the columns in this row have also individuals (employees of the company) in them with their contact details in other columns.
  How should we start the importing is my question. Should I first import our members as organizations and then do another import for the individuals...all into contacts? How to connect these to the companies? Does it work with say based on ID-s that I give to the companies beforehand?
  Also how to import these same companies to the membership module?
  
  I'm using latest Joomla and CiviCRM.
  
  **Tags:** civimember, import
  
  > **Comments:**
  > **username_0**: I am so new I didn't spend enough time reading this:-) https://civicrm.stackexchange.com/questions/19056/noob-query-importing-contacts-and-membership.  
  > **username_1**: if that is enough of an answer we can either mark this as a duplicate question, or we (you) could add that link as your own answer  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-03-03. Score: 2
  
  This has been answered before indeed: [noob query : Importing contacts and membership](https://civicrm.stackexchange.com/questions/19056/noob-query-importing-contacts-and-membership)
  and here: <https://docs.civicrm.org/user/en/latest/membership/manual-entry-of-memberships/>
  Thanks for the exchange:-)
  
  
  ---
  
  