Guides
The question behind a conversion is rarely how to click convert. It is what this will do to the data. These answer that at length.
All guides
- How to Create a CSV FileFour ways to make one, and the three settings that decide whether it opens correctly.
- How to Open a JSON FileWhat to open one with, and how to read a big one without scrolling forever.
- How to Convert CSV to JSON, and What Happens to Your Data TypesWhat happens to your data types when a flat CSV becomes structured JSON.
- Excel to CSV: What You Lose and How to Avoid SurprisesFormulas, formatting, sheets and dates: what a CSV export leaves behind.
- Why Your CSV Opens Wrong in ExcelEncoding, BOM and delimiters: the three reasons a valid CSV opens as nonsense.
- Extracting Tables From PDFs: What Works and What Does NotWhy PDF table extraction works sometimes and fails completely other times.
- JSON vs JSON Lines: When to Use EachOne is a document, the other is a log. When each is the right choice.
- CSV vs TSV vs Excel: Choosing a Format for Data ExchangeChoosing a format to hand someone else, and what each one costs.
- How to Merge Multiple CSV Files Without a ScriptCombining several exports into one without silently shifting your columns.
- Markdown Tables: Syntax, Alignment, and Common MistakesSyntax, alignment, escaping and the three things Markdown tables cannot do.
- Generating SQL INSERT Statements From a SpreadsheetTurning rows into INSERT statements, and the escaping that has to be right.
- How to Split a Large CSV FileCutting a file that is too big, and keeping every part valid on its own.