how-to

Practical how-to guides for Google Sheets tasks. Import CSV files, merge data, and automate your spreadsheet workflows.

Google Sheets SORT and SORTN Functions: Complete Guide

Master SORT and SORTN in Google Sheets. Sort by multiple columns, get top N results, handle ties, and combine with FILTER and UNIQUE.

Feb 25, 20266 min read

Learn REGEXMATCH, REGEXEXTRACT, and REGEXREPLACE in Google Sheets. Validate emails, extract URLs, clean data with regex patterns and examples.

Feb 24, 20266 min read

Create charts in Google Sheets step by step. Learn bar, line, pie, scatter, and combo charts plus customization, sparklines, and publishing tips.

Feb 24, 20267 min read

Fix the #N/A error in Google Sheets. Troubleshoot VLOOKUP, IMPORTRANGE, MATCH failures and learn to handle errors with IFERROR and IFNA.

Feb 24, 20267 min read

Import JSON data to Google Sheets using Apps Script, IMPORTDATA, or third-party tools. Step-by-step guide with code examples for nested JSON.

Feb 23, 20267 min read

Learn 4 ways to import multiple CSV files into one Google Sheet — merge tool, Apps Script, IMPORTRANGE, and add-ons. Step-by-step guide.

Feb 23, 20267 min read

Import XLSX files to Google Sheets without losing formatting, formulas, or data. See what converts, what breaks, and how to fix common issues.

Feb 23, 20267 min read

Link Excel and Google Sheets with 5 sync methods — Drive upload, IMPORTRANGE, OneDrive connectors, Sheetgo, and Apps Script. Two-way sync guide.

Feb 22, 20267 min read

Use the UNIQUE function in Google Sheets to extract distinct values, deduplicate rows, and build dynamic dropdowns. Syntax, examples, and tips.

Feb 22, 20266 min read

Big CSV and Excel imports freeze the tab and lose work. SmoothSheet does them server-side, with a backup you can roll back to.

See how it worksGoogle sign-in, no card. Free plan covers 10 uploads a month.