12
RMS Clamp-on Simple Logger® Model CL600
APPENDIX A
Importing .TXT Files into a Spreadsheet
Opening a Simple Logger .TXT file in Excel
The following example used with Excel Ver. 7.0 or higher.
1. After opening the Excel program, select
“File”
from the main
menu and then select
“Open”
.
2. In the dialog box that appears, browse and open the folder
where your logger .TXT files are stored. This will be located
in
C:\Program Files\Simple Logger 6.xx
if you accepted the
default choice offered by the logger installation program.
3. Next, change the file type to
“Text Files”
in the field labeled
Files
of Type
. All the .TXT files in the logger directory should now be
visible.
4. Double-click on the desired file to open the Text Import Wizard.
5. Review the selections in the first wizard screen and make sure
that the following choices are selected:
Original Data Type: Delimited
Start Import at Row: 1
File Origin:
Windows (ANSI)
6. Click the
“NEXT”
button at the bottom of the Wizard dialog box.
The second wizard screen will appear.
7. Click on
“Comma”
in the Delimiters box. A check mark should
appear.
8. Click the
“NEXT”
button at the bottom of the Wizard dialog box.
The third wizard screen will appear.
9. A view of the actual data to be imported should appear in the
lower section of the window. Column 1 should be highlighted. In
the Column Data Format window, select
“Date”.
10. Next, click on
“Finish”
to complete the process and import the
data.
11. The data will now appear in your spreadsheet in two columns (A
and B) and will look similar to that shown in Figure A-1.
