Business Data Storage A spreadsheet is an easy way to store all different kinds of data. These data types can include financial data, customer data and product data.

Data that is defined as unstructured is growing at 55-65 percent each year. Unstructured data can’t be easily stored in a traditional column-row database or spreadsheet like a Microsoft Excel table.

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.