CSV & Excel, explained simply

Troubleshooting

Why does my CSV look wrong when I open it in Excel?

Encoding, delimiters, and Excel's auto-formatting explained — and how to avoid the mess entirely.

Basics

CSV vs. XLSX: what's actually the difference?

Two formats that look similar but behave very differently. Here's when to use each.

How-to

How to convert CSV to Excel without losing data

Leading zeros, long numbers, and dates are the usual casualties. Here's how to keep them intact.