How to Combine Data from Multiple Sources
Combine data from CSV, Excel, JSON and app exports: pick a join key, standardize formats, handle mismatches, and prepare one clean dataset with Plumb.
Data Cleaning
Step-by-step fixes for everyday spreadsheet and CSV problems: duplicates, dates, missing values, merges and more.
How to Convert JSON to CSV (Including Nested JSON)
Convert JSON to CSV with Excel Power Query, Python pandas or jq, flatten nested objects and arrays, and extract clean tables automatically with Plumb.
How to Validate Data Before Sending a Report
A pre-send data validation checklist: row counts, totals, duplicates, blanks, date ranges and reconciliation, plus automated data quality checks with Plumb.
How to Find Unusual Values in Your Dataset
Find outliers and unusual values with conditional formatting, z-scores and the IQR method, and how AI anomaly detection catches patterns rules miss.
How to Standardize Column Names in Excel
Standardize Excel column headers into a consistent naming convention like snake_case, remove spaces and symbols, and map synonyms across files with Plumb.
How to Clean a Large CSV File Without Excel Crashing
Excel stops at 1,048,576 rows. Learn how to clean large CSV files with Power Query, Python chunking or DuckDB, or let Plumb process them without loading everything into memory.
How to Identify Errors in Your Spreadsheet
Find spreadsheet errors fast: formula errors, broken references, hard-coded numbers, type mismatches and outliers, plus how automated data auditing catches them.
How to Merge Multiple Excel Files into One
Merge multiple Excel files into one sheet using Power Query, copy-paste or Python, handle mismatched columns, and let Plumb align and combine them automatically.
How to Find Missing Values in a CSV File
Find missing values in a CSV with Excel, Python pandas or an AI data quality audit, including hidden blanks like 'N/A', 'null' and whitespace.
How to Fix Inconsistent Date Formats in Excel
Fix mixed date formats in Excel: spot dates stored as text, convert with DATEVALUE and Text to Columns, resolve DD/MM vs MM/DD, and automate it with Plumb.
How to Remove Duplicate Rows in Excel (and Catch the Near-Duplicates)
Remove exact duplicate rows in Excel with Remove Duplicates, COUNTIFS or UNIQUE, and find near-duplicates that Excel misses using AI duplicate detection.
How to Clean Messy Excel Data (Step by Step)
A practical checklist for cleaning messy Excel data: trim spaces, fix types, remove duplicates, standardize values, and how AI data cleaning does it in one pass.