How-to guides
Practical, step-by-step guides for everyday jobs our apps are built around. Every method works with or without our tools.
Best way to validate a Shopify or WooCommerce CSV before import
Step‑by‑step guide to pre‑flight product CSV files for Shopify and WooCommerce, detect common errors, fix them manually or with a tool, and avoid broken.
Step‑by‑step guide to pre‑flight product CSV files for Shopify and WooCommerce, detect common errors, fix them manually or with a tool, and avoid broken.
How to add input masks in Bubble for phone, date and SSN fields
Enforce consistent formats like (555) 123-4567 or MM/DD/YYYY in Bubble inputs using native options, free plugins, or a few lines of JavaScript - no paid.
Enforce consistent formats like (555) 123-4567 or MM/DD/YYYY in Bubble inputs using native options, free plugins, or a few lines of JavaScript - no paid.
How to audit a WordPress site for WCAG 2.2 and make a punch list
Learn a step‑by‑step method to audit your WordPress site for WCAG 2.2 issues, record each finding with element details, and export a client‑ready report.
Learn a step‑by‑step method to audit your WordPress site for WCAG 2.2 issues, record each finding with element details, and export a client‑ready report.
How to balance pool water chemistry from a test result
Work out exactly what to add to your pool: target ranges, the right dosing order, volume math and the saturation index, plus how to log your tests.
Work out exactly what to add to your pool: target ranges, the right dosing order, volume math and the saturation index, plus how to log your tests.
How to batch export Blender objects with consistent naming
Export multiple Blender objects to FBX/GLB/OBJ with a naming template: steps to select, format, and name files efficiently for games, 3D printing, or asset.
Export multiple Blender objects to FBX/GLB/OBJ with a naming template: steps to select, format, and name files efficiently for games, 3D printing, or asset.
How to build an instant quote calculator for a service business website
Create a live price estimator for cleaning, painting, moving or landscaping: pick the right pricing model, set up fields, handle minimums and tax, and.
Create a live price estimator for cleaning, painting, moving or landscaping: pick the right pricing model, set up fields, handle minimums and tax, and.
How to build consistent UTM-tagged URLs that follow a naming policy
Create UTM links that match your team's naming conventions every time: define policies, validate fields, batch-process CSV lists, and keep an auditable.
Create UTM links that match your team's naming conventions every time: define policies, validate fields, batch-process CSV lists, and keep an auditable.
How to check redirect maps for errors before migration
Fix redirect map issues like loops, missing URLs, and bad status codes manually or with tools. Step-by-step verification process.
Fix redirect map issues like loops, missing URLs, and bad status codes manually or with tools. Step-by-step verification process.
How to clean up text pasted into Google Docs
Clean up text pasted into Google Docs: remove hard line wraps, double spaces, odd bullets, smart quotes and hidden characters with find and replace.
Clean up text pasted into Google Docs: remove hard line wraps, double spaces, odd bullets, smart quotes and hidden characters with find and replace.
How to Compare CSV Files by ID Without Line-by-Line Confusion
Compare CSV files by business ID to find added, removed, or changed rows. Steps to analyze differences accurately without relying on line numbers.
Compare CSV files by business ID to find added, removed, or changed rows. Steps to analyze differences accurately without relying on line numbers.
How to create a wedding seating chart with no spreadsheet
Plan a wedding seating chart manually: group guests, arrange tables, avoid conflicts, and print a clear layout without apps.
Plan a wedding seating chart manually: group guests, arrange tables, avoid conflicts, and print a clear layout without apps.
How to design and print barcode price labels on label sheets
Plan and print barcode and price label sheets: pick a barcode type, verify the check digit, match the sheet template and test-scan before printing.
Plan and print barcode and price label sheets: pick a barcode type, verify the check digit, match the sheet template and test-scan before printing.
How to download and organize Facebook Ad Library ads
Step-by-step method to save Facebook Ad Library ads locally, name files consistently, and build a searchable swipe file without relying on browser.
Step-by-step method to save Facebook Ad Library ads locally, name files consistently, and build a searchable swipe file without relying on browser.
How to find and fix conflicting JSON-LD schema on a web page
Detect duplicate Organization, Product, or Breadcrumb markup from multiple plugins, see which script emitted each block, validate against Google required.
Detect duplicate Organization, Product, or Breadcrumb markup from multiple plugins, see which script emitted each block, validate against Google required.
How to find and replace in Google Sheets with a preview
Safely bulk-edit product titles, SKUs, URLs or names in Sheets: preview every change per cell, reject individual rows, use regex with capture groups, and.
Safely bulk-edit product titles, SKUs, URLs or names in Sheets: preview every change per cell, reject individual rows, use regex with capture groups, and.
How to fix CSV imports with wrong dates and decimals in Sheets
Fix a CSV that turned dates, decimals and ids into wrong values in Google Sheets: import as text, set the locale, then convert with simple formulas.
Fix a CSV that turned dates, decimals and ids into wrong values in Google Sheets: import as text, set the locale, then convert with simple formulas.
How to improve reflexes for daily 60-second safe-cracking games
Master daily 60-second safe-cracking games with proven techniques for faster reactions, focus and pattern recognition. Tips work without the app.
Master daily 60-second safe-cracking games with proven techniques for faster reactions, focus and pattern recognition. Tips work without the app.
How to make a calendar heatmap in Power BI
Build a calendar heatmap in Power BI: prepare a date table, choose a custom visual or a matrix, handle fiscal years, zero versus blank and colors.
Build a calendar heatmap in Power BI: prepare a date table, choose a custom visual or a matrix, handle fiscal years, zero versus blank and colors.
How to make a Wear OS watch face easier to read with low vision
Make a Wear OS watch easier to read with low vision: raise font size, pick high-contrast colors, keep one complication and check ambient mode settings.
Make a Wear OS watch easier to read with low vision: raise font size, pick high-contrast colors, keep one complication and check ambient mode settings.
How to manage a live event schedule with visual cues and timers
Keep your event on schedule with manual cue tracking, visual alerts, and timers for each segment. Steps to plan, monitor, and adjust your run of show.
Keep your event on schedule with manual cue tracking, visual alerts, and timers for each segment. Steps to plan, monitor, and adjust your run of show.
How to manage HTTP headers for different websites
Control HTTP headers per site without leaks: steps to set up and manage headers for testing, staging, and production environments
Control HTTP headers per site without leaks: steps to set up and manage headers for testing, staging, and production environments
How to organize Freshdesk canned responses with variables
Structure canned responses so agents pick the right snippet fast: use folders, placeholders, character counters, and per-channel visibility without extra apps.
Structure canned responses so agents pick the right snippet fast: use folders, placeholders, character counters, and per-channel visibility without extra apps.
How to plan a Shopify bulk price change safely
Change Shopify prices in bulk without surprises: calculate new prices and margins in a sheet, round to .99, protect compare-at and test before applying.
Change Shopify prices in bulk without surprises: calculate new prices and margins in a sheet, round to .99, protect compare-at and test before applying.
How to reconcile a supplier statement against your ledger in Excel
Match supplier statements to your purchase ledger step by step: prepare data, align columns, find mismatches, and resolve differences without special tools.
Match supplier statements to your purchase ledger step by step: prepare data, align columns, find mismatches, and resolve differences without special tools.
How to remove duplicate rows in Google Sheets and keep the best
Deduplicate a sheet by keeping the most complete row per key, merge unique values from discarded rows, and create an undo sheet - all with built-in features.
Deduplicate a sheet by keeping the most complete row per key, merge unique values from discarded rows, and create an undo sheet - all with built-in features.
How to remove hidden EXIF data from photos safely
Learn step‑by‑step how to view and strip EXIF metadata - GPS location, camera details, timestamps - from JPEG, PNG or HEIC images without external services.
Learn step‑by‑step how to view and strip EXIF metadata - GPS location, camera details, timestamps - from JPEG, PNG or HEIC images without external services.
How to run a tabletop combat round with manual initiative tracking
A practical guide for game masters to record initiative, hit points and conditions during a TTRPG encounter using simple paper or spreadsheet methods.
A practical guide for game masters to record initiative, hit points and conditions during a TTRPG encounter using simple paper or spreadsheet methods.
How to safely upload SVG files to WordPress and see what gets removed
Ensure every SVG you add to WordPress is clean and secure by using a preflight plugin that flags scripts, external links, and oversized files, then view a.
Ensure every SVG you add to WordPress is clean and secure by using a preflight plugin that flags scripts, external links, and oversized files, then view a.
How to set a custom countdown on Wear OS
Create a countdown to any date on your Wear OS smartwatch: step-by-step setup for built-in features and third-party alternatives.
Create a countdown to any date on your Wear OS smartwatch: step-by-step setup for built-in features and third-party alternatives.
How to shrink a photo to a target KB size without losing quality
Learn the exact steps to reduce a picture to a specific kilobyte limit by resizing, choosing the right format, adjusting compression and stripping metadata.
Learn the exact steps to reduce a picture to a specific kilobyte limit by resizing, choosing the right format, adjusting compression and stripping metadata.
How to split a group expense in Telegram without extra apps
Learn to divide a shared bill among Telegram friends using built‑in commands or simple calculations: collect amounts, compute each share, notify.
Learn to divide a shared bill among Telegram friends using built‑in commands or simple calculations: collect amounts, compute each share, notify.
How to split full names into first and last name in Sheets
Learn step‑by‑step how to separate a full name into first, middle and last parts in Google Sheets using built‑in formulas, without extra tools. Includes.
Learn step‑by‑step how to separate a full name into first, middle and last parts in Google Sheets using built‑in formulas, without extra tools. Includes.
How to track car maintenance and never miss an oil change
Never miss an oil change again: set service intervals by distance and months, log each service with odometer readings and keep a clean history.
Never miss an oil change again: set service intervals by distance and months, log each service with odometer readings and keep a clean history.
How to track multiple running counts without losing track
Learn practical methods to count several things at once, record each session, and keep a clean history you can review later.
Learn practical methods to count several things at once, record each session, and keep a clean history you can review later.
How to validate CRM imports before they break
Prevent CRM import errors with manual checks for duplicates, formatting, and picklists. Fix issues in Excel before uploading.
Prevent CRM import errors with manual checks for duplicates, formatting, and picklists. Fix issues in Excel before uploading.