Same issue tbh. I use clay as a staging layer and do all enrichment and clean up there before pushing to the CRM.
Formula columns to standardise, claygent to fill gaps and conditions to flag incomplete rows.
Only push once it meets a quality bar like verified emails, clean data and key fields filled. Keeps the CRM tidy.
Spreadsheets fall apart at this scale anyway, clay handles it much better.