Spreadsheets are woefully inadequate for managing inventory. Before inventory management software technology developed, spreadsheets were commonly used. However, they are subject to error and not sophisticated enough to automate aspects of the inventory process to allow you to ensure optimum ordering times and provide up-to-the-minute reporting.