Skip to main content
CSV File Setup

The heart of your Data project

Updated over a week ago

To import project data, it must be saved as a CSV (comma-separated values) file. This format stores data in plain text where each value is separated by a comma. You can create a CSV file using spreadsheet programs like Excel, Numbers, or Google Sheets by saving your spreadsheet with UTF-8 encoding. While UTF-8 is usually the default encoding in most spreadsheet programs, it's not always the case. If your program prompts you to choose an encoding format, make sure to select UTF-8.

SEARCH BEHAVIOR

The default search criteria for your Studio Search Page include Name, ID, or the Snapizzi 9-digit code. To ensure the search function operates correctly, your CSV file needs to have columns with correctly formatted headers for "First Name" and "Last Name," or a single "Full Name" column. If the headers are formatted incorrectly, a "Searchability" warning will appear in the Diagnose & Remedy tool. The table below lists alternative header formats that are also acceptable.

Camera Cards are generated in the order listed in your CSV file, so make sure to arrange them in the desired printing order (this step can be disregarded if you're using Snapizzi Paperless). Beyond the name headers mentioned earlier, your CSV file can include any additional data fields relevant to your project, as these fields define the data structure for each project.

GROUPS

When applicable, Snapizzi will automatically place group photos in their respective subject's galleries. Adding an asterisk* to the name of the column header of your groups will automatically tell Snapizzi the column defines your groups. It isn't required, but if not done, you'll do it when mapping your CSV fields.

Snapizzi will generate a code for each unique group. Simply photograph the group's code before taking the group photos.

Read this for multi-group projects (ballet schools, bands, etc.), where a subject is in more than one group photo.

PASSWORD

If you'd like to require customers to enter a password to view their photos, you must include a column labeled "Password" in your CSV file as well as enable passwording in the Privacy Settings. You can define the passwords however you wish, but if no values are in the password column, Snapizzi will create passwords for you. We recommend that you don't use the letter O or number 0 unless the context is clear for your customers. For example, if using last name, they know it would be the letter O. Or if using numbers, they know it would be a zero.

You can easily edit passwords at any time.

GALLERY NAME

This is what is displayed on the remote gallery for your customer when they see their photos. The default gallery name for each subject is the 9-digit code from their camera card. To change it, include a column on your CSV called "Gallery" and paste the subject names in the cells.

Your header name must be "Gallery" in order to work properly.

Tip 1: To combine data from two separate columns into one, click here. This is useful for combining first and last name fields in order to use the subject's full name for the remote gallery name.

Tip 2: If you have data in one column and would like to create separate columns for each, click here. This is useful if you have a full name field and would like to create a first and a last name column.

Did this answer your question?