Guides
Google Sheets guides
Practical, tested how-tos for getting real work out of a spreadsheet: printing labels from your rows, moving events and shift schedules between a sheet and Google Calendar, and working with addresses, ZIP codes, distances and maps. Each guide starts with the free method, gives exact steps and numbers, and is honest about the limits.
Labels & printing
How to print address labels from Google Sheets
A free Google Docs table, a Word mail merge, or an add-on: three ways from an address list to a printed label sheet.
Print Avery 5160 labels from Google Sheets
The exact 5160 measurements, a free Google Docs table built to match, and how to get them to line up.
How to make name tags from a Google Sheets list
From an event sign-up sheet to printed badges: the free Google Docs way, the 8-up badge measurements, and printing only who's attending.
Free Christmas card list template for Google Sheets
Download a ready-made card list: addresses, sent and received ticks, a summary tab and envelope addresses that build themselves.
How to print Christmas card address labels from Google Sheets
Set up the card list once, tick who gets a card this year, then print address and return labels.
How to print wedding invitation address labels from Google Sheets
A guest list built for wedding mail: one row per household, name etiquette, save-the-date and invite ticks, label sizes and RSVP envelopes.
How to print Avery 5163 shipping labels from Google Sheets
The exact 2" x 4" layout, a free Docs table, FROM/TO shipping labels, and printing straight from the rows.
Using LabelRows already? See the LabelRows documentation.
Calendars & events
How to create Google Calendar events from Google Sheets
Four ways from rows to events, including a free Apps Script that updates events instead of duplicating them.
How to import a spreadsheet or CSV into Google Calendar
The exact CSV headers and formats Calendar accepts, formulas that build them, and a safe test import.
How to export Google Calendar to Google Sheets
A date range of calendar events as tidy rows: a free Apps Script, an add-on, or the .ics export, plus totalling hours.
How to put a shift schedule from Google Sheets into Google Calendar
Turn a rota grid into calendar shifts: reshape the grid, handle night shifts, share with staff, update changes.
How to send Google Form responses to Google Calendar
A free, tested script that turns each response into an event, plus time zones, double bookings, edits and invites.
How to create recurring Google Calendar events from Google Sheets
One row becomes one repeating series: a free tested script, the repeat rules that work, and the limits to know.
How to make a timesheet from Google Calendar in Google Sheets
Turn calendar events into a timesheet: hours by client and week, billable hours, rates and overtime, with a free script and formulas.
Using CalendarRows already? See the CalendarRows documentation.
Addresses, distances & maps
How to find the nearest location in Google Sheets
Nearest store, office or rep for every row: closest match, top 3, within a radius, then drive time.
How to calculate the distance between ZIP codes in Google Sheets
Free Census data plus one formula: miles or km between US ZIP codes, no API key, leading zeros kept.
How to split an address into columns in Google Sheets
Street, city, state and ZIP in separate columns: the menu, SPLIT, and one tested formula that copes with apartments.
How to get the ZIP code from an address in Google Sheets
Pull the ZIP out of the text, or look it up: the free Census batch, a free Apps Script, or MapRows, plus county.
How to make a mileage log in Google Sheets that calculates reimbursement
The columns the IRS asks for, odometer miles, 2026 rates by date, monthly totals, a phone form and miles from addresses.
How to map ZIP codes from a Google Sheets list
Count your ZIP codes, get free coordinates for each, then map them as coloured pins, a heat map or shaded ZIP areas.
The best Google Sheets add-ons for maps, geocoding and distances
Six map and geocoding add-ons compared on price, free limits and best use, plus the free options that need no add-on.
How to geocode addresses in Google Sheets
Four ways to turn a column of addresses into latitude and longitude, with the free methods first.
A latitude and longitude formula for Google Sheets
A working =LATLNG() custom function, and how to fix "Service invoked too many times for one day".
Reverse geocode in Google Sheets: coordinates to addresses
Turn latitude/longitude columns into address, city, state, ZIP and country with a free script.
Distance between two coordinates in Google Sheets (haversine formula)
A tested haversine formula for straight-line distance in miles or km, with no script or API needed.
Calculate driving distance and travel time between addresses in Google Sheets
A free =DRIVE() formula for road miles and minutes, plus the quota limits and how to avoid them.
How to map addresses from Google Sheets
Put spreadsheet rows on a map: Google My Maps, the built-in geo chart, or a map image in your sheet.
Looking for how to use MapRows itself? See the MapRows documentation.