How to Import Contestants From a Spreadsheet

Directors

You collected applications with a form. Now there are 120 rows in a spreadsheet and the People's Choice board is empty. This is how to get every one of them onto the board, with their headshots, in one upload.

Step 1: Export your form's responses

Download your responses as a spreadsheet. Where to find the button:

Form tool Where Format
Wix Forms Forms & Submissions, open the form's submissions table, Export CSV
Google Forms Responses, More, Download responses (.csv) CSV
Jotform The form's submissions in Tables, Download All Excel or CSV
Excel or Google Sheets File, Download or Save as .xlsx or CSV

Sources: Wix, Google, Jotform, checked 11/10/2026.

The file can have any column names, in any order. Keep the header row.

Step 2: Upload it

Open the division in Pageant Post, choose Add a list, and use Upload a spreadsheet at the top. Up to 300 people at a time.

Step 3: Check where each column goes

Pageant Post reads your column names and what is in them, and picks a home for each one:

  • Contestant fields: first and last name (or a full name), email, phone, parent or guardian name and phone, Instagram, TikTok and Facebook.
  • Headshot: the board photo. If your form has a close-up and a full body photo, the close-up is picked.
  • Other photo: kept on the person's contact book card, for you only.
  • Application answer: everything else, like height, sizes, availability and how they heard about you, saved on their contact book card under this pageant's name.
  • Skip: leave the column out.

The guesses check the values too, so a consent question that mentions "photos" stays an answer instead of becoming a photo column. Change any that are wrong and press Update the preview.

Step 4: Read the preview

Before anything is saved, the preview shows:

  • How many people will be added.
  • Skipped rows, by row number, with the reason: no name, already in this division, or a repeat further down the file.
  • People already in your contact book, matched by email or phone.
  • People with the same name as a card, which get a new card, since a name alone isn't proof it's the same person.

Tick the consent box and press Import.

Step 5: Let the photos come in

People are added right away. Photos download one at a time while a progress bar fills, and you can leave the page while it runs.

At the end you see who was added, who was skipped, and every photo to add by hand, each with its row number and a door to that contestant.

A photo link has to open publicly to the image itself. Wix Forms links work when the upload field's Personal information (PII) setting is off; with it on, Wix gives no link at all, and Wix turns it on for upload fields added since 09/22/2026, so check it before applications open. Google Forms upload links open a Google Drive page instead of the photo, so plan to add those by hand.

How duplicates are handled

Situation What happens
Already in this division (same name or email) Skipped, named in the preview
The same person twice in the file The first row is used, the second skipped
Same email or phone as a contact book card Joined to that card and updated
Same name as a card, nothing else matching A new card, listed under Possible duplicates to merge

Returning contestants

A model who applies again next year is matched to last year's contact book card by email, then by phone. Their card is updated: a new phone number replaces the old one, and nothing is erased by a blank cell.

Their answers are kept per pageant. Open their card and the Applications section shows this year's answers, with last year's one tap below, so you can see a dress size change or a new agency at a glance.

After the import

Everyone you imported is in the division right away, with their headshot, and shows on its People's Choice board once the pageant is published. To show that board on your own site, put People's Choice voting on your website.

Frequently asked questions

What file types can I import?

Excel (.xlsx) and CSV, including files exported from Wix Forms, Google Forms, Jotform and Google Sheets. Up to 300 people and 10 MB per file.

What happens to columns like height or dress size?

They are saved as application answers on each person's contact book card, under the pageant's name. Nothing your form collected is thrown away unless you choose Skip.

Will importing the same list twice add everyone twice?

No. Anyone already in the division, by name or email, is skipped and named in the preview before you import.

Why didn't some photos come in?

A photo link must open to the image itself, publicly. Private links, links that open a page instead of the image, and links to deleted files can't be downloaded. Each one is listed by row so you can add those photos by hand.

Run your next pageant with Pageant Post

Registration, judging, tabulation, check-in, payouts, and People's Choice voting, all in one place. Free until your voters vote.

Host a pageant, free