4.2. Aggregated spreadsheets

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.

Watch a video tutorial (2:34)

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

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