How to properly format a CSV file

Overview

Properly formatted CSV's require a comma ( , ) delimiter.

All text data (any field that is not an integer only, e.g., names, emails, dates, etc.) should be quoted to avoid import error.

Include a first row of field names. You can name these fields whatever you like and then map them to system fields at import. However, the system can auto detect and assign the columns for you if you use the predefined field names. If you do not select any field names for a column the import will fail.

PhishingBox will auto detect the following field names, as well as their maximum allowed character sizes:

• address_one (150 characters)
• address_two (150 characters)
• city (60 characters)
• company (255 characters)
• country (65 characters)
• department (100 characters)
• email (255 characters)
• employee_id (255 characters)
• first_name (64 characters)
• is_active (1 character: 1 for active, 0 for inactive) a empty/null value will be read as inactive
• language (8 characters)
• last_name (64 characters)
• manager (255 characters)
• manager_email (255 characters)
• middle_name (64 characters)
• optional_1 (65,535 characters)
• optional_2 (65,535 characters)
• optional_3 (65,535 characters)
• phone_business (35 characters)
• phone_business_fax (35 characters)
• phone_mobile (35 characters)
• state (32 characters)
• sub_group (65,535 characters)
• timezone
• title (255 characters)
• zip (15 characters)

Country Formatting

PhishingBox CSV imports will accept the country name or abbreviation. The country/abbreviation map can be downloaded using the following link.

Download country map (csv)

Language Formatting

Format languages using ISO 639-1 codes, e.g. 'en', 'en_US', 'fr', 'fr-CA'. Both underscores and hyphens will work. View our Language Codes article to see all supported languages. 

Time Zone Formatting

Format time zones using a UTC offset with a leading zero, e.g. 'UTC+08', 'UTC+05:30', 'UTC-12:00'.

Custom Fields

Custom fields have a maximum allowed character length of 65,535 characters.

You can also include custom fields and map data to them at import as well. When you create the group you will need to add these custom fields using the "Add Another Field" button under Custom Fields section.

Sample CSV

Back to top