What files can I import?

You can import your data directly into Strive as a CSV file.  If your existing data is based in Excel or Google sheets, you can export your file as a CSV for import into Strive.
‍

Can I import custom fields?‍

Yes- import custom fields directly to your list. For your custom data to populate in Strive upon import, you must create your custom field and define the data type in the Strive Members table before you upload your CSV.
‍‍

Will Strive auto-populate any of my data?‍

Yes! When importing zip code data, Strive will auto-populate state data based on the zip code's location. If you upload updated zip code data, Strive will update any conflicting state values.
‍

Import a CSV

1. Prepare your Strive account for import

• If you are importing custom field data, create the custom field in the Members list before importing.
• If you are importing members who you’d like to assign to Access groups, create the group via the Groups page before importing.

‍
2. Prepare your data

‍Before importing your CSV, make sure your file:

• Contains your supporter’s phone numbers, formatted as +12345678910,
  1(234) 567-8910, or 12345678910.
• Is structured with individual columns for each data type (Example: Column 1: First name, Column 2: Last name).
• Includes group tags in a single column, separated by commas (Example: Volunteers, Phone bankers, Text bankers).
• Ensure any existing Group values match with values in your Members list. Data matching is case-sensitive.
• If you have a Subscribed column, make sure your values are either Y/N, Yes/No, T/F, or True/False.
• Remove quotes (“) in all rows and columns other than custom multi-select fields
• Remove formatting, like bold or italic, in all rows and columns.
  ‍

If you are importing custom fields:

• Make sure any existing single and multi select values match with pre-created custom values in Strive. Data matching is case sensitive.
• If you are importing multiple multi-select values for a member, wrap all values in a set of brackets [], wrap each value in quotes "", and separate each value with a comma and space. (Example: ["value", "value2", "value 3"] shows three values delineated with the correct formatting).
• If you are importing custom boolean values, represent values as True/False or T/F. Yes/No and Y/N will result in an import error.
• Custom date values are ISO formatted Year/Month/Date/Time/Timezone. (Example 2023-04-05T14:30Z). If no time or timezone is included in your value, Strive will default to noon UTC. (Example: importing 2022/07/05 will save as 2022-07-05T12:00:00.000Z).
• If you are importing custom number of currency values, Strive will not accept non numerical characters.
  ‍

Note: If you are importing zip code data, Strive will auto-populate state data in Member Records based on the zip code's location. Strive will override any conflicting state values based on zip code. If an invalid zip code is imported, Strive will neither populate a state value nor update an existing state value on the member record(s).

‍
3. Import your CSV‍

Note: If you are importing custom field data or Inbox Member Access Groups, create the field or group before import.

1. Navigate to your Members list,
2. Click Import.
3. Click Import a CSV.
4. Choose either to drag and drop in your CSV or click Browse to find the CSV you'd like to import from your files.
5. Once you have selected your CSV file, you will be prompted to map your data to the Strive Members list.
6. Map the Strive fields to existing fields in your CSV. You will be able to see all your existing fields in the drop-down menu.
7. Once all of your fields are mapped, click Import list.
8. Strive will begin importing your list. Please allow a few minutes for the import to complete.

Troubleshooting CSV imports

→ Why did my import create an error?
An error can be caused by any or a combination of the following:

• Formatting such as italics or bold text in any of your rows or columns. Remove all formatting before exporting your data as a CSV.
• Formated headers in any of your rows or columns. Remove all formatting before exporting your data as a CSV for import
• Decimal points in phone numbers or missing area codes. Format your numbers like this +12345678910 or this 1(234) 567-8910.
• Your CSV has quotes. Remove all quotes (“) from all rows and columns in your CSV. 
• Your custom field value(s) were not properly formatted

Go to the Members list and select Table Actions > Import History. In the Import History table use the Error column to identify the row and column in your CSV causing the error.

→ Why don't I see my custom field while data mapping my CSV?
You must create the custom field in the Members list before importing custom data. 

→ Why don't I see my Inbox Member Access Group after importing?

• Make sure you have created the Inbox Member Access group in Strive before importing your CSV file. 
• The Inbox Access Group in your CSV and Members list should share the same name. Data matching is case-sensitive.
  ‍

Can I see a history of my past imports?

Yes! To review your past CSV imports, head over to the Import history page. Learn more.