Import Spectrum to Excel
Importing
?Spectral
?Data
?to
?Excel
?
The software used to collect spectra can export the data as a simple comma-separated
variable text file. It doesn¡¯t automatically append the correct Windows file extension
(some versions use *.asc instead of the correct *.csv) however and, even when it does,
Excel doesn¡¯t always recognise it. The following procedure allows you to work around
these issues, and will work for IR, UV-Vis, and fluorescence spectra.
1. Launch Excel if it is not already running
2. Select File ¡ú Open¡
3. In the resulting dialog, set the pull-down menu (File Type:, Format:, or Enable:)
to All Files:
4. Navigate to where your data files are stored, select one, and click Open
5. Excel should now display the import Text Wizard. Make sure that the Delimited
radio button is selected, and click Next:
Page 1 of 2
6. In the second step, check the Comma option, and click Finish (skipping step 3 of
the import wizard)
7. You should now have the data imported into an Excel worksheet. Select File ¡ú
Save As¡ Use the Format: pull-down menu to select the default Excel file type,
and click Save
8. If you scroll through the worksheet, you will see that the first 50 rows contain a
variety of information regarding the settings used to collect the spectrum. Keep
going until you find the #DATA entry in column A. You can delete all the rows
above this entry. The data following this entry consists of the x (wavelength or
wavenumber) and y (absorbance, transmittance, etc.) values in columns A and B
respectively. You can now plot the spectrum using the XY Scatter chart type in
the normal way.
9. Note that if the data is for an IR spectrum, you can get the wavenumber values
decreasing from left to right (as is conventional for IR) through the Format Axis
dialog: under the Scale tab, check the option for Values in reverse order
Page 2 of 2
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- import pdf to excel 2010
- import csv to excel 2019
- import csv into excel 2016
- import csv into excel template
- import csv to excel online
- import data to excel template
- import data into excel template
- import pdf to excel online
- how to import contacts to outlook 2016
- import pdf into excel online
- how to import notepad to excel
- pdf import to excel 2010