Import CSV Into Google Sheets Cleanly
Upload CSV without broken dates and split columns — import settings, SPLIT, and TRIM pass before VLOOKUP or pivots.
SheetLab · spreadsheet docs
SheetLab
Copy-paste formulas, pivot-table walkthroughs, and template builds for Excel and Google Sheets — written like internal documentation, not marketing fluff.
Start here
Three tutorials that cover lookup formulas, summaries, and a sheet you can reuse every month.
Protect Formulas While Still Editing Inputs
Lock formula cells and unlock input ranges so coworkers can edit Actuals or Qty without breaking SUM and VLOOKUP rows.
Conditional Formatting for Deadlines
Highlight due dates that are overdue, due today, or due this week using formula rules — Excel and Google Sheets steps.
Topics
Formulas, pivots, templates, and data cleanup.