Copy paste multipe rows from excel - changes column type to 'Select List' from 'Lookup'?

Hi - I am copy pasting a few rows from an excel sheet into a coda table. it changes the column type of 2 lookup columns into ‘select list’ . That’s causing me problems. any way to prevent this?

1 Like

Dear @Puneet_Agarwal, welcome to the community :handshake:

As far as I can understand for both instances there are multiple options in the selected cell and therefore Coda assumes that you need the “select list”.

You can convert these to a table as shown below:


After that this column becomes a lookup as shown below:
image

Hopefully this will work out for you, otherwise you will have to update your source doc accordingly and create the tables independendly.