Dedupe
How to Remove Duplicate Rows in a CSV File
Spot exact and near duplicates. Keep the right row. Export a file with each record once.
RowSift guides
Fix the file before you import it.
Short, plain guides on the CSV problems that break imports. Each one shows the cause, the fix, and a check you can run before you upload.
Want to practice on a real file first? Download a sample CSV of San Francisco food truck permits — real public data, with the blank fields, all-caps statuses, and zero-padded lot numbers left in. Run it through the cleaner and see what changes.
Clean the file
Start with the rows and values. These guides fix what is inside the file.
Phones
How to Clean Up Phone Numbers in a CSV
Numbers land in a dozen shapes. Put each one in a single clean format, and flag the bad rows.
Dates
How to Fix Inconsistent Dates in a CSV
One column, five date formats. Pick one format, convert each row, and check the risky ones by hand.
Codes
Why Leading Zeros Disappear from CSV Files
ZIP codes and SKUs are text, not math. Learn why the zeros drop, and how to keep them safe.
Structure
How to Fix Columns That Shift in a CSV
One bad row can push each value one cell over. Find that row, fix it, and stop the next shift.
Excel
Why Excel Breaks CSV Files
Excel guesses at your data and often guesses wrong. See what it changes, and how to stop it.
Fix the import
Imports fail for plain reasons. These guides work through the causes and the habits that keep a CRM clean.
Imports
Why CRM Imports Fail
Bad headers, duplicate rows, broken values, and shifted columns. Four causes, four fixes, one checklist.
CRM data
Why Duplicate Contacts Keep Coming Back
You cleaned the list last spring. The dupes are back. See where they sneak in, and the routine that stops them.
By platform
Step-by-step prep for the tools you import into, plus the matching RowSift cleaner for each one.
HubSpot
How to Clean a HubSpot Contact List
Fix headers, dedupe by email, and clean phones and dates. Then run a preflight check and import once.
Shopify
How to Prepare a Shopify Product CSV
Titles, SKUs, prices, and stock counts, set up so the upload works the first time.
Tool
HubSpot CSV Cleaner
Normalize emails and phone fields, flag repeat identifiers, and export a cleaner contact file.
Tool
Shopify CSV Cleaner
Check a product file before upload: SKUs, prices, and rows that do not line up.