The basic formatting of this file is simple. The first row will contain unique column headers that are tab-delimited (i.e. separated by tabs). The first column of the data, by default, is assumed to be the column that contains the depth reference for the data in the row. Every row of data is also tab-delimited, and must contain the same number of tabs as the header row; in order to positively determine which data value belongs to which column. Microsoft® Excel can export a worksheet as a tab-delimited file in the same way. An empty entry is considered to be two consecutive tabs, and will be dealt with properly. Any data that appears to be invalid should be deleted in your spreadsheet program of choice to create an empty entry.
Depth [m] Porosity [% vol] WBD [g/ccm] Sus [units]
12.250 0.454 1.937 241.46
12.270 245.60
12.290 0.420 1.995 244.68
12.310 0.408 2.015 257.45
12.330 0.365 2.087 280.15
12.350 0.387 2.050 305.97
12.370 0.383 2.057 390.86
12.390 0.434 1.971 620.38
12.410 0.282 2.226 762.53
12.430 0.376 2.069 644.55
12.450 0.441 1.959 435.98
NOTE: In this example you can see that on the third row there are two blank entries for both Porosity and WBD columns.