Papiral
PixelForge
Tabular
TabularCSV How-To Guides
Practical guides for the most common CSV tasks — each one covers multiple methods including a free browser tool, Excel, and Python with copy-paste code examples.
How to Remove Duplicate Rows from a CSV File
4 methods — browser tool, Excel, Google Sheets, and Python
Duplicate rows are one of the most common CSV problems. They inflate counts, skew analytics, and cause double-imports in CRMs and email tools. Here are four ways to remove them, from fastest to most flexible.
Read guide →How to Convert a CSV File to JSON
3 methods — browser tool, Python, and Node.js
Converting CSV to JSON is a common step when feeding spreadsheet data into a web app, API, or database. The output is a JSON array of objects, where each row becomes an object and each column header becomes a key.
Read guide →How to Split a Large CSV File into Smaller Files
3 methods — browser tool, Python, and command line
Large CSV files cause problems: they crash Excel, time out on imports, and exceed API file size limits. Splitting by row count is the most reliable fix — here's how to do it in three different ways.
Read guide →How to Clean CSV Data
A practical guide to the most common CSV problems and how to fix them
Raw CSV files are rarely ready to use. Exports from CRMs, spreadsheets, and databases almost always contain duplicates, inconsistent formatting, blank rows, and encoding issues. This guide covers the most common problems and how to fix each one quickly.
Read guide →How to Convert CSV to Excel (XLSX) — and Back
3 methods — browser tool, Excel, and Python
CSV and Excel (XLSX) are the two most common spreadsheet formats, but they're not interchangeable. CSV is plain text — no formatting, no formulas, no multiple sheets. XLSX preserves all of that. Here's how to convert between them.
Read guide →How to Convert a CSV File to SQL INSERT Statements
3 methods — browser tool, Python, and SQLite CLI
When you have data in a CSV and need to get it into a SQL database, the cleanest approach is to generate INSERT statements from the CSV rows. Here's how to do it three different ways.
Read guide →How to Sort a CSV File by Column
4 methods — browser tool, Excel, Google Sheets, and Python
Sorting a CSV by a specific column — alphabetically, numerically, or by date — is one of the most common data prep tasks. Here are four ways to do it.
Read guide →How to Validate a CSV File Before Importing
3 methods — browser tool, Python, and csvlint
Importing a CSV with formatting errors can corrupt your data, break your import job, or cause silent failures. Validating before you import takes 30 seconds and saves hours of cleanup. Here's how.
Read guide →How to Open a CSV File in Excel
3 methods — double-click, Import Wizard, and Python
Opening a CSV in Excel sounds simple, but double-clicking often causes problems: dates auto-format incorrectly, leading zeros get stripped, and special characters show as garbage. Here's how to open CSV files in Excel correctly every time.
Read guide →How to Import a CSV File into Google Sheets
3 methods — File Import, Google Drive, and IMPORTDATA formula
Importing a CSV into Google Sheets is straightforward, but there are a few ways to do it and some gotchas to watch out for — especially with auto-formatting dates and numbers. Here's the full breakdown.
Read guide →How to Find and Replace Text in a CSV File
3 methods — browser tool, Excel, and Python
Find and replace in a CSV lets you fix typos, standardize values, update product codes, or swap old values for new ones across an entire file at once. Here are the three most common ways to do it.
Read guide →How to Filter Rows in a CSV File by Column Value
3 methods — browser tool, Excel, and Python
Filtering a CSV means keeping only the rows that match a condition — for example, all customers in a specific state, orders above a certain amount, or records with a particular status. Here's how to do it three different ways.
Read guide →How to Fix CSV Encoding Issues (Garbled Characters)
3 methods — browser validator, Excel Import Wizard, and Python
CSV encoding issues appear as garbled text: accented characters like é or ñ show as ’ or ?, and imports fail with cryptic errors. The root cause is almost always a mismatch between how the file was saved (usually Windows-1252 or Latin-1) and how the receiving system expects it (UTF-8). Here's how to diagnose and fix it.
Read guide →How to Convert a JSON File to CSV
3 methods — browser tool, Python, and Node.js
JSON is the standard format for APIs and web apps, but most spreadsheet tools, databases, and import wizards expect CSV. Converting a JSON array of objects to CSV is straightforward when the JSON is flat — nested objects need a bit more work. Here's how.
Read guide →How to Merge Two CSV Files into One
3 methods — Excel, Python, and command line
Merging CSV files means stacking them vertically (combining rows from two files with the same columns) or joining them horizontally (matching rows from two files by a shared key column). Here's how to do both.
Read guide →How to Change the Delimiter in a CSV File
3 methods — browser tool, Excel, and Python
CSV files use commas by default, but some systems export semicolons, tabs, or pipes instead. If your file's delimiter doesn't match what your import target expects, you'll end up with all data in a single column. Here's how to convert between delimiters.
Read guide →How to Rename Column Headers in a CSV File
3 methods — browser tool, Excel, and Python
Renaming CSV column headers is one of the most common data prep tasks before importing into a CRM, database, or analytics tool. The target system expects specific field names, and your export rarely matches them out of the box.
Read guide →How to Fill Empty Cells in a CSV File
3 methods — browser tool, Excel, and Python
Empty cells in a CSV cause import errors, break formulas, and create data gaps in dashboards. There are two main approaches: fill with a static value (like 'N/A' or 0) or use forward/backward fill to propagate adjacent values. Here's how.
Read guide →How to Transpose a CSV File (Flip Rows and Columns)
3 methods — browser tool, Excel, and Python
Transposing a CSV rotates the data 90 degrees — rows become columns and columns become rows. This is useful when data arrives in a wide format (one row per metric, many columns per time period) but you need it in a long format for analysis, or vice versa.
Read guide →How to Remove Blank Columns from a CSV File
3 methods — browser tool, Excel, and Python
Blank columns are a common byproduct of spreadsheet exports — extra empty columns at the end, columns that once had data but were cleared, or placeholder columns for fields not yet populated. They add noise to imports and clutter database schemas. Here's how to remove them.
Read guide →