HubSpot
- Email (recommended unique ID)
- Or: First name + Last name
- Record ID to update existing records
- CSV, XLSX or XLS
- Max 512 MB per file
- Max 1,048,576 rows
- UTF-8 encoding
- Dates in one consistent format
- Phones with country code (+31…)
Required columns, file limits and value formats for the six imports people struggle with most. Bookmark it, print it, stick it next to your screen.
Clean text, find matches and calculate — without changing your source cells.
Examples use English names with commas, or Dutch names with semicolons. Your separator depends on Excel's regional settings. Put the formula in a new column. ★ Requires Microsoft 365 or Excel 2021+.
=TRIM(A2)Removes leading/trailing spaces and reduces repeated ordinary spaces to one.
" Anas Ali " → "Anas Ali"
=TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," ")))Replaces non-breaking spaces, removes ASCII control characters, then trims. Not every Unicode character is removed.
Non-breaking space + tab → ordinary clean text
=LOWER(TRIM(A2))Normalizes text; does not check whether an email address exists or is valid.
" ANAS@EXAMPLE.COM " → "anas@example.com"
=TEXT(A2,"00000")Formats a number as five-character text. Choose the width your IDs require.
42 → "00042"
=TEXTJOIN(" ",TRUE,A2,B2)Joins names with a space and skips empty cells. Requires Excel 2019 or newer / Microsoft 365.
Anas + Ali → "Anas Ali"
=COUNTIF($A$2:$A$100,A2)>1TRUE means the value appears more than once in this range. Blank cells also count; nothing is deleted.
A2=SKU-01 appears twice → TRUE
=UNIQUE(A2:A100)Returns a separate list; leave the cells below empty for the result to spill.
Red, Red, Blue → Red, Blue
=XLOOKUP(E2,A2:A100,B2:B100,"Not found")Finds E2 in column A and returns the corresponding value from B (exact match by default).
E2=SKU-01 → matching product name
=FILTER(A2:C100,C2:C100="Active","No matches")Returns rows where C contains Active. Keep the output area clear.
Only rows with status Active
=SUM(B2:B100)Adds numeric cells. Numbers stored as text in this range are ignored.
10 + 20 + 30 → 60
=IF(B2>0,"In stock","Out of stock")Returns one value when the condition is true and another when it is false.
B2=12 → In stock
=IFERROR(A2/B2,"Check input")Shows a clear message for errors instead of silently replacing them with zero.
B2=0 → Check input
Result
=LOWER(TRIM(A2))CSV is plain text, not a workbook: no built-in formulas, styles or worksheets.
Name,Email Anas,anas@example.com
Use the delimiter your importer expects. A semicolon is common in Dutch Excel exports.
Name,City Anas,"Amsterdam, Netherlands"
Wrap a field containing the delimiter in double quotes.
Name "Anas ""Ali"""
Inside a quoted field, write a double quote twice.
Name,Note Anas,"Line 1 Line 2"
Quote the entire multiline field. Some importers reject multiline values.
Name,Phone,City Anas,,Amsterdam
Keep the separators so every row has the same number of fields.
= + - @
Spreadsheet apps can execute fields starting with these characters as formulas. Import untrusted data as text; quotes alone do not protect it.
Serialized output
Name,Note "Anas ""Ali""","Amsterdam, Netherlands"
Import Doctor scans your file against these rules in your browser — free, nothing uploaded.
Based on each platform's public import documentation, checked October 2026. Platforms change their rules — when in doubt, check their help pages.