GE Analytical Instruments ©2016 255 of 270 DLM 68100-09 EN Rev. A
Appendix C: Importing Analyzer Data into a Spread-
sheet
The Analyzer exports data in comma-delimited text format to create a .csv file that can be imported into many
spreadsheet or database programs. A common application involves exporting data from the Analyzer and
importing the data into an Microsoft Excel
®
spreadsheet program. This section describes how to accomplish
this task.
Importing Data into a Spreadsheet Program
The Analyzer exports data in comma-delimited text format to create a .csv file that can be imported into many
spreadsheet or database programs. A common application involves exporting data from the Analyzer and
importing the data into an Excel
®
spreadsheet program. This section describes how to accomplish this task.
To import data into a spreadsheet program
1. Export data from the Analyzer via one of two methods.
• Export to the Analyzer’s USB port and capture the data on a USB flash memory drive. After exporting
the data, remove the USB drive from the Analyzer and attach it to your computer’s USB port. It
should appear in your available drive list as a “removable media drive.”
• Export to the Analyzer’s Ethernet port and capture the data using a data acquisition program, such
as PuTTY, HyperTerminal, and Tera Term. See “
Collecting Historical and Real-Time Data” on
page 159.
2. On your computer, launch the Microsoft Excel spreadsheet program.
3. Select File Open.
4. Set the Files of type drop-down menu to All Files (*.*). Browse to the file containing the data exported
from the Analyzer, and click Open. The USB flash drive appears as a “Removable Disk” in the list of
available drives.
5. If the spreadsheet program opens the data in a spreadsheet, you do not need to continue with the next
steps. You can work with the file as you would any other Microsoft Excel spreadsheet program file.
6. Depending on the version of Microsoft Excel spreadsheet program you have, the program may
automatically start the “Text Import Wizard” to help you create a spreadsheet from the data in the file.
If the “Text Import Wizard” dialog box appears (see Figure 114
), make sure Delimited is selected and
click the Next button.
To Next Page
Loading...
