Answers.Body: <p>Mailchimp data imports pretty cleanly in my experience.  Excel data does not.</p>
  <p>For the Excel data, I recommend first doing an <em>export</em> from CiviCRM.  You'll have the most success if you take the headers from the CiviCRM export and match your Excel data to those headers.  E.g. if you have a &quot;name&quot; column, CiviCRM has a &quot;First Name&quot; and &quot;Last Name&quot;, so you'll want to split that up.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-12T08:46:05.387Z
Answers.Text: I'll give that a go - thanks.
Answers.UserDisplayName: Lee Leonhardt
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-07T03:03:16.947Z
Answers.LastActivityDate: 2023-08-07T03:03:16.947Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>We are working with 2 data sets:</p>
  <ol>
  <li>export from Mailchimp as a csv,</li>
  <li>export from Excel as a csv.
  I would like to start importing to CiviCRM Spark with clean data sets. Any tips?</li>
  </ol>
  
Tags: <data-import>
Title: Data prep to import to Spark
ThreadText: # Data prep to import to Spark
  
  (Asked by: username_0 on 2023-08-07)
  
  We are working with 2 data sets:
  
  1. export from Mailchimp as a csv,
  2. export from Excel as a csv.
     I would like to start importing to CiviCRM Spark with clean data sets. Any tips?
  
  **Tags:** data-import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-08-07. Score: 1
  
  Mailchimp data imports pretty cleanly in my experience. Excel data does not.
  
  For the Excel data, I recommend first doing an *export* from CiviCRM. You'll have the most success if you take the headers from the CiviCRM export and match your Excel data to those headers. E.g. if you have a "name" column, CiviCRM has a "First Name" and "Last Name", so you'll want to split that up.
  
  > **Comments:**
  > **username_0**: I'll give that a go - thanks.  
  
  ---
  
  