Ministry Centered Technologies
PCO Manual ยป Importing People using CSV files

Topics

  • Getting Started 6
    • An Introduction to Planning Center
    • Responding to Scheduling Emails
    • Managing Your Schedule
    • Updating Your Personal Information
    • Viewing Service Details & Files
    • Displaying Service Times
  • Setting Up 5
    • Creating A Service Type & Setting Up Dates and Times
    • Adding Items to your Plan
    • Adding People and Assigning Them To Positions
    • How to Schedule Your People
    • How to Use Songs, Arrangements & Keys
  • Account Administration 12
    • Canceling Your Account
    • Changing A Payment Method
    • Changing The Name of Your Account
    • Declined Payments or Delayed Checks
    • Enabling Extra File Storage
    • Enabling/Disabling Music Stand
    • Printing Receipts and Viewing Previous Payments
    • Changing the Primary Account Admin & Adding an Secondary Account Admin for Billing
    • Upgrading/Downgrading Your Account
    • Allowing Administrators to Delete
    • Changing Your Country
    • Locating your Organization and User ID Numbers
  • Apps 3
    • How To Install and use the Facebook App
    • iPhone App
    • Android App
  • Attachments 5
    • Adding Attachments
    • Uploading an Attachment
    • Linking to an attachment
    • Linking to iTunes or AmazonMp3
    • Linking to YouTube
  • Reporting 3
    • Custom Reports Wiki
    • Creating Reports on Frequency
    • Changing Custom Report Options
  • The Matrix 4
    • Setting Up The Matrix
    • Using The Matrix To Schedule
    • Using the Matrix Libraries Sidebar
    • Matrix Reports
  • Media 1
    • Adding and Uploading Media
  • Music Stand 4
    • Using the web-based version.
    • iPad Music Stand App
    • Annotations in Music Stand
    • Hardware for Music Stand
  • Personal Profiles 9
    • Block-Out Dates: Adding and Deleting
    • Changing Your Password
    • Setting Up Text Notifications
    • My Calendar
    • Master Calendar
    • Adding or Changing a Profile Picture
    • Forgotten Password, Login Issues and Error Message
    • Linking Accounts
    • Setting Your Scheduling Preferences
  • People 16
    • Adding a new person
    • Changing Permissions
    • Creating groups or teams for scheduling
    • Can't Add a Person - Duplicate Record Error
    • Filtering Your People
    • How to Email from the People Page
    • Print Report Options
    • Setting Up Custom Properties
    • Welcome Emails
    • Importing People using CSV files
    • Exporting a CSV File
    • Positions: Assign People Directly vs. Assign Using Custom Properties
    • Auto-scheduling
    • Setting Up Back-Up People for Positions
    • Disabling Users
    • Enabling Disabled User Accounts
  • Plans 40
    • The Plans Page (Dashboard)
    • Individual Plan Pages
    • Adding a One Time Special Service
    • Accessing Past Plans
    • Adding Notes Columns to Plans
    • Setting Up Different Teams for each Service Time
    • Changing the Replies To person for a People Category
    • Creating a New Service Type
    • Copying A Plan
    • Editing Or Deleting A Service
    • Deleting a Plan or Recovering Deleted Plans
    • Creating a Folder
    • Moving a service into another folder
    • Deleting Folders
    • Adding and Editing Times
    • Hotkeys for Plans Page
    • How to Create a New Plan
    • How to Link with iCal or Outlook 2007
    • How to Link with Google Calendar
    • Rearranging the order of a plan
    • Removing Items from Only One Plan Time
    • Scheduling A Person
    • Sending Notification Emails
    • Scheduling: Conflicts and Block-Out Dates
    • Scheduling Groups or Teams
    • Setting Up Reminder Emails
    • Adding and Editing People Categories
    • Reordering People Categories
    • Setting Up Positions
    • Setting Up or Editing Needed Positions
    • Item Note Categories
    • Adding or Editing Plan Notes & Categories
    • Resetting LIVE times
    • Setting up Ustream for Planning Center LIVE
    • Streaming and Downloading Songs in a Plan.
    • Using the Stage Layout feature
    • Commenting and Subscribing to Plan Items
    • Changing Options For Viewing a Person's Last Scheduled Date
    • Recovering Deleted Categories
    • Adding an Attachment to a plan item
  • Templates 4
    • Creating & Editing a Template
    • Editing Or Deleting A Template
    • Exporting a Template from an Existing Plan
    • Importing a Template (or Plan) to an existing plan
  • Site Settings 5
    • Site Settings
    • PCO Settings
    • Package Options
    • Billing Options
    • Attachment Types
  • Songs 15
    • Songs: An Overview
    • Adding a New Song
    • Adding Song Arrangements
    • Adding Keys to a Song Arrangement
    • Adding Attachments to Songs
    • Moving files from one arrangement to another
    • Transposing an Mp3
    • Transposing Chord Charts & Making Lyrics PDFs
    • Enabling and Disabling Downloading of MP3s
    • How to Convert to Mp3 Files in iTunes
    • Song Custom Properties
    • Filtering on the Songs Page
    • CCLI Reporting
    • SongSelect Integration
    • Preventing Charts from Shifting Using Chord Pro
  • Webinars 1
    • Webinar Schedule

Last Updated

Dec 19, 2011

Download Lesson PDF

Download Manual PDF

  • Prev: Welcome Emails
  • Next: Exporting a CSV File

Importing People using CSV files

If you have a CSV file with people you'd like to import, the Site Administrators can import all the people at once instead of adding each person individually.

Click CSV Import

Media_1324317079739_display

Select Browse to find your file.

Media_1324317140632_display

Find file, click Open.

Media_1324317876681_display

Select file from your computer, then click Open.

Select Next

Media_1324317939916_display

Identify Columns

Screen_shot_2011-12-19_at_10.09.03_am_display

To the left you will see the columns from your CSV file. You'll need to match these columns to what should be used in Planning Center. If you put Not Used next to a column, then the information from that column in your CSV file will not be imported into PCO. In this case, my CSV file has a lot of columns. I definitely won't need to use all of them. You must at least have First Name, Last Name, and Email Address in order for it to import.

Click Confirm and View Potential Changes

Media_1324319823287_display

Create New records

Media_1324319885747_display

If your people are already in the account, it will just choose Update Record. If this is a new person you are adding, it will choose Create New. If you have people in this CSV file that you don't need added or updated, select Ignore.

If you want these people to receive their welcome email, leave the box at the bottom checked. If you do not want them to receive it, uncheck the box. But, keep in mind that if you do that, there's not a way to mass-send the welcome emails again. You would have to go into each individual's page to send out their welcome email.

When finished click Apply Import to Database

To add an individual, see our lesson by clicking here

  • Prev: Welcome Emails
  • Next: Exporting a CSV File