Open a dataset contained in a spreadsheet
- Go to the File menu
- select Open Data
- select Import
- select Excel
- Select the XLS file and click Open (you can also easily import files in other formats: text/csv, Gnumeric, Stata, Eviews, SPSS,etc.
- Select one sheet in the workbook to import, and select the column and row at which to begin the import
- Gretl will look in the first row for the name of the series, if it can't find it the series will be named automatically.
NOTE: need more information about formatting the data