Importing Intensity Data to Excel

  1. Right-click an intensity file and click Open with....

  2. Select Notepad in the list.

    -Or-

  3. If Notepad is not in the list, click Other Programs and select Notepad.

  4. Click OK.

  5. In Notepad, click File, Save As....

  6. Click Save to save the intensity file as a .txt file.

  7. Open Excel.

  8. Click the Data tab.

  9. In Get External Data, click From Text.

  10. In the Import Text File dialog box, double-click the text file that you want to import.

    The Text Import Wizard appears.

  11. Under Original date type, select Delimited.

  12. Click Next.

  13. In the Delimiters list, select the Tab and Space options.

  14. Select the Treat consecutive delimiters as one option.

  15. Click Next.

  16. In the Column Data Format, select General.

  17. Click Finish.

  18. In the Import data window, select Existing worksheet.

  19. Click OK.

    Your intensity data appear in Excel.