CSV Shows é or £ in Excel: Fix UTF-8 Encoding
Seeing é, £ or ’ in a CSV opened in Excel? It is UTF-8 read as the wrong encoding. Import it as UTF-8, understand the BOM and save it back safely.
CSV and Excel problems, phone and postcode normalisation, deduplication and export choices for business lists.
Seeing é, £ or ’ in a CSV opened in Excel? It is UTF-8 read as the wrong encoding. Import it as UTF-8, understand the BOM and save it back safely.
How to deduplicate business leads: which keys to trust in which order, fuzzy name rules, branches and chains, and merge rules that keep evidence and opt-outs.
Stop Excel stripping the 0 from UK phone numbers: import the CSV as text, switch off automatic conversion, repair damaged columns and store numbers as +44.
A field-by-field checklist for cleaning a B2B lead list: names, domains, UK phones, postcodes, emails, status and dedupe keys, ending in a ready-to-send gate.