We use the dropdown option to select pre-determined niches in our product. (We tried this as tags and found it didn’t work as we liked among our team.) We have clients send us a list via Excel that includes the niches for their already existing product. We’d like to be able to import this data into their boards, so that we do not have to manually re-enter every options.
Hi there @amandaCNMG !
You can highlight the cells in the excel file (if they are vertically listed), copy (CMD+C [Mac], CTRL+C [PC]), and then create your dropdown column and then paste into the options (CMD+V [Mac], CTRL+V [PC]).
This will automatically create that list!
Hope this helps!
Thanks for this. It also works if you copy from vertical cells in a Word table. And from words separated by a ‘tab’ in Word.
The column already exists in the board, so when we’re importing a new group of items, we’re using terms that already exist in the board in a column. Are you saying that if I copy the column in Excel (and Google Sheets) I can just paste it into the already existing column for those new items?
I am not sure i understand your process.
How I used it was to set up the label options in a Monday.com column (not adding content into the items in a column).
- have a list of values for a drop down in excel (i.e. each value is in a separate vertical cell in excel or word table)
- copy this set of cells
- click on your drop down column in Monday.com
- open the ‘edit labels’ option
- paste your list into the ‘Create or find labels’ box
This creates your drop down options, rather than adding them one by one.
Hope this makes sense.
That does make sense, but the column isn’t a dropdown column in our Monday board, it is a label column. Some have as many as 20 labels.
ᐧ
Hi Amanda, if you can select several items from a list in one column, I think that is technically a drop down. When you go to populate the column, it would look like the attached image, with the ‘edit labels’ option at the bottom.
