Format of xls data file

Hi

Do you need simple Choromatogram in XY-format for several datafiles ?

or

Do you need every spectra in datafile listed in XY format (M/Z:Abundance) ?

I suppose you were looking the later. That should be in excel readable format (like CSV or TSV), so that every spectra is in one line and excel file should have one run on sheet, right?

If you look something like this screenshot below,  I have a tiny macro what can do the job for you (Expecting you use MSD Chemstation (because your Excel file has data path as C:\msdchem\1\DATA\2017\Organic acids\April 2017\25 April 2017\). It has in one sheet, scans picked from one run, one scan per line.

Hello,

Could you please provide us with the software product you are using (MSD ChemStation, MassHunter Qual/Quant, etc...) as well as the software revision (found by going to Help>About)?

I do sell an application that reads the gcms data files and converts it really fast in a csv file. It can transfer all data files in subdirectories and I can programs any output format and destination. Just send me a private message if you are interest. 

ProteoWizard: Documentation 

Maybe this is what you are searching for?

Unfortunatly the .ms files format is agilent proprietary binary.. As of my knowledge the documentation isn´t public.. But you might be able to reuse the libraries in the software product to read the files.. People have done it in the past (see Open Source ProteoWizard for example)..

Actually, Hewlett-Packard did publish fairly complete details on the data format of data.ms files in the original documentation for the 5970A MSD.  To the best of my knowledge (perhaps Agilent people can correct this if not so) that same format has been continued.  I provide free software (Quadfiles 1.2) at https://quadtechassociates.com that can read ChemStation files and output their content in text format.  I also provide a code listing in Pascal for reading data.ms files, based on the original Hewlett Packard documentation.  Quadfiles will also read Mass Hunter files (quadrupole MS and MS/MS only), but that is based on inferred data structures, since I do not think Agilent has publicly released the Mass Hunter file format at this time.