How to Use Slides Create
Watch the video for each step, then follow the directions below it. Choose a tab to jump to any part of the process.
Introduction
What Slides Create does, and how it keeps your project organized in Google Drive.
Video coming soonIntroduction to Slides Create
Welcome
As a Google Innovator and a yearbook teacher still in the classroom, I built Slides Create to solve a problem I know firsthand: the high cost of traditional yearbook companies. My #MEX16 Google Innovator goal was to help schools create their own beautiful yearbooks and lower costs for families.
Slides Create works in four stages:
Gather
Import your photographer’s portraits in bulk, or add individual photos.
Review
Clean up data in Google Sheets and make sure every student is accounted for.
Design
Build a polished 8.5 x 11 two-page template in Google Slides.
Create
Merge photos and names into a file ready to print or share as a PDF.
How Your Project Is Organized
Slides Create makes one main Google Drive folder for your project. It holds:
- The Google Sheet you use to run the add-on.
- Subfolders for Bulk Imported Photos, Uploaded Individual Photos, Review Files, Design Templates, and Created Slides. Each subfolder is created the first time it is needed.
- The files inside each of those subfolders.
Setup
Setup is done once per yearbook project. It creates your project folder and the sheets Slides Create needs.
Video coming soonSetting Up Your Project
Before You Begin
Open a new Google Sheet and start the Slides Create add-on. Accept the permissions when asked. The 2027 version of Slides Create uses greatly reduced permissions, and your student information stays in your school Google Drive.
You don’t need your school photos yet. You’ll import those in Gather.
Step 1: Define Your Project
- Project NameEnter a name such as “2027 Yearbook” or “5th Grade Directory.” The default is 🌻SlidesCreate. This name is also used for your project folder.
- Project TypeChoose Elementary (sorted by grade, then by teacher; best for self-contained classrooms) or Middle School (sorted by grade level; teachers get their own staff section).
- Create Folder & Initialize SheetsClick the button. Setup takes a minute or two and shows progress as it runs. If it times out, click Try Again and it picks up where it left off.
Step 2: Move This Spreadsheet to Your Project Folder
When setup finishes, the sidebar shows your new project folder and the sheets it added: Dashboard, Images, StyleGuide, Lists, School List, and Removed. The last step keeps all your files together.
- Open the Folder MenuClick the folder icon 📁 next to the file name at the top left of the sheet.
- Move the FileChoose your project folder, then click Move.
- Start WorkingClick Open Main Menu. Want to look at the folder first? Use Open Folder ↗.
Gather
Bring in your photos and student data: import your photographer’s portraits all at once, then add individual photos for anyone who was missed.
Video coming soonImporting Your Photos
1 Import Photos from Your Photographer
- Get the Photo FilesAsk your school photographer for the high-resolution yearbook photos, usually sent as a .zip file. Photos exported from your student information system are often low quality and look fuzzy in print.
- Unzip the FileOn a desktop computer, unzip (extract) the file. You’ll get a folder with the student photos (often in subfolders by grade or teacher) and a data file, usually named
master.txt,index.txt, ormaster.csv. - Click Upload and ImportIn the sidebar under GATHER, click Upload and Import. The Bulk Import window opens.
- Select the MAIN FolderClick the box labeled Click to select the MAIN folder, or drag the folder onto it. Choose the main folder (usually in Downloads), not a single class subfolder, so the data file comes along.
- ConfirmYour browser asks you to confirm. Click Upload.
2 Map Your Data File
Slides Create finds your data file and opens the Map Your Data File screen, a preview of the first 10 rows.
- Columns Slides Create recognizes are highlighted green. Check each one.
- Use the dropdown at the bottom of any column that’s still blank. You must map Image Name, Section, and either Full Name or both First Name and Last Name. Extra columns can stay on “— Ignore —”.
- Name Format: if your file has one name column, choose First Last or Last, First to match it.
- Click Confirm & Upload. Click Allow access if asked, so the photos can appear in the Images sheet.
3 Recover When No Data File Is Found
If Slides Create can’t find a .csv or .txt file, it tells you what it noticed and offers three ways forward:
- Select a Different Folder: go back and choose the main folder that holds both the photo subfolders and the data file.
- Select Your Data File: keep the photos already found and browse straight to the data file, wherever it is.
- Match Against School List (no roster uploaded yet): upload your school’s roster first, then come back to the import.
- Match Using School List (roster already on file): import now. Slides Create matches each photo’s filename to your roster and fills in name, section, and teacher where it finds a confident match. Anything left over goes to Fix Missing Info.
4 Read the Import Results
When the import finishes, a results screen shows what happened. Only the groups that apply appear:
- ✨ Automatically matched: the name and photo didn’t share a filename, but the names matched closely enough to link.
- 🎓 Matched to school roster: photos with no data-file row whose filename matched a name on your School List.
- 🗑️ Couldn’t find a matching photo: names added without a photo. When you find the photo, add it with Add Individual Image, then use Check for Duplicates in Review to keep the record with the photo.
- 🖼️ Photos with no matching name: photos added without a name (retakes, extra shots, new students). Use Fix Missing Info in Review to add who they are.
- ↺ Already imported, skipped: photos already in your Images sheet.
Click Continue → Categorize Staff to go to the next step. If you imported with no data file, the button reads Continue → Fix Missing Info instead. Nothing has to be fixed right away.
5 Add Individual Photos
Video coming soonAdd Individual Photos
- Open the ToolIn the sidebar under GATHER, click Add Individual Image.
- Add the PhotoDrag the image in, click to choose a file, or click Select from Google Drive. A Drive photo shows its file name instead of a preview, and is copied into your project.
- Enter the InformationFirst Name, Last Name, and Section are required. Teacher is also required for Elementary projects. Click + New to add a Section, Teacher, or Role that isn’t in the list yet. In Elementary projects, choosing a Section shows only that section’s teachers.
- SaveSave & Add Another saves and clears the form for the next person. Save & Close saves and closes. Close exits without saving. Made a mistake? Back to Previous Entry reloads the last person you saved so you can fix it.
6 Retake Photos to Match the Professional Look
Video coming soonRetake Photos to Match the Professional Look
Phone photos rarely match the photographer’s look. Our solution: place each retake on a Canva or Adobe Express template.
- Prepare the TemplateMake a copy of the Canva or Adobe Express template, and install that app on the phone or tablet you’ll use.
- Set Up the WorkspaceOpen the template in the app, tap the page number icon, select Page 1, tap Duplicate, then open the new page.
- Take the PortraitTap +, choose Uploads › Upload from device › Camera, and take the headshot.
- EditTap Effects › Remove Background, then resize and position the photo to match the head guide.
- DownloadDownload as .jpg. On a desktop, several images download as a .zip you’ll need to unzip. On a Chromebook, download one at a time to skip that step.
Review
Clean up your data, find errors, and make sure every student is accounted for. Have a digital student list and a staff list from your office handy.
Video coming soonReviewing Your Data
Click Review & Clean Data in the sidebar to open the Review Hub. Work through the eight steps in order. The utility tools at the bottom can be used anytime.
1 Categorize Staff
Video coming soonCategorize Staff
- Identify SectionsCheck any section that contains only staff (for example, Administration or Office Staff). Common staff sections are pre-checked. A section only appears once at least one photo uses it.
- Classify StaffUse the arrow buttons, or double-click a name, to sort people into Non-Classroom Staff or Classroom Teacher. Names tagged on roster as teacher are already the Teacher for a class.
- Assign Grades Elementary onlyPick each teacher’s grade so their photo lands with their class. Grades already shown on the Images sheet are pre-selected. A teacher with no grade is saved as Non-Classroom Staff. Use Finish Later to save and come back.
2 Review Class Combo Conflicts Elementary only
Video coming soonReview Class Combo Conflicts
Finds teachers listed under more than one section. Student counts help you decide: similar counts (12 and 14) usually mean a real combo class; a lopsided split (28 and 1) usually means a data error. For each teacher, choose:
- Name the Class: merge the students into one combo section. A name is suggested for you.
- Fix a Data Error: pick the one correct section, and every row moves there.
- Ignore: two different teachers share a name. This choice is remembered.
Scroll down to review every conflict, then click Apply Changes. Middle School projects skip this step.
3 Check for Duplicates
Video coming soonCheck for Duplicates
Finds people who appear more than once: exact matches first, then possible matches such as compound names or spellings (“Annmarie” and “Annemarie”).
- Keep Selected & Next: check the photo(s) to keep. Unchecked photos move to the Removed sheet; nothing is deleted.
- Same Person – Merge & Next: correct the name (or click a suggested spelling), then choose which photo to keep.
- Not Duplicates & Next: two different people. Nothing changes, and the pair won’t be asked about again.
- Finish Later: saves your decisions so far and returns to the Hub.
4 Compare to School List
Video coming soonCompare to School List
- UploadDrag in your school’s roster export (.csv, .txt, or .xlsx). Required: Student Name and Grade/Section. Teacher is recommended so letters sort by classroom. Need help getting the file? Click 📋 Copy a Request Message for an email.
- Map ColumnsCheck the columns Slides Create guessed, map the rest, then click Process & Compare.
- See the ResultsThe School List sheet marks each student: ✅ has a photo, Need 📸, Possible Match, or Possible Misspelling.
After this, every new import updates the School List automatically.
5 Generate Missing Photo Letters
Video coming soonGenerate Missing Photo Letters
- Edit the default letter. Click a merge tag (FirstName, LastName, Teacher, Room, RetakeDate, RetakeTime, RetakeLocation) to insert it at your cursor.
- Fill in Retake Date, Time, and Location above the letter.
- Click 👁 Preview to see the letter for the first student.
- Click Generate Letters. One 8.5 x 11 slide per student is saved in your Review Files folder. Click Open the Letters File, or Continue → Generate Missing Info File.
6 Generate Missing Info File
Video coming soonGenerate Missing Info File
Creates a Google Slides file with one slide per record missing a name or section. Each slide shows the photo and its original filename, which is often a clue. Share it with office staff or teachers who can identify students, then click Continue → Fix Missing Info to enter what they found.
7 Fix Missing Info
Video coming soonFix Missing Info
- Fix records one at a time. Each shows the photo, its filename, and editable fields. Fields that were missing are highlighted.
- Slides Create suggests names from the filename: Matched to school roster (most reliable), Possible roster match (close, check it), or Guessed from the filename (always check). A blue note marks every guess.
- Section is required. Teacher is required for Elementary projects. Role is optional and mainly for adults.
- Click Save & Next, Skip (the record comes back next time), or ← Back for the previous record.
8 Review Unenrolled Students
Video coming soonReview Unenrolled Students
Shows students with a photo who are no longer on the latest school list. Do the steps in order: 1) remove unenrolled students, then 2) generate missing-photo letters, so you don’t write letters for students who left.
- Reviewed — No Change: nothing changes for now.
- Update Name: the student is still enrolled, but the name doesn’t match. Type the fix or click a suggestion.
- Remove: moves the row to the Removed sheet. Nothing is deleted.
🔧 Utilities & Tools
Video coming soonUtilities & Tools (optional)
- Reset Filter: rebuilds the Images sheet filter so it covers every row.
- Refresh Images: rebuilds photo thumbnails if they stop displaying.
- Sort Data: re-sorts the Images sheet by section, then last and first name.
- Manage Lists: edit the Section, Teacher, and Role dropdown lists, one item per line.
- Update Dashboard: refreshes Dashboard counts after you edit the sheet by hand.
- View Removed Photos: opens the Removed sheet.
Design
Experiment with colors, fonts, and decorations to build your two-page templates. Involve your students: let them design their own memories.
Video coming soonDesigning a Template
1 Create a Template
Click Create Template in the sidebar and choose a starting point:
- ✨ Choose from Gallery: pick a pre-made design with decorations, name it, then click Open Template, Create Another, or Close.
- 📁 Copy from My Drive: copy a template you made before, with everything intact.
- 📄 Start from Scratch: a blank 8.5 x 11 two-page canvas that goes straight into the layout wizard.
Every template’s name starts with “Template:” so they sort together.
2 Choose a Layout
Choose a photo count and a layout style. Slides Create draws the <<image>> and <<name>> tags on both pages, with a live preview.
Pick the total photo count across both pages. Two Kindergarten classes of about 28 can share one 60-count spread (one class per page), while a 6th-grade class of 60+ gets its own.
Classic
A title on both pages. The only style that fits two classes on one spread.
Showcase
A title on one page only.
Flow
No title on the page.
Roster Classic
Names listed along the outer margin instead of under each photo.
3 Choose Colors
- Search palettes by color (“terracotta”) or mood (“groovy,” “retro,” “neon”).
- A new background color picks the best-contrast text color for you. Swap Background & Text flips them.
- Use the Custom tab for your own colors, or Upload Image/Logo to pull colors from your school logo or a photo.
4 Choose Fonts
- Tap a feeling such as Playful, Vintage, or Calm to filter font pairs, or search by name.
- Use the Custom tab to type any Google Fonts name.
- Your colors and fonts are added to a Style Guide box in the side margin of page 1.
5 Confirm and Generate
Review your choices (each has an Edit link), then click Generate Layout. When it finishes, click Open Template or Create Another. The file name starts with its layout, for example “60 Classic – …”.
6 Update the Style of Existing Templates
Video coming soonUpdate the Style of Existing Templates
Change your mind anytime. Click Update Style in the sidebar:
- Select TemplatesCheck one or more templates (or Select all). The preview shows the real template.
- Choose ColorsSame palettes and Custom tab as Create Template.
- Choose FontsSame feeling filters and Custom tab.
- ApplyClick Apply Styles. This can’t be undone, so double-check your selection. Each updated template gets an Open ↗ link.
7 Add Decorations
Video coming soonAdd Decorations with Help from Claude
Once placeholders and styles are set, add decorations directly in Google Slides. Keep the <<image>>, <<name>>, and <<title>> tags in place.
Create
Build your yearbook file. Click Create Slides in the sidebar, and Slides Create inserts photos and names into your template, section by section.
Video coming soonBuilding Your Yearbook
1 Check Your Data
Slides Create scans your Images sheet for duplicate names in a class, rows missing a name or section, and rows missing a photo. Each issue has a button that opens the tool to fix it: Check for Duplicates, Fix Missing Info, or Open Review Hub.
Nothing here blocks you. If issues are found, the button reads Continue Anyway →. Reopen Create Slides after fixing to check again.
2 Name Your File and Choose a Template
Name your file (a name with today’s date is suggested), then choose a template. The preview shows the real template pages, including any decorations you added.
3 Select Sections and Pair Classes
Choose which sections to build. Use the search box or Select all. Each class shows its number of students.
Pair Two Classes on One Spread Classic only
- Click ⇆ Pairon a class.
- Click Chooseon a class that fits the other page. Classes that are too large are marked.
- AdjustUse ⇆ Swap sides to flip pages, or Unpair to undo.
4 Confirm and Build
Review your choices, then click Build Slides. If data issues are still open, a reminder shows the count with a See issues link, and the button reads Build Anyway.
Sections build one at a time, so larger rosters take a few minutes. When it’s done, click Open Final Slides ↗, or Build Slides Again to build with another template.
5 Finish Your Yearbook
Video coming soonFinish Your Yearbook
- Combine files: each Create Slides run makes its own file. Once you’ve built every template size you need, copy the slides into one final yearbook presentation.
- Final polish in Canva: import the finished file into Canva for stickers and effects, and download a high-resolution PDF for printing.
- Share your ideas: tell us what you’d like next in this Google Form.