Better Sheets
Log in
Templates
Academy
Tools
Formulas
Free
Log in Get Instant Access
Templates
  • Habit Tracker 2 templates
  • Project Management Template 2 templates
  • Budget Template 1 template
  • Calendar Template 1 template
  • Dashboard Template 1 template
  • Monthly Budget Template 1 template
  • Time Tracking Template 1 template
  • Finance Template 1 template
  • CRM Template 1 template
Explore Templates
Academy

Courses

  • Adventures in AI 23 videos
  • Beyond Sheets 11 videos
  • Build Better Dashboards 6 videos
  • Fab Sheets 43 videos
  • Faster Sheets 5 videos
  • How To Create a Google Sheets™ Add-on 33 videos
  • Learn to Code in Google Sheets | Intro To Scripting 13 videos
  • Let's Make a Progress Bar 4 videos
  • Profitable Sheets 18 videos
  • Selling Spreadsheets 57 videos
  • Sheet Code 62 videos
  • Spreadsheet Automation 101 - How to Automate Google Sheets 40 videos
  • Supercharge Your Sheets 29 videos

Apps Script

  • Apps Script Explainer
  • Code Snippets
  • Spreadsheet Automation 101
  • Code Consultations
  • Apps Script directory

Videos

  • Automating
  • Better Sheets Updates
  • Build Your Own Tools
  • Data Analysis in Google Sheets
  • Data Management
  • Embed Google Sheets
  • For Beginners
  • Formula Combinations
  • Google Apps Script - Custom Functions in Google Sheets
  • Google Forms
  • All tutorials
All Courses Better Sheets on YouTube
Tools

Build from Sheets

  • Sites
  • OnlySheets

URL Generators

  • Sheet to URL
  • CSV URL Generator
  • XLSX URL Generator
  • PDF URL Generator
  • Copy URL Generator

More tools

  • Discover Sheet Tools
  • Create Portals
  • Portal Builder
All tools
Formulas

Directory

  • AI Formula Generator
  • Formula Library

Popular formulas

  • SUMIF
  • COUNTIF
  • VLOOKUP
  • FILTER
  • IMAGE
  • SUMPRODUCT
  • GOOGLEFINANCE

Quick Help

  • QUERY Generator
  • SPARKLINE Generator
  • Conditional Formatting Generator
  • REGEXMATCH Generator
  • REGEXREPLACE Generator
Browse all formulas
Free

Hub

  • Free Hub
  • Big Year: A Yearly Calendar Template
  • Blog
  • Better Sheets on YouTube
  • I Love Google Sheets

Add-ons

  • Sheet Styles
  • Tiny Sheets
  • Spintax
  • Button Styles
  • Quiz Builder
  • CPM
  • Sync Sheets
  • Ask Sheets Anything
All Google Sheets add-ons
  • Habit Tracker 2 templates
  • Project Management Template 2 templates
  • Budget Template 1 template
  • Calendar Template 1 template
  • Dashboard Template 1 template
  • Monthly Budget Template 1 template
  • Time Tracking Template 1 template
  • Finance Template 1 template
  • CRM Template 1 template
Explore Templates

Courses

  • Adventures in AI 23 videos
  • Beyond Sheets 11 videos
  • Build Better Dashboards 6 videos
  • Fab Sheets 43 videos
  • Faster Sheets 5 videos
  • How To Create a Google Sheets™ Add-on 33 videos
  • Learn to Code in Google Sheets | Intro To Scripting 13 videos
  • Let's Make a Progress Bar 4 videos
  • Profitable Sheets 18 videos
  • Selling Spreadsheets 57 videos
  • Sheet Code 62 videos
  • Spreadsheet Automation 101 - How to Automate Google Sheets 40 videos
  • Supercharge Your Sheets 29 videos

Apps Script

  • Apps Script Explainer
  • Code Snippets
  • Spreadsheet Automation 101
  • Code Consultations
  • Apps Script directory

Videos

  • Automating
  • Better Sheets Updates
  • Build Your Own Tools
  • Data Analysis in Google Sheets
  • Data Management
  • Embed Google Sheets
  • For Beginners
  • Formula Combinations
  • Google Apps Script - Custom Functions in Google Sheets
  • Google Forms
  • All tutorials
All Courses Better Sheets on YouTube

Build from Sheets

  • Sites
  • OnlySheets

URL Generators

  • Sheet to URL
  • CSV URL Generator
  • XLSX URL Generator
  • PDF URL Generator
  • Copy URL Generator

More tools

  • Discover Sheet Tools
  • Create Portals
  • Portal Builder
All tools

Directory

  • AI Formula Generator
  • Formula Library

Popular formulas

  • SUMIF
  • COUNTIF
  • VLOOKUP
  • FILTER
  • IMAGE
  • SUMPRODUCT
  • GOOGLEFINANCE

Quick Help

  • QUERY Generator
  • SPARKLINE Generator
  • Conditional Formatting Generator
  • REGEXMATCH Generator
  • REGEXREPLACE Generator
Browse all formulas

Hub

  • Free Hub
  • Big Year: A Yearly Calendar Template
  • Blog
  • Better Sheets on YouTube
  • I Love Google Sheets

Add-ons

  • Sheet Styles
  • Tiny Sheets
  • Spintax
  • Button Styles
  • Quiz Builder
  • CPM
  • Sync Sheets
  • Ask Sheets Anything
All Google Sheets add-ons
Sites / Templates / Gallery

Your mood board spreadsheet deserves a gallery wall

You already track image URLs, captions, and links in Google Sheets. Publish them as a masonry gallery on yoursite.bettersheets.co. Choose which columns visitors see. Update the Sheet and the wall updates on the next visit.

Turn my Sheet into a site

Free preview · Paste a public Sheet URL · No code

Compare sheet-to-site builders

Gallery reads image URLs from your Sheet and lays them out in a responsive masonry grid. Pick which columns appear as captions under each image. Optional link column makes tiles clickable. You control visibility column by column in site settings.

Why a shared folder is not a portfolio

You have the images. They live in a Sheet, a folder link, or a slide deck nobody opens. Meanwhile:

  • Clients ask for a portfolio URL and you send a Google Drive folder with 200 thumbnails
  • Your Sheet has captions, tags, and credits — but viewers only see raw columns
  • Uniform card grids crop every image to the same height
  • You hide internal columns by copying data to a second tab every week

Gallery keeps your master Sheet as source of truth and shows only the columns you choose — in a layout built for images, not product SKUs.

Examples

Photographer portfolio

Clients want a browseable wall, not edit access to your tracking Sheet.

Image URL · Title · Series · Year · Portfolio link

Masonry tiles. Natural aspect ratios. Click through to your site.

Design mood board

Reference images live in a Sheet the team updates daily.

Image URL · Project · Source · Notes

Show project and source. Hide internal notes with column picker.

Event photo wall

Volunteers add rows during the event. You need a public wall tonight.

Photo URL · Photographer · Caption

Publish before doors close. Search finds a name fast.

Art fair or maker booth list

Each vendor has a hero image and booth number in a master Sheet.

Image URL · Vendor · Booth · Shop link

Link column opens their shop. Masonry feels like a walk through the fair.

Real estate or interiors lookbook

Listings have different image shapes — cropping ruins the room shots.

Image URL · Address · Style · Listing link

Tall and wide photos coexist. Captions stay optional.

For image-first publishing, not product catalogs

  • Photographers, designers, and artists sharing visual work
  • Event teams publishing photo walls or sponsor logos
  • Agencies curating reference boards for clients
  • Anyone with image URLs in a Sheet who wants a real gallery URL

Masonry, not a rigid grid

Images keep their natural proportions in a multi-column masonry layout. Captions sit below each tile — only the columns you enable in settings. Optional link column wraps the whole tile in a click target.

From Sheet to gallery in three steps

  1. Paste your Sheet URL at bettersheets.co/sites
  2. Choose Gallery as your template
  3. Preview free then pick visible columns and publish to yoursite.bettersheets.co

Gallery Sheet structure that works on day one

Recommended columns

Image URL · Title · Caption · Category · Link

Tips

  • Put a direct image URL (JPG, PNG, WebP) in your image column, or enable Unsplash for rows missing images
  • Use column start to skip checkbox or ID columns on the left
  • In site settings, check only the columns you want visitors to see under each image
  • Set a link column to make tiles open a portfolio page, listing, or source URL
  • Enable search when the gallery has more than ~20 rows

What you get with Gallery

Masonry layout
Mixed aspect ratios look intentional, not cropped into identical boxes
Column picker
Show captions and metadata without exposing every Sheet column
Optional link column
Each tile can open a detail page or external URL
Visitor search
Find images by caption or category text
Image column + Unsplash
Fill missing images with stock photos and photographer credit
Live Sheet data
Add a row, get a new tile on the next page load

Gallery vs the other templates

  • Catalog: rows are products with prices and SKUs, not a photo wall
  • Directory: rows are people with bios, not image tiles
  • Feed: rows are link roundups with article previews, not image masonry
  • Simple: you want a plain table, not a visual gallery

FAQ

Do I need the same image size for every row?
No. Gallery uses a masonry layout so tall and wide images can sit side by side without forced cropping.
Can I hide columns from visitors?
Yes. In site settings, check only the columns you want shown as captions. Leave all unchecked to show every column except the image and link columns.
Can tiles link somewhere?
Yes. Set a link column in Gallery settings. When a row has a URL there, the whole tile is clickable.
Can visitors search the gallery?
Yes. Enable search in site settings. Search runs across visible caption text.
Is preview free?
Yes. Publishing a live subdomain requires Better Sheets membership.
How is this different from Catalog?
Catalog is built for product cards with uniform images and commerce fields. Gallery is image-first with natural proportions and selective column display.

Good fit

  • Your Sheet is mostly image URLs with optional captions
  • You want to hide internal or draft columns from the public
  • Mixed image sizes should display without awkward cropping

Not a fit

  • Rows are products with prices and SKUs (use Catalog)
  • You need a sortable data table (use Simple or Dashboard)
  • Rows are article links, not images (use Feed)

Your images are already in the Sheet

Paste the URL. Pick Gallery. Choose which columns to show. Preview in under a minute.

Turn my Sheet into a site

Free preview · No code

One Sheet. One gallery URL. Show only what you choose.

Stop sending folder links. Publish a masonry wall that stays current when you edit the Sheet.

Create my Gallery site

Free preview · Publishing requires membership · Compare builders

Preview any template free. Save drafts and publish a live *.bettersheets.co site with Better Sheets membership (from $9/month when billed monthly). See pricing.

Pick the right template

  • Directory: people, teams, and resource cards
  • Catalog: products, services, and inventory
  • Dashboard: metrics tables with summary stats
  • Simple: plain searchable tables

All templates Create a site


Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

  • Google Sheets Templates
  • Blog
  • Google Sheet Formulas
  • Automate Google Sheets with Apps Script
  • Free Sheets
  • Add AI to your Sheet
  • Wizards in Training Leaderboard
  • Learn on YouTube

Google Sheets Courses

  • Learn to Code in Google Sheets
  • Build Better Dashboards
  • Automate Spreadsheets
  • Learn to Sell Spreadsheets

Google Sheet Templates and Tools

  • AI FORMULA GENERATOR
  • Apps Script Explainer
  • Download Google Sheets to PDF
  • Embed Google Sheets
  • Download Google Sheet to CSV
  • Copy Your Sheets
  • 100 Sheet Business Ideas

Google Sheet Add Ons

  • Google Sheets Add-ons
  • Sheet Styles
  • Tiny Sheets
  • Button Styles
  • Build Google Sheets Addons
  • Sell Sheets with OnlySheets

Better Sheets is a Kamphey Approved Production