Data knowledge base
Guides that solve real data problems
Start with the job in front of you. Each guide explains what can go wrong, how to choose a method, and how to check the result before you trust it.
Fix a file that will not open
Find encoding, delimiter, quoting, and spreadsheet-import problems before changing the data.
- Diagnose a Broken CSV Before You Try to Repair It
A methodical way to identify delimiter, encoding, header, quoting, row-shape, and type problems before a CSV reaches Excel, a CRM, or a database.
- Why Won't My CSV File Open in Excel? (7 Fixes)
Troubleshoot CSV files that won't open in Excel. Fix file associations, size limits, corruption, and encoding issues.
- Fix CSV Encoding Issues (UTF-8 Guide)
Fix weird characters in your CSV files. Understand UTF-8 vs ANSI, fix mojibake (), and ensure your data displays correctly everywhere.
- Fix 'EndOfStreamException' and CSV Errors
Troubleshoot common CSV parsing errors like 'Unexpected end of file', 'Invalid column count', and 'Unescaped quote'.
- How to Repair Broken CSV Files
CSV file won't open? Lines shifting? Quotes broken? Learn how to diagnose and repair corrupted CSV files.
Clean and check data
Remove duplicate or empty records, standardize values, and inspect a file before import.
- How to Clean CSV Data Without Hiding the Original Problems
Learn practical techniques to clean messy CSV files. Remove duplicates, fix formatting, and standardize data without Excel crashes or complex scripts.
- How to Remove Duplicates from CSV Files (3 Methods)
Remove duplicate rows from CSV files using Excel, Google Sheets, or specialized tools. Learn when to use exact vs fuzzy matching.
- How to Anonymize CSV Data Without Ruining the Dataset
A practical method for removing or replacing names, emails, IDs, dates, and other identifying fields while preserving useful CSV data.
- Compare Two CSV Files (Find Differences)
How to compare two CSV files to find added, removed, or changed rows. Methods using Excel, command line, and diff tools.
- Find Fuzzy Duplicates in CSV Files
Find near-duplicate rows using similarity matching. Catch typos like 'Jon Smith' vs 'John Smith'. Free online tool.
Merge, split, and reshape
Combine exports safely, divide large files, join on a key, or change the layout.
- How to Merge Multiple CSV Files (The Easy Way)
Combine multiple CSV files into one master file without Excel crashing. Step-by-step guide for merging CSV files with different structures.
- How to Merge CSV Files with Different Headers
Combine CSV files with missing, renamed, or reordered columns without shifting values into the wrong fields. Includes a safe Pandas workflow.
- Join Two CSV Files by ID, Email, or Another Shared Column
Choose the right join type, clean the matching keys, detect duplicate-key row multiplication, and reconcile the result before using it.
- How to Split Large CSV Files (3 Easy Methods)
Split large CSV files that are too big for Excel. Learn how to divide CSV files by row count or column values. Handle files over 1 million rows.
- How to Transpose CSV Data Without Losing the Headers
Swap CSV rows and columns in Excel, Python, or a browser, with practical checks for headers, uneven rows, data types, and file-size limits.
Excel and spreadsheets
Move data between CSV and Excel without losing dates, identifiers, precision, or leading zeros.
- Stop Excel Changing Numbers in CSV Files
Prevent Excel from removing leading zeros, rounding long IDs, and turning codes into dates when you open or import a CSV.
- Convert Excel to CSV (Without Losing Data)
Learn how to convert Excel files to CSV format without losing formatting, formulas, or data. Step-by-step guide with common problem fixes.
- CSV File Size Limits (Excel, Sheets, Databases)
What is the maximum size for a CSV file? Learn the limits of Excel, Google Sheets, and databases, and how to handle files that are too big.
- CSV vs XLSX vs TXT: Which Format to Use?
Compare CSV, XLSX (Excel), and TXT formats. Understand the differences, file size, compatibility, and when to use each for your data.
- Excel vs CSV: Which Should You Actually Use?
Understand the real differences between Excel and CSV files. Learn when to use each format and how to convert between them without losing data.
Databases and code
Prepare CSV data for SQL, SQLite, Pandas, JSON, NDJSON, and Parquet workflows.
- Import CSV to MySQL/PostgreSQL (Step-by-Step Guide)
Learn how to import CSV files into MySQL and PostgreSQL databases. Command-line and GUI methods with error handling and best practices.
- Turn a CSV Into a Reviewable SQLite Import Script
Generate SQLite CREATE TABLE and INSERT statements from CSV, then review types, identifiers, nulls, and quoting before running the script.
- Generate SQL INSERT Statements from CSV
Convert CSV data into SQL INSERT statements. A guide for developers to quickly populate databases from spreadsheet data.
- How to Prepare CSV Files for Python Pandas
Prepare CSV files for reliable pandas imports by making encoding, delimiters, nulls, dates, identifiers, and column types explicit.
- Convert CSV to Parquet and Check the Schema Before You Trust It
A practical guide to converting CSV data to Parquet, preserving identifiers, reviewing inferred types, and validating the result in DuckDB or Python.
Business imports
Prepare exports for ecommerce stores, CRMs, accounting tools, and email platforms.
- How to Prepare Shopify Product CSV (Complete Import Guide)
Learn the exact Shopify CSV format for bulk product imports. Avoid common errors and import your products successfully on the first try.
- Import Products to WooCommerce via CSV
Bulk upload products to WooCommerce using the built-in CSV importer. Handle images, variations, categories, and attributes correctly.
- Import CSV to Salesforce (Step-by-Step Guide)
Learn how to import CSV data into Salesforce using Data Import Wizard and Data Loader. Tips for mapping fields, handling IDs, and avoiding errors.
- Import CSV to HubSpot (Contacts & Companies)
A complete guide to importing contacts, companies, and deals into HubSpot from CSV. Learn how to map properties, handle associations, and fix errors.
- How to Clean Email Lists Before Sending (5-Step Guide)
Clean your email list to improve deliverability and avoid spam complaints. Remove duplicates, validate formats, and fix common issues.
Start from your job
The fastest route is the one that matches what you do all day. Each path chains guides and tools in the order you will actually need them.
For data analysts
Get exports ready for Excel, Pandas, or a database without writing scripts — profile quality, fix types and headers, then hand off clean files.
For marketers
Combine platform exports, clean contact lists, and keep CRM imports from breaking — all before the campaign deadline.
For accountants
Turn bank downloads and ledgers into import-ready files for QuickBooks, Xero, and Excel without retyping a single row.
Ready to work on a file?
Open a focused tool and process a browser-sized file locally on your device.
Browse all tools