# Import - String to Select - Get an error

**URL:** https://community.nocodb.com/t/import-string-to-select-get-an-error/1677
**Category:** Uncategorized
**Tags:** data-import-export
**Created:** [February 21, 2025, 8:19pm UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677 "2025-02-21T20:19:08Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)
#### Post date: [February 21, 2025, 8:19pm UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/1 "2025-02-21T20:19:08Z")

</div>

Hello,

My config:

```auto
Node: **v22.13.0**
Arch: **x64**
Platform: **linux**
Docker: **true**
RootDB: **pg**
PackageVersion: **0.260.2**

```

I try to import an excel file to a table and i get an error.  
After multiple tests, i understand the error:

In a file, i get a column with string.  
I try to map the column to a Single Select ( or Multi select).  
I get the error:  
`Cannot read properties of undefined (reading 'msg')`

I understand the error occur when there are options in the column that doesn’t exist in the field configuration yet… A better way could be that the new option would have been automatically added with the import (as in coda, etc.).

It’s not the case in nocodb.

Any idea for a work-around?  
Thank you in advance for the help.  
Jean-baptiste

---

<div class="post-metadata">

### Author: ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [February 22, 2025, 3:55am UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/2 "2025-02-22T03:55:55Z")

</div>

Are you converting `Single Line Text` to `Single Select` after import? If so, ideally it should have worked. Please share the file (with data redacted may be) to help reproduce this issue. Or if you have any error logs, please share. We will investigate it further.

---

<div class="post-metadata">

### Author: ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)
#### Post date: [February 22, 2025, 3:29pm UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/3 "2025-02-22T15:29:27Z")

</div>

Thank you @dstala for your answer.

Yes, it’s possible to convert `Single Line Text` to `Single Select` after import.  
It’s not a perfect solution because i would be able to import a file regularly.

Here is a a file to test :

> **[8.5 KB file on MEGA](https://mega.nz/file/aJ8CAZ4A#1sHy0kD6LR0grilKKON9Bx7QDoif5ITqkWGoAxnDFWQ)**

I can’t check the log now but i will add as soon as possible.

---

<div class="post-metadata">

### Author: ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [February 24, 2025, 2:24pm UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/4 "2025-02-24T14:24:46Z")

</div>

What version of the NocoDB are you in? Please share your base-info

> **[FAQs | NocoDB](https://docs.nocodb.com/faqs/#how-to-check-my-base-info-)**
>
> General FAQs

---

<div class="post-metadata">

### Author: ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)
#### Post date: [February 24, 2025, 8:24pm UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/5 "2025-02-24T20:24:49Z")

</div>

Hello,

Node: **v22.14.0**  
Arch: **x64**  
Platform: **linux**  
Docker: **true**  
RootDB: **pg**  
PackageVersion: **0.262.0**

I update to the last version.  
It doesn’t change anything.

---

<div class="post-metadata">

### Author: ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)
#### Post date: [February 26, 2025, 7:19am UTC](https://community.nocodb.com/t/import-string-to-select-get-an-error/1677/6 "2025-02-26T07:19:58Z")

</div>

> [@jbo](#):
>
> able to import a file regularly.
> 
> Here is a a file to test :

An issue related to upload is fixed and should be available in our next release (likely today). Will keep you posted
