This version is out of date, covering development as far as v4.2.5. It is maintained here only for inbound reference links from elsewhere.

Jump to the current version of aTbRef.

A Tinderbox Reference File : Import/Export/Formatting : Spreadsheet Import

Spreadsheet Import

From v3.6.0, tab-delimited tables are now 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 contained will be created to for 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 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.

v3.6.2 has improved some of the parsing routines and is recommended if using this feature.

Up: Import/Export/Formatting
Previous: Spotlight support	Next: Tabs, Quick Lists, Fonts and Export

[Last updated: 3 Dec 2008]

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