Create New Table

  1. In the Control Panel, click the Table tab.
  2. In the Table panel, click the blue + button and select New Table.
  3. The New Table window will appear.
  4. Click the Import Table Data button and select the preferred *.csv file in the Load Tables window.
  1. Save template/load template: Save/load the import configuration to a file for reuse.
  2. Separated by delimiter:
    • Use this for data values separated by a special “delimiter” character
    • The delimiter is a character used to separate columns: usually a comma, tab or space character
    • Select a delimiter from the list
  3. Collapse adjacent whitespace: treat multiple, contiguous spaces as a single column break
  4. Override number of columns: override the automatically detected number of columns
    • Each line is divided into this many columns. 
    • Additional text after the last column is excluded.
  5. Fixed width 
    • Blue “+” icon: add columns
    • Adjust the column width to the preferred size;
    • OR click the Use mouse adjuster link to set the column width via the mouse arrow.
    • In the Original tab, place the mouse arrow on a divider and drag left/right to the correct column width.
  6. Header lines: The number of lines to skip at the start of the file. These lines are ignored.
  7. Missing value represented by: Store data matching any of these values as a NaN (empty) value. To match multiple values, include each one separated by a space.
  8. Parsed: The start of the file is read and divided into fields according to the settings.
    • The headers for the columns vary according to the type of data.
    • See details on the import page for each type.
  9. Original: View the start of the file in the original format, with row and column numbers.
  10. If there are no errors or warnings, click OK.
  11. A table containing the imported data is available in the Table panel.
    • Click the Open Table Viewer table to see the imported data.