# Import Data with user lookup

**URL:** <https://forum.kintone.dev/t/import-data-with-user-lookup/198>\
**Category:** General\
**Created:** [July 15, 2021, 4:24am UTC](https://forum.kintone.dev/t/import-data-with-user-lookup/198 "2021-07-15T04:24:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [July 15, 2021, 4:24am UTC](https://forum.kintone.dev/t/import-data-with-user-lookup/198/1 "2021-07-15T04:24:03Z")

</div>

I want to import training records for our employees.&nbsp;

I am using the User Lookup to link the records to the employee database.&nbsp;

The import feature isn’t recognizing the data in the lookup cell.&nbsp;

Each employee will have at least 10 training records I will import for each. Currently, I am using the ‘category’ function as the name of each training course.&nbsp;

The feedback i get is this -&nbsp;

GAIA\_IL16: The value of field “Employee Lookup” at row 2 of the file is invalid. The field may have the “Required field” or “Prohibit duplicate values” options turned on. If the field type is a Drop-down or a Radio Button, the value may not match the options included in the field settings.

but when i Untick **“Prohibit duplicate values”&nbsp;** the file imports but the lookup field is empty in Kintone. the support page doesnt have enough information to explain the use of the lookup tool when importing.&nbsp;

---

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [July 15, 2021, 3:54pm UTC](https://forum.kintone.dev/t/import-data-with-user-lookup/198/2 "2021-07-15T15:54:50Z")

</div>

Hi Hannah,

Please note that only when the field that is specified as the “Key Field” is “prohibited from duplicating values” you can import values from a file to a lookup field.

Would you please correct me if I am wrong? Are you trying to import data from a CSV file?  
If so, it would help to provide a screenshot of the screen you see the error message, the CSV file you are trying to import, and the app’s template that the error is occurring.

Can I Import Values from a File to a Lookup Field?:  
[https://get.kintone.help/k/en/trouble\_shooting/app\_qa/lookup\_import.html](https://get.kintone.help/k/en/trouble_shooting/app_qa/lookup_import.html)

Supported Formats for Each Field Type:  
[https://get.kintone.help/k/en/user/using\_app/import\_records/create\_csv.html](https://get.kintone.help/k/en/user/using_app/import_records/create_csv.html)

Error “GAIA\_IL16” Is Displayed:  
[https://get.kintone.help/k/en/user/using\_app/import\_records/import\_records\_failed.html#import\_records\_import\_recors\_failed\_1010](https://get.kintone.help/k/en/user/using_app/import_records/import_records_failed.html#import_records_import_recors_failed_1010)