Spreadsheets
Why Your CSV Uses Semicolons, Not Commas
Excel saves CSV files with semicolons when your region writes decimals with a comma. Here's why, how to open them correctly and how to get commas back.
PuffinKit blog
Practical guides to everyday document and data work, with clear steps, worked examples and the sources behind every fact.
Articles
Spreadsheets
Open a CSV Without Breaking IDs or Dates
Double-clicking a CSV can turn long IDs into 1.23E+15, drop leading zeros and misread dates. Here's how to open one safely in Excel and Google Sheets.