The HappyCSV journal
Useful answers for messy data.
Tutorials, guides, and practical workflows to help you move data with confidence.
Fix CSV errors
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.
CSV Delimiters Explained (Comma, Tab, Semicolon)
Why do some CSVs use semicolons? What is a delimiter? Learn about commas, tabs, pipes, and how to handle different CSV formats.
Clean and validate
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.
Find Fuzzy Duplicates in CSV Files
Find near-duplicate rows using similarity matching. Catch typos like 'Jon Smith' vs 'John Smith'. Free online tool.
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 and Replace in CSV Files (Bulk Edit Guide)
How to find and replace text across large CSV files. Learn methods for Excel, text editors, and specialized tools to bulk edit your data.
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.
Merge, split, and reshape
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.
Merge CSV Files in Order by Date
How to merge multiple CSV files and ensure the final result is sorted chronologically. Avoid messy, unsorted data dumps.
Merge Mailchimp Exports (Email Marketing Guide)
How to combine multiple Mailchimp CSV exports into one master list. Clean duplicates, merge tags, and prepare for re-import.
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.
How to Combine Facebook Lead Reports (The Fast Way)
Merge multiple Facebook lead export files into one master list. Step-by-step guide for marketers dealing with monthly or campaign-based lead downloads.
Excel and spreadsheets
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.
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.
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.
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.
How to Open a CSV File Without Damaging the Data
Choose the right way to inspect, import, edit, or query a CSV while protecting leading zeros, dates, encoding, and the original file.
How to Create a CSV File (3 Easy Methods)
Learn how to create CSV files using Excel, text editors, or code. A step-by-step guide for beginners and developers.
What is a CSV File? (Simple Explanation)
Learn what CSV files are, why they're useful, and how they differ from Excel. Simple guide for beginners with real examples.
Conversions and development
Convert JSON to CSV (Developer's Guide)
Convert JSON records to CSV while making deliberate choices about nested objects, arrays, missing keys, and column structure.
Convert CSV to JSON (Complete Guide with Examples)
Learn how to convert CSV files to JSON format. Handle nested objects, arrays, and complex transformations with practical examples.
Convert CSV to NDJSON (JSON Lines) Without Losing Record Boundaries
Turn CSV rows into newline-delimited JSON, understand type and null handling, and validate the result before using it in an API or data pipeline.
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.
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.
Convert CSV Coordinates to GeoJSON Without Swapping Latitude and Longitude
A practical CSV-to-GeoJSON workflow with coordinate checks, a worked example, and fixes for the mistakes that put points in the wrong place.
Convert a CSV Event List to ICS Without Shifting the Times
Prepare spreadsheet events for calendar import, handle dates and time zones safely, and check the ICS file before adding it to Google, Outlook, or Apple Calendar.
Convert a Contact CSV to VCF Without Mangling Names or Phone Numbers
Map spreadsheet contacts to vCard fields, preserve international phone numbers, test the VCF, and import it safely into iPhone, iCloud, Google Contacts, or Outlook.
Generate SQL INSERT Statements from CSV
Convert CSV data into SQL INSERT statements. A guide for developers to quickly populate databases from spreadsheet data.
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.
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.
Business imports
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 Transactions to QuickBooks Online
How to import bank transactions into QuickBooks Online using CSV files. Format your dates and amounts correctly to avoid 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.
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.
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.
More guides and references
CSV Line Endings: CRLF vs LF (and Why Imports Complain)
Windows CRLF, Unix LF, and old Mac CR line endings explained — how mixed endings break row counts, and how to normalize a CSV before importing.
Looking for a CSVJSON Alternative? A Privacy-First Option
Comparing CSVJSON-style converter tools with HappyCSV: privacy, file size limits, batch processing, and which tool fits JSON-to-CSV, CSV-to-JSON, and SQL workflows.
Fixed-Width vs CSV: What Fixed-Column Files Are and How to Convert
Fixed-width files explained: columns defined by character positions instead of delimiters, where they still appear, and how to convert them to CSV safely.
HappyCSV vs Excel Power Query: Which One for CSV Cleanup?
Power Query is powerful but heavy for quick CSV cleanup. Compare effort, learning curve, privacy, and repeatability against browser-based HappyCSV tools.
What Is a BOM in CSV Files? (Byte Order Mark)
The UTF-8 BOM explained: what those invisible bytes at the start of a CSV do, when they help Excel, and how they break headers, scripts, and JSON parsers.
What Is a CSV Header Row? Conventions and Fixes
The header row explained: first-row conventions, duplicate and empty header problems, case sensitivity, and how to repair headers before any import.
What Is a Flat File? CSV, TSV, and Delimited Data Explained
Flat files defined simply: rows and columns in plain text, how they differ from spreadsheets and databases, when to use CSV vs TSV vs fixed-width.
CSV Quoting and Escaping Explained Simply
Why quotes appear around CSV fields, how embedded commas are escaped, doubled-quote rules, and how broken quoting corrupts rows during import.
What Is UTF-8 Encoding? A Plain-Language Guide
UTF-8 explained for data workers: why encodings exist, where mojibake like 'José' comes from, and how to detect and fix encoding in CSV files.