Appendix b. importing files into excel, B.1 table-based data file import (toa5), Step 1 of 3 – Campbell Scientific RTDAQ Software User Manual

Page 363

Advertising
background image

Appendix B. Importing Files into Excel

ASCII Data files saved by RTDAQ can be imported into a spreadsheet program
for analysis or manipulation. Changing the extension of a TOA5 (comma
separated ASCII) file from *.dat to *.csv will allow the file to be imported
directly into Microsoft Excel with all of the header data included. Instructions
are given below for importing TOA5 files into Microsoft Excel with more
control over what header information should be included.

B.1 Table-Based Data File Import (TOA5)

From the Excel menu, select File | Open. Browse to the TOA5 file (*.dat) that
you want to import. Excel will recognize the file as not being in an Excel
(*.xls) format, and will open the Text Import Wizard. The Text Import
Wizard
consists of three steps, each having its own window.

Step 1 of 3

Select the Delimited option from the Original Data Type group box. Using
the arrow buttons to the right of the Start Import at Row field, select the
number of the first row of data to be imported. Since your data file has
headers included, you should start the import at the first row of data (typically
row 5). Select the Next button.

B-1

Advertising