Open a dataset contained in a spreadsheet

From Gretl
Jump to: navigation, search
  1. Go to the File menu
    1. select Open Data
    2. select Import
    3. select Excel
  2. Select the XLS file and click Open (you can also easily import files in other formats: text/csv, Gnumeric, Stata, Eviews, SPSS,etc.
  3. Select one sheet in the workbook to import, and select the column and row at which to begin the import
  4. 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

Personal tools