CSV import checks

1. Required columns present

Your CSV must have at least two columns: a contact name and a phone number. Everything else (email, business name, source, monthly value, notes) is optional.

2. Phone number format

MICROLEVEL accepts 10-digit Indian mobile numbers in any of these formats:

• 9876543210 (bare 10 digits)
• +919876543210 (with country code)
• 919876543210 (with country code, no +)
• 98765-43210 (spaces / dashes stripped automatically)

Numbers that fail to parse after normalisation are flagged in the preview step — they are not imported.

3. Duplicate count within the file

Run a quick duplicate check on the phone column before uploading:

# count rows per phone (column B in TeleCRM export)
awk -F',' 'NR>1 {print $2}' your_export.csv \
  | sort | uniq -c | sort -rn | head -20

Duplicates inside the file are collapsed on import (first occurrence wins, later duplicates are skipped and counted in the result).

4. Blank rows and empty cells

Fully blank rows are dropped automatically. Rows where the required contact name or phone is empty will be flagged in the preview and excluded from the import.

5. Encoding (TeleCRM / Google Sheets exports)

Use UTF-8 encoding. If names contain Gujarati / Devanagari characters that appear as mojibake, re-export from your source tool with UTF-8 explicitly selected.

6. Use the in-app preview first

When you reach the Import screen, MICROLEVEL shows a preview with:

• Detected column mapping — click to remap if a column is pointing to the wrong field
• Row-by-row validation result (valid / error / duplicate)
• A skipped-rows count so you know exactly how many will be imported vs. skipped

Confirm the mapping looks correct before clicking Import.