After a run is integrated, the chromatography software keeps a peak table: retention time, area, height, area percent and, with a calibration, amounts and compound names. Getting that table into Excel usually means opening the run in the instrument software again. This page reads the table the software already saved, next to the chromatogram itself. Nothing is integrated again: you get the numbers exactly as the software stored them.
Where the peak tables come from
- Agilent ChemStation and OpenLab: the integration report inside the
.Dfolder, either the printedReport.TXT(Area Percent, External Standard and the other report styles) or theREPORT00.CSV,REPORT01.CSV… files written when "Report to CSV" is switched on. When both are there they are combined: every digit from the CSV files, the units from the text report. - Agilent GC/MS (MSD ChemStation and MassHunter GC/MS):
RESULTS.CSV, orrteres.txtwhen that is all the folder has. - Shimadzu LabSolutions and GCsolution: the peak tables stored in
.lcdand.gcdfiles, including the tables of PDA channels. - AIA / ANDI netCDF files (
.cdf) exported from almost any chromatography data system: the peak variables such as retention time, start and end, width, area and height.
How to export a peak table
- Upload the run: zip the whole
.Dfolder, or choose the.lcd,.gcdor.cdffile. A ZIP with several runs gives one table per run and one combined workbook. - Download
<run>_peaks.csv, or the Excel workbook, where the table is on its own Peaks sheet next to the chromatograms.
Runs with several signals get a Signal column, and detectors with different units get a unit column, so every row says what it measures.
Good to know
- A run that was never integrated has no peak table to read; you still get its chromatograms.
- The values were checked against the software's own exports: 11,381 peak table cells of three LabSolutions exports match, and the ChemStation CSV and text reports agree row by row.
- Older LabSolutions tables without the current layout tag, and the Area Ratio and Height Ratio columns, are not read yet.
More about what this tool reads and writes: Chromatography Data Converter (Agilent, Shimadzu, Waters, AIA).