Blog

Excel silently corrupts CSV data in at least 5 ways. This article shows each problem with examples and explains how to prevent them.

CSV is universal and small; XLSX preserves tricky values like leading zeros and long IDs. This is when to use each, and how nested JSON is flattened in both.

A VCF file is a vCard contact file. Here is how to open and read one, and how to turn it into a clean spreadsheet without losing any phone numbers or emails.

Turn the GST portal GSTR-2B JSON into Excel, then reconcile ITC against your purchase register. Covers the sheets you get, key columns, and the formulas to use.