How do I copy dropdown lists from Excel to Google Sheets?

0

I have an Excel sheet with dropdowns. Each dropdown has anywhere from 40 to 1000 values. Right now, to copy from those values, I need to individually select those values and copy it to a dropdown in Google Sheets. Is there a faster and more efficient way to do this?

Nabeel Parkar

Posted 2018-12-29T07:46:39.320

Reputation: 45

I'm not familiar with how compatible that feature is, but would it be practical to just open a copy of the workbook in Sheets and delete what you don't need? – fixer1234 – 2018-12-29T09:52:40.530

That doesn't help since Google Sheets seems to have problems even processing that many values from the drop down. – Nabeel Parkar – 2018-12-29T11:04:38.133

No answers