Engineering Guides

Practical Text, Encoding & AI Guides

Clear technical guides on TOON LLM token reduction, fixing garbled Excel UTF-8 CSVs, CJK encoding rescue, RAG Markdown extraction, JSONL datasets, and zero-upload privacy.

3 min read

TOON vs JSON: Cutting LLM Prompt Token Cost by 30–60%

See how Token-Oriented Object Notation (TOON) eliminates repeated JSON keys in uniform arrays to cut GPT-5, Claude 4, and Gemini 2.5 prompt costs.

JSON to TOONTOON to JSONLLM Token Counter
3 min read

Why Excel Garbles UTF-8 CSVs — and How UTF-8 BOM Fixes It

Stop Microsoft Excel from turning Chinese, Japanese, Korean, Spanish, and German CSV text into mojibake by adding a 3-byte UTF-8 BOM locally.

Fix CSV Encoding for ExcelXLSX to CSVJSON to CSV
3 min read

Fixing GBK, Big5, Shift-JIS & EUC-KR Garbled Text Locally

Diagnose and repair garbled Chinese, Japanese, and Korean text files (GBK, GB18030, Big5, Shift-JIS, EUC-KR) to clean UTF-8 without uploading.

GBK to UTF-8Fix CSV Encoding for ExcelCRLF to LF
2 min read

Preparing PDF, Word & Excel as Clean Markdown for RAG & LLMs

Turn confidential PDFs, Word DOCX docs, and Excel sheets into structured Markdown for vector chunking and LLM context—100% locally.

PDF to MarkdownWord to MarkdownExcel to Markdown
2 min read

JSON vs YAML vs TOML vs .env: Config Format Field Guide

Compare JSON, YAML, TOML, and .env configuration formats across comments, nesting, secret safety, and tool ecosystems—and convert locally.

YAML to JSONJSON to YAMLTOML to JSON
3 min read

Building Valid JSONL Fine-Tuning Datasets from CSV & JSON

Format valid OpenAI chat, Alpaca, and Gemini fine-tuning .jsonl files from spreadsheets and JSON arrays locally with per-line validation.

CSV to JSONLJSON to JSONLLLM Token Counter
2 min read

SRT vs WebVTT vs ASS: Subtitle Conversion & Sync Guide

Learn the exact timestamp rules for SRT, WebVTT, and ASS/SSA subtitles—convert formats, clean rolling captions, and fix audio sync locally.

SRT to VTTVTT to SRTASS to SRT
2 min read

Stripping AI Markdown Symbols for Word, Email & Clean Docs

Remove raw **bold**, ### headings, and code fences from AI responses—or convert Markdown to Rich Text HTML ready for Word, Docs, and Gmail.

Remove AI MarkdownMarkdown to HTMLRemove Line Breaks
2 min read

Generating TypeScript, Zod & Pydantic v2 Schemas from JSON

Turn API JSON samples into strict TypeScript interfaces, runtime Zod validators, and Python Pydantic v2 BaseModels with optional & alias inference.

JSON to TypeScriptJSON to ZodJSON to Pydantic
2 min read

Merging & Splitting Large CSV Files Locally Without Crashing Excel

Combine multi-file CSV exports by column header name or split oversized sheets into clean chunks with repeated headers and ZIP export locally.

Merge CSV FilesSplit Large CSVFix CSV Encoding for Excel
2 min read

Converting EPUB Ebooks to Markdown for Obsidian & AI Study

Unpack DRM-free EPUB ebooks locally into linked Obsidian Markdown notes or split chapter ZIPs—preserving headings, links, and clean prose.

EPUB to MarkdownEPUB to TXTLLM Token Counter
3 min read

Why Server-Side Paste Tools Leak Secrets — Zero-Upload Architecture

Learn why pasting .env files, JWTs, customer CSVs, or contracts into cloud converters leaks data—and how to verify 0 bytes uploaded locally.

.env to JSONBase64 & JWT DecoderJSON Formatter
3 min read

How to Anonymize Text, Contracts & Logs for ChatGPT Locally

Replace names, IBANs, contracts, and secrets with reversible [[TYPE-NN]] tokens locally in browser RAM before pasting prompts into ChatGPT or Claude.

Anonymize Text for AIPII RedactorAnonymize Contract for ChatGPT
3 min read

How to Mask CSV & JSON Customer Data Before AI Analysis

Anonymize sensitive CSV columns, scale financial revenue proportionally (×k), and mask nested JSON keys locally in browser RAM without breaking file syntax.

Mask CSV DataMask JSON Sensitive DataAnonymize Financial Text
4 min read

XML to JSON: Preserving Attributes, CDATA & RSS Feeds

Convert XML, RSS, and SVG files to JSON in browser RAM while preserving @_ attributes, CDATA text, numeric types, and round-trip XML structure.

XML to JSONJSON to XMLJSON Formatter
4 min read

HTML to Markdown vs. Strip HTML Tags: Cleaning Web Text Locally

Learn when to convert HTML to structured GFM Markdown or strip tags to plain text—removing nav clutter, scripts, and HTML entities offline.

HTML to MarkdownStrip HTML TagsMarkdown to HTML
4 min read

TXT, TSV & CSV to SQL: Clean Database Import Workflow

Turn whitespace or pipe-delimited TXT and TSV logs into RFC 4180 CSV, infer SQL column types, and generate batched PostgreSQL, MySQL, or SQLite SQL.

TXT to CSVTSV to CSVCSV to SQL
4 min read

Markdown to PDF & PDF to TXT: Clean Offline Document Workflows

Export Markdown runbooks to A4 or Letter PDFs with CJK font support, and extract clean unwrapped TXT or Markdown from local PDFs via PDF.js.

Markdown to PDFPDF to TXTPDF to Markdown
4 min read

Deduplicating Lists, Extracting Contacts & Normalizing Case Locally

Clean messy CRM lists and log dumps in browser RAM: remove duplicate lines, extract deduplicated emails and URLs to CSV, and standardize identifier case.

Remove Duplicate LinesExtract Emails & URLsCase Converter
4 min read

Offline JWT Decoding, Base64URL & Semantic JSON Diffing

Inspect JWT headers and claims, encode Base64URL without padding, run key-order-agnostic semantic JSON diffs, and scrub Bearer tokens offline.

Base64 & JWT DecoderDiff CheckerJSON Formatter

Built for zero-upload local workflows

Every guide walks through real syntax, byte encodings, and working code snippets paired with a 100% client-side TxtTo tool.

Browse all 58 tools · All 24 formats · See how TxtTo compares