Streamline is able to import data from an Excel spreadsheet or CSV file. There are two spreadsheet connections that differ in the way the data should be organized before the import.

This article describes the Aggregated spreadsheet connection. This connection requires data (sales, on-hand, and revenue histories) to be aggregated in certain periods:

• Any equal periods: days, weeks, 2 days, 4 days…
• Specified days within a week: workdays, holidays…
• Months
• Specified months within a year: winter months, quarters…

If Streamline cannot find a pattern within periods, it will work, but the future periods will be denoted as +1, +2…