|
|
Formatting data for Excel is simple.
-
Navigator currently only supports .xls files and not .xlsx
-
Data can be in multiple worksheets. Not all worksheets have to contain properly formatted data. You can later choose which ones to use.
-
A properly formatted worksheet should contain a single table of data.
The top row of a properly formatted worksheet should contain the names of the columns. Columns must be left aligned, if there are 4 columns, columns A,B,C,D should have the data, without blank columns in between.
-
If column names are not unique, the columns will be given unique names (by appending 1,2) when the table is processed.
-
Multiple values can be placed in a single cell using a delimiter. For instance if a column contains Authors, a cell can have the value "Vonnegut; Dickens; Twain".
|
|
|