Copying Data To Microsoft® Excel®

There are two ways to move Logger Pro data into an Excel spreadsheet for analysis or graphing.

Copy and Paste

  1. Select the data you want to copy into Excel. Only columns and rows that are selected will be copied. To select an entire column, click the column name in the data table. You can also select data by clicking and dragging over a region of the graph. If a region is selected in a graph, the corresponding range will be selected on the table.
  2. Choose Copy from the Edit menu to copy the data to the clipboard.
  3. Start Excel and open the document into which you want to paste the data.
  4. In Excel, click on the cell that will be the upper left corner of the data region, then choose Paste from the Edit menu. You are now ready to analyze the data as you wish.

Export as Text

  1. In Logger Pro, choose Export as Text from the File menu.
  2. Save the file with the name of your choice in a location where it will be easy to find. Notice that it will be saved with a .txt extension.
  3. Start Excel.
  4. In Excel, choose Open from the File menu. Select Text Files as the Files of Type.
  5. Select your saved file with the .txt extension, and click Open.
  6. You will go through 3 steps. Choose Delimited, then Tab, then General Format, and then click Finish. Notice that this file will include the data as well as formatting information, including column titles, date, etc.