Spreadsheet (Tab-Delimited Text) Import

Tab-delimited tables are imported intelligently when dragged or pasted into Tinderbox. For example, selecting a table in a spreadsheet and pasting it into Tinderbox will create a useful set of notes:

• The first row is treated as a set of headings, which map to attributes. New user attributes will be created for attributes that do not already exist.
• A new container will be created to hold the table's rows.
• Each row of the table becomes a note. The table's fields are key attributes, and these attributes are populated from the table.

Empty values in numeric fields are imported as "0". The first column always maps to $Name, so you may want to duplicate column 1 at source or add a 'name' column there so that the otherwise first column of the original data gets handled as a user attribute.

The feature works beyond formal spreadsheets - any tab-delimited text sample should import. This allows other material such as vcf address card data to be dragged into Tinderbox.

In v4.6.2, import was improved to offer better auto-detection of dates, non-ASCII characters and to handle clipboard data from Numbers '09.

Licensed under Creative Commons Attribution-Noncommercial-Share Alike 3.0 License
[See aTbRef CC licence Attribution/Waiver info info]