Practical Guides

Work through real examples, understand common mistakes and choose the right tool for the task.

• How to Fix Invalid JSON

  A parser error tells you where JSON stopped making sense. Start by locating that error, make the smallest repair, then check the result before reusing it.

• Format JSON Without Losing Large Integers

  Formatting should make a payload readable without changing its identifiers. Test number preservation before using an online formatter on 64-bit database IDs or precise decimal values.

• Convert Semicolon CSV to Comma Safely

  A CSV that opens in one Excel column often uses a different separator from the importer. Convert the table structure with a parser rather than replacing every punctuation mark.

• Compare Excel Files with Reordered Rows

  A useful spreadsheet diff depends on matching the right records. Compare by cell position when row order is stable; choose a key column when records have moved.