Forecast Pro can read Excel (XLS, XLSX) files and CSV (Comma Separated Values) files saved from Excel.
You must create your spreadsheet file from within your spreadsheet program. Forecast Pro checks data types as it reads the spreadsheet. If it sees text where it expects a number, or a floating point number where it expects an integer, an error message will be displayed when the data is read in. By default, a blank cell is interpreted as a missing value. This default can be adjusted for leading and trailing blanks on the Formats tab of the Options dialog box. Do not use zeros to represent missing values¾they will be interpreted as numbers and will probably distort your forecasts badly.