how-to

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

How to Freeze Rows and Columns in Google Sheets (Complete Guide)

Freeze rows and columns in Google Sheets to keep headers visible while scrolling. Step-by-step guide with tips for large datasets.

Feb 21, 20266 min read

Remove duplicates in Google Sheets with 5 methods — built-in tool, UNIQUE function, conditional formatting, COUNTIF, and Apps Script.

Feb 21, 20267 min read

Getting a #REF! error in Google Sheets? Learn every cause — deleted cells, circular references, VLOOKUP, IMPORTRANGE — and how to fix them.

Feb 20, 20266 min read

Master the SPLIT function in Google Sheets. Parse text by commas, spaces, or custom delimiters. Examples with INDEX, ARRAYFORMULA, and TEXTJOIN.

Feb 19, 20267 min read

Can't open a large CSV? Learn 6 methods to handle massive CSV files — from splitting and BigQuery to Python and command-line tools.

Feb 18, 20267 min read

Create dropdown lists, checkboxes, and custom validation rules in Google Sheets. Includes cascading dropdowns and formula-based rules.

Feb 17, 20267 min read

Master Google Sheets conditional formatting with built-in rules, custom formulas, row highlighting, and duplicate detection.

Feb 16, 20269 min read

Learn COUNTIF and COUNTIFS in Google Sheets. Count by text, numbers, dates, wildcards, and multiple criteria with practical examples.

Feb 15, 20265 min read

Fix garbled characters when importing CSV to Google Sheets. Learn UTF-8 encoding, BOM headers, and how to repair special characters.

Feb 14, 20267 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.