Pasting list of values from excel into select list

I have a large list of values in excel that I want to copy into select list as unique values:

ex: (each line is a cell in a single column in a row):

  1. Item 1
  2. Item 2
  3. Item 3
  4. Item 4
  5. Item 5
  6. Item 6
  7. Item 7
  8. Item 8
  9. Item 9
  10. Item 10

I want to Copy these items into a select list as unique values.

Every time I try to copy the excel values and try to paste them into a select list, it copies over as 1 value.

Any help is appreciated.

Don’t use the normal select list. Instead, store these values (from your excel) as a separate table in your doc.

Then use either a relation type column (or a select list if you really want that via formula references that table).

That will be really quick for you!