How do I import beta reader applicants from a spreadsheet?

If people applied to beta read through a form or a sign-up sheet, you can bring them all in at once. Imported people arrive with the status Applied, so you can accept or reject each one.

Import a file

1. Open Beta Readers from the left sidebar.
2. Click Import.
3. On the Upload file tab, click Choose a file… and pick your spreadsheet. CSV, XLSX and TSV files work.
4. Check the column mapping. Match Name (required), Email, Book and Draft Version to your columns. The app guesses based on your column headings, so you may only need to confirm.
5. Check the line that says how many rows will import.
6. Click Import (the button shows how many applicants will be added).

Paste rows instead

1. In Google Sheets or Excel, select your rows, including the heading row, and copy them.
2. In the import window, choose Paste rows.
3. Paste into the box and click Parse Pasted Rows.
4. Map the columns and click Import.

Good to know

• The first row must be your column headings.
• Rows with no name in the mapped Name column are skipped.
• Every row becomes a new applicant. The import doesn't check for people you already have, so importing the same file twice creates duplicates.
• If you picked the wrong file, click ← Start over.
• If the import fails, you'll see Could not import these applicants. Nothing was saved. Please try again. Nothing is half-imported, so it's safe to try again.

To collect applicants automatically as they sign up, see "How do I add beta reader applicants automatically from my sign-up form?"