TouchGraph Navigator 2, Welcome!
Licensing and Support
Samples Licensing
Installation
System Requirements
Navigator Web Installation
Applet Launcher Page
TouchGraph Navigator Overview
Menus
File Menu
Export Data dialog
Export Image dialog
Add Search Entity dialog
Settings Menu
Edit Menu
View Menu
Tools Menu
Help Menu
Definitions
Navigator 2: New Features
Loading Wizard
Select Input
Excel
CSV / TSV
MCSV
Navigator DB API
NavigatorDbApi Script
MySQL
Data Types & Delimiters
Entities & Relations
Choose A Table
Edit Entity
Edit Relation
Dynamic Relations
Co-occurrences
Dynamic Attributes
Aliases
Settings
Names - Types / Attributes
Names - Entity Labels
Filter - Inclusion
Filter - Attribute Filters
Add Filter Dialog
Node - Colors
Node - Label / Image
Node - Halo Size / Shape
Node - Node Tags
Edge - Colors
Edge - Width / Pattern
Edge - Tags / Arrows
Graph Layout
Graph Panel
Nodes, Edges
Graph Interaction
Connected Components
Zooming, Spacing
Graph Toolbar
Color Chooser Dialog
Cluster Dialog and Algorithm
< Previous page Next page >

Excel

Excel
 
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".