CSV Import

CSV Importing is one method of import that allows you to include specific student information, like emails and passwords, with your images. If you are attempting to import a FLOW CSV job, please see our instructions here: FLOW CSV Uploading.

Jump to:

CSV Setup

Set up a spreadsheet that follows the listing below for column headers, in this exact order. Capitalization, spelling, spacing all are important. Your column headers must match what's below exactly. (Example: Column A cannot be "Job," it must be "Job Name"). We recommend using Google Sheets to create/manage your spreadsheet. Click here to download an example CSV Import job. 

Headers to include:

A. Job Name
B. Image Filename
C. Password
D. Last Name
E. First Name
F. Homeroom
G. Email Address 1
H. Email Address 2
I. Mobile Phone 1
J. Mobile Phone 2

Important Information

  • The "Job Name" field should be the same for every record in an import. If the "Job Name" value matches an existing folder in your account, the new galleries will be added to that existing folder.
  • For jobs with multiple images per student: All images with the same password will be added to the same gallery. If there are repeated passwords in a .CSV file, one gallery will be created for each unique password. Each image/pose will have the same password listed in column C and they must be one-after-another (sequential) in the CSV/spreadsheet.
  • Passwords are not case-sensitive. If you leave the Password field blank, a random password will be generated.
  • You can leave any field blank/empty that you don't know or isn't applicable. (Example: if you don't collect phone numbers, still include "Mobile Phone 1" and "Mobile Phone 2" as headers for Columns I and J but leave them blank)
  • The student's name does not appear on the website that students and parents see. When an order is placed, the student's name will appear in the order notification email sent to photographers.

Upload CSV Import via Web Browser (Chrome)

Note: CSV Imports are only supported within the Chrome web browser at this time.

  1. Login to SimplePhoto > click on Import > click on CSV Import
  2. Select the folder on your computer with the images + the .CSV file (created from your spreadsheet). If using Google Sheets, go to File > Download > Comma Separate Value (.csv). You'll select the master/school folder to import; do not drill down and select individual student folders/images. 

Troubleshooting CSV Imports

  • Make sure that you are importing a folder that contain both the images intended for upload and a single data file (CSV). Ensure that this data file has the extension .csv, not .bak or another extension.
  • Make sure no extra rows of data are present in your data file, even if they are empty. 
  • Ensure your headers are exactly as outlined above. Even a letter off can cause the import not to work. 
  • If you have a particularly large import, you may need a FTP server set up for you to upload (the browser import method may be timing out). Please email support@simplephoto.com requesting an FTP server and instructions. 

Related Articles