Skip to main content
CSV File Setup

The Foundation of Your Data Project

Updated over 2 months 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.

Snapizzi generates camera cards based on the order in your CSV file, so ensure the file is organized for your desired printing sequence (ignore this step if using Snapizzi Paperless). Your CSV can include any additional relevant data fields that define your project's structure.

If your CSV lacks a "Full Name" column, Snapizzi will automatically create one by merging the "First" and "Last" name columns.

GROUPS

Snapizzi automatically places group photos into the appropriate subject galleries. To help Snapizzi recognize your group columns, add an asterisk (*) to the group column header. If not added, you can define it during CSV field mapping.

Snapizzi generates a unique code for each group, which should be photographed before the group photos are taken.

For projects with multiple groups (e.g., ballet schools, bands), where subjects appear in more than one group photo, refer to this article on multi-group projects.

PASSWORD

To require customers to enter a password to view their photos, include a "Password" column in your CSV and enable passwords in your Privacy Settings. You can assign custom passwords, or if the column is left blank, Snapizzi will generate them for you. Avoid using ambiguous characters like the letter "O" and the number "0" to prevent confusion.
​
You can also edit passwords at any time.

GALLERY NAME

In the remote gallery, the default name for each subject is the 9-digit code from their camera card. To customize it, add a column titled "Gallery" to your CSV file and add the subject names in that column. You can also add a "Gallery" column (and others) to your CSV via the CSV editor.
​

Tip 1: To combine data from two separate columns into one, click here. Remember, if your CSV lacks a "Full Name" column, Snapizzi will automatically create one by merging the "First" and "Last" name columns.

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.

NEXT STEP:
​
Upload Your CSV File

Did this answer your question?