Free cheat sheet

The CSV import cheat sheet

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.

HubSpot

Contacts import
Required
  • Email (recommended unique ID)
  • Or: First name + Last name
  • Record ID to update existing records
File & limits
  • CSV, XLSX or XLS
  • Max 512 MB per file
  • Max 1,048,576 rows
Formats
  • UTF-8 encoding
  • Dates in one consistent format
  • Phones with country code (+31…)
Duplicate emails in one file: only one row is imported.
Check my HubSpot file →

Shopify

Product CSV
Required
  • Handle
  • Title (for new products)
  • Variant rows repeat the same Handle
File & limits
  • CSV only, UTF-8
  • Max 15 MB per file
  • Use Shopify's exact column headers
Formats
  • Prices as 19.99 — no € or $
  • Booleans: TRUE / FALSE
  • Handles lowercase, no spaces
Two different products with the same Handle get merged.
Check my Shopify file →

Salesforce

Data Import Wizard
Required
  • Leads: Last Name + Company
  • Contacts: Last Name
  • Accounts: Account Name
File & limits
  • CSV file
  • Up to 50,000 records per import
  • Bigger: use Data Loader
Formats
  • Dates in your user locale
  • Picklist values must match exactly
  • UTF-8 encoding
A missing required field rejects the whole row.
Check my Salesforce file →

Mailchimp

Audience import
Required
  • Email Address
  • One contact per row
  • Permission to email them
File & limits
  • CSV or TXT file, or paste
  • Header row recommended
  • Tags can be added during import
Formats
  • Valid email syntax
  • No spaces or double @
  • Dates as MM/DD/YYYY or DD/MM/YYYY — pick one
Invalid or role addresses (info@) may be skipped.
Check my Mailchimp file →

Klaviyo

Profiles to a list
Required
  • Email or Phone Number
  • Header row with column names
  • Consent fields for SMS
File & limits
  • CSV file
  • Map columns to properties
  • Custom columns become properties
Formats
  • Phones in E.164: +31612345678
  • UTF-8 encoding
  • Booleans true / false
Phones without country code fail for SMS.
Check my Klaviyo file →

Golden rules for every import

  1. 1Save as CSV UTF-8 — not 'CSV (Macintosh)' or ANSI
  2. 2Exactly one header row, no title rows above it
  3. 3No merged cells, no blank rows in the middle
  4. 4Keep leading zeros: format IDs/postcodes as text
  5. 5One value per cell — split 'Full name' if needed
  6. 6Remove duplicates before, not after, the import

Excel formula cheat sheet

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+.

Remove extra spaces

=TRIM(A2)

Removes leading/trailing spaces and reduces repeated ordinary spaces to one.

See example

" Anas Ali " → "Anas Ali"

Clean imported text

=TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," ")))

Replaces non-breaking spaces, removes ASCII control characters, then trims. Not every Unicode character is removed.

See example

Non-breaking space + tab → ordinary clean text

Normalize email case

=LOWER(TRIM(A2))

Normalizes text; does not check whether an email address exists or is valid.

See example

" ANAS@EXAMPLE.COM " → "anas@example.com"

Preserve leading zeros

=TEXT(A2,"00000")

Formats a number as five-character text. Choose the width your IDs require.

See example

42 → "00042"

Join first and last name

=TEXTJOIN(" ",TRUE,A2,B2)

Joins names with a space and skips empty cells. Requires Excel 2019 or newer / Microsoft 365.

See example

Anas + Ali → "Anas Ali"

Flag duplicate values

=COUNTIF($A$2:$A$100,A2)>1

TRUE means the value appears more than once in this range. Blank cells also count; nothing is deleted.

See example

A2=SKU-01 appears twice → TRUE

List unique values★

=UNIQUE(A2:A100)

Returns a separate list; leave the cells below empty for the result to spill.

See example

Red, Red, Blue → Red, Blue

Look up an ID★

=XLOOKUP(E2,A2:A100,B2:B100,"Not found")

Finds E2 in column A and returns the corresponding value from B (exact match by default).

See example

E2=SKU-01 → matching product name

Filter matching rows★

=FILTER(A2:C100,C2:C100="Active","No matches")

Returns rows where C contains Active. Keep the output area clear.

See example

Only rows with status Active

Add a column

=SUM(B2:B100)

Adds numeric cells. Numbers stored as text in this range are ignored.

See example

10 + 20 + 30 → 60

Check a condition

=IF(B2>0,"In stock","Out of stock")

Returns one value when the condition is true and another when it is false.

See example

B2=12 → In stock

Handle a calculation error

=IFERROR(A2/B2,"Check input")

Shows a clear message for errors instead of silently replacing them with zero.

See example

B2=0 → Check input

Formula playground

Result

"anas@example.com"
=LOWER(TRIM(A2))

CSV syntax cheat sheet

CSV is plain text, not a workbook: no built-in formulas, styles or worksheets.

Separate fields

Name,Email
Anas,anas@example.com

Use the delimiter your importer expects. A semicolon is common in Dutch Excel exports.

Quote a delimiter

Name,City
Anas,"Amsterdam, Netherlands"

Wrap a field containing the delimiter in double quotes.

Escape double quotes

Name
"Anas ""Ali"""

Inside a quoted field, write a double quote twice.

Keep line breaks inside a field

Name,Note
Anas,"Line 1
Line 2"

Quote the entire multiline field. Some importers reject multiline values.

Empty is still a field

Name,Phone,City
Anas,,Amsterdam

Keep the separators so every row has the same number of fields.

Avoid formula injection

=  +  -  @

Spreadsheet apps can execute fields starting with these characters as formulas. Import untrusted data as text; quotes alone do not protect it.

CSV playground

Serialized output

Name,Note
"Anas ""Ali""","Amsterdam, Netherlands"

Don't want to check all this by hand?

Import Doctor scans your file against these rules in your browser — free, nothing uploaded.

Scan my file free

Based on each platform's public import documentation, checked October 2026. Platforms change their rules — when in doubt, check their help pages.