Practical spreadsheets and data
CSV dates are wrong in Excel: fix swapped days and months
Import CSV dates with the source locale, distinguish parsing from display formatting, and verify day/month order with a three-record check.
Read the guide →coru / Field notes
Practical spreadsheets and data
Useful ideas. Room to explore.
Practical spreadsheets and data
Import CSV into Excel without losing leading zeros or ID digits
Keep product codes and long IDs intact when importing CSV into Excel for Windows. A three-line sample checks text types, UTF-8 and delimiters.
Read the guide →Practical spreadsheets and data
Excel will not sum CSV numbers: convert text with the right separators
Fix CSV amounts stored as text in Excel. Choose source decimal separators, preserve IDs, and verify four rows with a count and total.
Read the guide →Practical spreadsheets and data
CSV opens in one column or shows garbled text in Excel: fix the import
Choose the right delimiter, encoding and number locale in Excel. Two small CSV examples check quoted commas, line breaks, Cyrillic and decimal commas.
Read the guide →