Category
Text & Data Files
Markdown, JSON, CSV, YAML, XML, TOML, INI, .env and log files: what they are, how to open and edit them, and how to fix the syntax errors that break them.
50 posts
Line Endings Explained: LF vs CRLF and Why Files Look Broken
Why a text file shows everything on one line or ^M characters: how LF, CRLF and CR line endings differ across Windows, macOS and Linux, and how to convert them.
Text File Encodings Explained: UTF-8, UTF-16, ANSI and the BOM
Why text files show strange characters: how UTF-8, UTF-16 and Windows code pages differ, what a byte order mark does and how to fix encoding problems.
How to Search Log Files Effectively: grep, Find and Filters
Practical techniques for finding the right line in a log: search by level, ID and time, use context, exclude noise and combine filters with grep or an editor.
Plain Text vs Rich Text Files: .txt, .rtf, .md and .docx Compared
Understand the difference between plain text (.txt), rich text (.rtf), Markdown (.md) and Word (.docx) files, what each can hold and when to use each.
How to Open Large Log Files Without Crashing Your Editor
Normal editors choke on log files of hundreds of megabytes. Learn how to open, view and search huge .log files safely, including command-line options.
Log Levels Explained: DEBUG, INFO, WARN, ERROR and FATAL
What each log level means, how severity filtering works, how to choose a level in production, and what the level names look like in different logging systems.
What Is a Log File? How to Read One and What to Look For
A log file is a time-ordered text record of what a program did. Learn what .log files contain, how to read them and how to find the line behind a problem.
.env Files for Development, Staging and Production: Naming and Precedence
How .env, .env.local, .env.development and .env.production work, which one wins, and how to manage configuration across environments without leaking secrets.
How to Keep .env Files Out of Git (and What to Do if You Leaked One)
Add .env to .gitignore before the first commit, commit a .env.example instead, and rotate any secret that reached the repository. A step-by-step guide.
.env File Syntax: Quotes, Comments, Spaces and Multiline Values
The rules for writing .env files: KEY=value format, quoting, comments, spaces, variable expansion and the differences between dotenv implementations.
What Is a .env File? Environment Variables for Your App
A .env file stores environment variables as KEY=value lines so an app can read its settings and secrets. Learn what dotenv files are and how they work.
How to Edit INI Files Safely (Without Breaking Your Settings)
Back up first, use a plain-text editor, keep the encoding and line endings, avoid duplicates and test after each change. A safe workflow for editing .ini files.
INI File Syntax: Sections, Keys, Values and Comments
A practical guide to INI syntax: section headers, key=value pairs, comments, quoting, duplicates and the dialect differences that cause settings to be ignored.
What Is an INI File? Format, Uses and How to Edit One
An INI file stores settings as sections and key=value lines. Learn what .ini files are, where Windows and other software use them, and how to open them.
TOML Syntax Guide: Tables, Arrays, Inline Tables and Dates
A practical TOML syntax reference covering keys, strings, tables, arrays of tables, inline tables, dates and the errors that make a file invalid.
TOML vs YAML vs JSON for Configuration Files: How to Choose
Comparing TOML, YAML and JSON for config files: readability, comments, safety, nesting, tooling and the situations where each one is the best choice.
What Is a TOML File? A Beginner's Guide to the Config Format
TOML is a configuration file format designed to be obvious to read. Learn what a .toml file is, its basic syntax, where it is used and how to edit one safely.
XML Special Characters, Entities and CDATA Sections Explained
How to include &, <, > and quotes in XML safely using entity references, character references and CDATA, and the errors that result when you do not.
XML Well-Formed vs Valid: What Is the Difference?
Well-formed XML follows the syntax rules; valid XML also conforms to a schema. Learn the rules, the common errors and how DTD, XSD and RELAX NG fit in.
How to Open and Read XML Files on Any Device
Open an XML file in a text editor or browser, format it for reading and find the line that makes it fail to parse. Works on Windows, Mac and phones.
What Is an XML File? Structure, Uses and Examples
XML is a text format that describes data with nested tags. Learn what an .xml file contains, where XML is used, and how it differs from HTML and JSON.
YAML Configuration File Best Practices for Readable, Safe Config
Practical rules for writing YAML config: consistent indentation, quoting, comments, anchors, secrets, validation and structure that other people can maintain.
YAML Gotchas: The Norway Problem, Version Numbers and Other Surprises
Why a country code becomes false and 1.10 becomes 1.1: YAML's implicit typing explained, with the values most likely to be misread and how to quote them.
YAML Multiline Strings: Literal, Folded and Chomping Indicators Explained
How to write multiline text in YAML. The literal and folded block styles, the strip and keep chomping indicators, and when to use quoted strings instead.
How to Fix YAML Indentation Errors and "Mapping Values" Messages
Decode YAML errors such as "mapping values are not allowed here" and "did not find expected key". Fix tabs, misaligned lists, missing spaces and bad nesting.
What Is a YAML File? Syntax, Uses and How to Open One
A YAML file stores structured data in a readable, indentation-based format. Learn the syntax, where .yml and .yaml files are used and how to edit them safely.
CSV vs XLSX: Which File Format Should You Use?
CSV is simple and universal; XLSX holds formulas, formatting and multiple sheets. Compare size, compatibility, data integrity and when each is the right choice.
How to Validate a CSV File Before You Import It
Catch ragged rows, unclosed quotes, wrong delimiters and encoding problems before an import fails. A step-by-step CSV validation checklist.
CSV Quoting and Escaping Rules: Commas, Quotes and Line Breaks
How CSV handles commas, double quotes and line breaks inside values, based on RFC 4180, plus the common mistakes that split rows in the wrong place.
Why Excel Ruins CSV Data: Lost Leading Zeros, Mangled Dates and Big Numbers
Open a CSV in Excel and zip codes lose zeros, dates flip and long IDs turn to scientific notation. Why it happens and how to import safely.
Fix Garbled Characters in CSV Files: Encoding Problems Explained
Accented letters turning into symbols in a CSV? That is an encoding mismatch. Learn UTF-8 vs ANSI, the byte order mark and how to open the file correctly.
CSV vs TSV vs Tab-Delimited Files: What Is the Difference?
CSV uses commas, TSV uses tabs, and .tab files vary. Learn the differences, when tab-delimited files are safer and how to detect which delimiter a file uses.
How to Open a CSV File Without Excel (Free Options)
You do not need Excel to open a CSV. Use a free spreadsheet, a text editor, your browser or a phone app. Here is how, and how to avoid the data-mangling traps.
What Is a CSV File? A Plain-English Guide
A CSV file stores a table as plain text, with values separated by commas. Learn how CSV works, what it can and cannot hold, and where you will use one.
JSON vs XML: Which Data Format Should You Use?
JSON and XML both carry structured data, but they differ in size, readability, schema support and tooling. A practical comparison and when to choose each.
Comments in JSON: JSONC, JSON5 and JSON Lines Explained
Standard JSON has no comments. Learn why, and what JSONC, JSON5 and JSON Lines add, which tools accept them, and how to avoid portability problems.
How to Format and Pretty-Print JSON (and When Not To)
Format minified JSON into readable, indented text. Learn how pretty-printing works, the options you have, and the cases where changing whitespace matters.
JSON vs YAML: Differences, Syntax and Which to Choose
JSON and YAML both store structured data, but they suit different jobs. Compare syntax, comments, readability, safety and when to pick each.
How to Fix Invalid JSON: The 8 Most Common Errors
Fix "Unexpected token" and parse errors. The eight causes of invalid JSON, from trailing commas and single quotes to comments and unescaped characters.
How to Open a JSON File on Windows, Mac, Android and iPhone
JSON files open in any text editor. Learn the easiest way to read, format and edit a .json file on every device, plus what to do when it will not open.
What Is a JSON File? Structure, Uses and How to Read One
A JSON file stores data as text using objects, arrays, strings, numbers, booleans and null. Learn what JSON is, where it is used, and how to read a .json file.
10 Common Markdown Mistakes and How to Fix Them
The ten Markdown errors that cause broken lists, missing line breaks, vanished tables and mangled links, with a quick fix for each.
Markdown Links and Images: Inline, Reference and Relative
How to write links and images in Markdown: inline and reference styles, relative paths, titles, alt text and the mistakes that break them.
How to Write a README.md That Gets Read
A good README.md answers who the project is for, how to start and where to get help. Learn a structure that works, plus what to leave out.
How to Convert Markdown to PDF: Four Reliable Methods
Four ways to turn a Markdown file into a PDF: in the browser, with Pandoc, from a code editor, or by printing HTML. Learn the trade-offs of each method.
How to Write Tables in Markdown (With Alignment and Escaping)
Learn the pipe-and-dash syntax for Markdown tables, how to align columns, escape pipes, handle line breaks in cells, and fix tables that will not render.
How to Open and Edit .md Files on Android
Android has no built-in Markdown viewer, so .md files often fail to open. Here is how to open, read and edit Markdown files on an Android phone or tablet.
Markdown Flavors Explained: CommonMark, GFM and Why They Differ
Why does Markdown render differently between apps? Learn how CommonMark, GitHub Flavored Markdown and other variants differ, and how to write portable files.
Markdown Syntax Cheat Sheet: Every Element You Need
A practical Markdown cheat sheet covering headings, emphasis, lists, links, images, code, quotes, tables and task lists, with the pitfalls that trip people up.
What Is a Markdown (.md) File and How Do You Open One?
A Markdown file is plain text with light formatting symbols. Learn what .md files are, how they differ from Word files, and how to open and edit one anywhere.