How can data that is transferred from a spectrophotometer be opened as comma delimited in Microsoft Excel?

Document ID

Document ID TE2665

Version

Version 2.0

Status

Status Published

Published Date

Published Date 27/05/2017
Question
How can data that is transferred from a spectrophotometer be opened as comma delimited in Microsoft Excel?
Summary
Opening data transferred from a spectrophotometer as comma delimited in Microsoft Excel
Answer
Please see the instructions below for how to transfer data from a spectrophotometer into Microsoft Excel as comma delimited:

1) Open Microsoft Excel and start a new worksheet
2) Select Data on the toolbar at the top of the page. Select Get External Data and then select Import Text File
3) Change the file name to All Files
4) Browse to the data location select the data.
5) Select Import
6) Select Delimited and then select Next
7) Confirm that Comma is the only option selected for the choice of delimiters and then select Next
8) Select Finish
9) Select OK