Tamago-DB has the functionality to import CSV files exported directly from outlook.  


Tamago-DB supports the following encoding UTF-8, Shift-JIS, EUC-JP, ISO-8859-1, and ASCII.  Tamago-DB recommends UTF-8 for multi-language support.  

How to import a CSV

Users can import from a CSV from a contact grid or from as shortlist.  To import go to a contact grid or shortlist and click on the "Import" button.  

Once you select "Import" button the following popup window will be displayed:

Input details for all the following:

File:         Choose the CSV file you would like to import

Owner:     Choose the owner you want all the records to be associated with.  Leaving blank will keep the owner field blank in the records.

Shortlist:  Allows you to choose a shortlist to add the records or create a new shortlist

Create Company Records: Tamago-DB can add new companies to the database if the name of the company does not exist in the system

Test Import:  Users can test the import prior to actually importing the data, to make sure there are no errors or mistakes in the data

Duplicate handling Strategy: Allow duplicates, Ignore duplicates, or Merge duplicates

Duplicate matching strategy: Tamago-DB can search for duplicates by email, phone, name, and company


The CSV file exported from Outlook has many columns.  Tamago-DB will support the following fields for data import:


**Only First name and Last Name are mandatory input items


First Name

Given Yomi

Middle Name

Last Name

Surname Yomi




Job Title

     Job Description  


     Salary Currency     

Company Main Phone

   Business Street

Business Street 2

Business City

Business State

Business Postal Code

Business Country/Region

Office Location

Home Street

Home Street 2

Home City

Home State

Home Postal Code

Home Country/Region

Primary Phone

Mobile Phone

Home Phone

Home Phone 2

Other Phone

Home Fax

Other Fax

E-mail Address

E-mail Type

E-mail 2 Address

E-mail 2 Type

E-mail 3 Address

E-mail 3 Type






Referred By

Source Type

Sourced Detail




Web Page

Desired Salary

Desired Salary Currency
Graduate Year
Graduate Month
Language 1 Name
Language 1 Ability
Language 2 Name
Language 2 Ability
Language 3 Name

Language 3 Ability



  • The first line in the excel is the column definition
  • Any fields other than the above will be ignored while importing
  • First Name and Last Name are the only required fields
  • Fields can be read regardless of order
  • It is possible to define tags in the field "categories".  For example, tag1,tag2,tag3, etc. See Tags as extra field below.

Extra Fields

Tamago-DB does support extra fields that are not standard with Outlook CSV.  Please use them if necessary.

This field contains the full name separated by commas or delimited by a space.
If you divide it by a comma, it will be "Yamada, Taro", but if you divide it by space it will be "Taro Yamada".
If Last Name or First Name contains data, this field is ignored.

Enter the age as a number.

Source Type
Customizable drop-down menu to identify candidate's source information

If this column does not exist or if there is any space, the candidate's information source will be displayed as Import.

Sourced Detail

Display candidate's sourced by information in detail.

This column contains the URL the candidate used in LinkedIn.

This column will contain the URL of the candidate used on Facebook.

This column will contain the URL the candidate used on Twitter.

Categories [general]

Categories, or more specific, Tags, can be imported by the field "categories"on the CSV template. To specify which tag group to add the to the record,  use the following naming method with categories: Categories [jobcategory]

The name for the tag group within the brackets is based on the key name for that tag group. Please confirm with your administrator about the key names for your organizations' tag groups.  

Salary & Desired Salary

Salary amount, use digits only, no points, spaces or comma's unless for decimals. Japanese counters are supported (千,万, ...)

Salary Currency & Desired Salary Currency

Use JPY and USD,...

Graduate Month

Month when the contact graduated as a number.

Language Name

Use the ISO 639-1 Code (2 letter code).

Codes can be found here : https://www.loc.gov/standards/iso639-2/php/code_list.php

Language Ability

Language ability can either by 1 -> 6 or 'basic' -> 'native'

  1. basic
  2. conversation
  3. business
  4. advanced business
  5. fluent
  6. native