Preserve leading zeros in Calc by setting ID columns to Text during CSV import, checking the preview, and verifying the saved data.