Select a cell — I selected B2. Click the Data tab. In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List.

Microsoft's old standby spreadsheet app, Excel, has a new trick for importing lots of data from hard copies quickly. It just takes a few steps to use.