Tooladoo Free online tools for your files

Export Agilent MassHunter .D data to CSV and Excel (Beta)

Zip the MassHunter .D folder and get the TIC with base peaks, the DAD signals and spectra and the instrument traces as CSV and Excel.

Opens: CH, UV, MS, .D (ZIP), DX, LCD, GCD, QGD, .raw (ZIP), CDF
Saves: CSV, XLSX

Convert

Chromatography data
Choose files… or drop them here
up to 200 MB each, 50 files max
    Add more files

    Agilent .ch, .uv or .ms files or a .D folder packed as .zip (ChemStation, OpenLab or MassHunter), an OpenLab CDS .dx file, Shimadzu .lcd, .gcd or .qgd files, a Waters .raw folder packed as .zip, or AIA / ANDI .cdf files. Several files or runs are converted together.

    Options

    Pick the comma version if your Excel uses a decimal comma (most of Europe).

    Chromatograms to extract from diode-array spectra, e.g. 254, 280. Empty: the wavelengths of the file's own signals, else 210, 230, 254 and 280 nm.

    More options

    Absorbance is averaged over wavelength ± half this width, like a DAD signal setting “Sig=254,4”. 0 takes the nearest stored wavelength.

    Your files are deleted after processing.

    Agilent MassHunter saves every LC/MS and GC/MS run as a .D folder. Unlike the ChemStation folders of the same name, the data sits in an AcqData subfolder: MSScan.bin with its MSScan.xsd description for the mass spectrometer scans, .cd and .cg files for the diode-array signals and the instrument traces, .sd and .sp files for the diode-array spectra, and XML files with the sample details. This page reads them without MassHunter.

    How to convert a MassHunter .D folder

    1. Pack the .D folder: on Windows right-click it and choose Send to, Compressed (zipped) folder; on a Mac choose Compress. A ZIP with several .D folders converts them all in one go.
    2. Choose the number format and, for diode-array data, the wavelengths you want as chromatograms.
    3. Download the CSV files or the Excel workbook.

    What you get

    • The TIC of every scan with the base peak m/z and abundance MassHunter stored with it, grouped by MS level, scan type (scan, SIM, MRM) and polarity, with the ion source as recorded (ESI, APCI, EI and others).
    • Diode-array data: every DAD signal as a chromatogram, the spectra as a time × wavelength table in mAU, and chromatograms extracted at the wavelengths you choose.
    • Instrument traces the run recorded: pump pressure, flow and solvent composition, column oven temperature, detector status.
    • The integration results of GC/MS runs (RESULTS.CSV or rteres.txt) as a peak table, when the folder holds them.
    • Sample details from the run: sample name, instrument and acquisition date.

    GC/MS .D folders that hold a ChemStation-style data.ms file are read from that file, and there every mass spectrum is exported in full, scan by scan.

    How the numbers were checked

    The stored TIC equals MassHunter's own TIC exports for seven runs written by MassHunter versions B.07.02 to 10.2, and the diode-array values equal two independent open-source readers (entab and rainbow).

    Not included

    The individual mass spectra in MSPeak.bin and MSProfile.bin are not exported yet: there was no MassHunter export to check them against, and numbers that cannot be checked are left out rather than guessed. The TIC and base peak of every scan are exported in full.

    More about what this tool reads and writes: Chromatography Data Converter (Agilent, Shimadzu, Waters, AIA).

    More with Chromatography Data Converter (Agilent, Shimadzu, Waters, AIA)

    • Battery Cycler Data Converter

      Open Neware .nda/.ndax, BioLogic .mpr and Arbin .res files without the vendor software: tidy CSV, cycle summary, Coulombic efficiency and dQ/dV.

    • Spectrum File Converter (OPUS, OMNIC, SPC, WDF, SP, JWS)

      Open FTIR, Raman and UV-Vis files without the vendor software: Bruker OPUS, Thermo OMNIC .spa/.spg, GRAMS .spc, Renishaw .wdf, PerkinElmer .sp, JASCO .jws and Shimadzu UVProbe .spc to CSV, Excel and JCAMP-DX.

    • XRD Pattern Converter (RAW, BRML, XRDML, RAS)

      Open powder XRD files without the diffractometer software: Bruker .raw/.brml, PANalytical .xrdml, Rigaku .raw/.ras/.rasx, Philips .rd/.udf, UXD and GSAS to .xy, .xye, CSV, Excel and XRDML.

    • Thermal Analysis File Converter (NETZSCH NGB)

      Open NETZSCH Proteus .ngb files from STA, TGA, DSC and dilatometer instruments without Proteus and get every channel as CSV and Excel, with mass %, DTG, DSC in mW/mg, charts and the metadata.