Body: <p>I'm with a small non-profit that publishes a magazine and receives donations. There are separate spreadsheets for subscribers and donors, with a big overlap between.
  In preparing the spreadsheets for conversion to CiviCRM, what fields must I have?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-15T19:23:03.057Z
Comments.Text: Hi Polly - that is a really hard question to answer without lots more information about what you are trying to achieve. Perhaps just spend some time in civicrm familiarising yourself, set up some test contacts, add the data that makes sense. Then you could do an Export and compare that with your spreadsheets.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-15T19:25:27.947Z
Comments.Text: I find it can also be helpful to copy just the column titles (or also a couple of rows of data) and paste TRANSPOSED so i have it all in columns - may just be me, but i find it easier to run my eyes down the column of titles, than having to read left-to-right (not sure i am explaining this well without an example)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-15T19:26:09.627Z
Comments.Text: Finally - if you did the above and wanted to share as eg a Google S/sheet then I would be happy to take a quick look and add some comments if that was any help.
Comments.UserDisplayName: petednz - fuzion
Tags: <fields>
Title: What fields do I need in my spreadsheets to get started?
ThreadText: # What fields do I need in my spreadsheets to get started?
  
  (Asked by: username_0 on 2022-08-15)
  
  I'm with a small non-profit that publishes a magazine and receives donations. There are separate spreadsheets for subscribers and donors, with a big overlap between.
  In preparing the spreadsheets for conversion to CiviCRM, what fields must I have?
  
  **Tags:** fields
  
  > **Comments:**
  > **username_1**: Hi username_0 - that is a really hard question to answer without lots more information about what you are trying to achieve. Perhaps just spend some time in civicrm familiarising yourself, set up some test contacts, add the data that makes sense. Then you could do an Export and compare that with your spreadsheets.  
  > **username_1**: I find it can also be helpful to copy just the column titles (or also a couple of rows of data) and paste TRANSPOSED so i have it all in columns - may just be me, but i find it easier to run my eyes down the column of titles, than having to read left-to-right (not sure i am explaining this well without an example)  
  > **username_1**: Finally - if you did the above and wanted to share as eg a Google S/sheet then I would be happy to take a quick look and add some comments if that was any help.  
  
  ---
  
  ## 0 answers
  
  