Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

14.1 Tab-delimited format (spreadsheets)

Stores: Values

this is generally an excellent format, except that it can be
corrupted easily by any text manipulator (including editors
and e-mail systems) that remove or add tabs, and it uses
non-printable characters that may not have an equivalent in
non-ASCII character sets. also, it tends to have long lines,
which may cause further problems.

each column is separated by ASCII tabs (9). each row is separated
by local end-of-line, most commonly ASCII LF (10), ASCII CR (13),
or ASCII CRLF pair (13,10).

e.g.,
First[TAB]Second[TAB]3[TAB]Fourth, and Second-Last[TAB]Fifth

 

Continue to:

• prev: 14.0 General References (spreadsheets: Obscure File formats)
• Index
• next: 14.2 CSV (Comma-Separated Values) format (spreadsheets)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro