Why did my CSV upload fail?

If your CSV upload failed during directory import, check for these common issues:

File format problems:

• The file must be in CSV format (.csv), not Excel (.xlsx or .xls). If you created the file in Excel, use "Save As" and select "CSV (Comma delimited)."
• The file encoding should be UTF-8. Other encodings may cause special characters (e.g., Filipino names with accents) to display incorrectly.

Column header issues:

• Column headers must match the expected template exactly. Download the template from the import page and use those headers.
• Extra columns are ignored, but missing required columns will cause a failure.

Data validation errors:

• Missing required fields — First name and last name (for persons) or company name (for organizations) are mandatory.
• Invalid bank codes — Bank codes must match the supported list. Use the bank code, not the bank name (e.g., "BDO" not "Banco de Oro").
• Invalid account numbers — Account numbers should contain only digits and be the correct length for the specified bank.
• Duplicate rows — Rows with identical email addresses or account numbers may be flagged.

File size:

• Maximum 500 rows per upload. Split larger files into multiple batches.
• Maximum file size is 5 MB.

If the upload partially succeeds, you will see a summary showing which rows were imported and which were skipped. Fix the skipped rows and re-upload them separately.