Oh my God! I hope I help you in time. I just spent hours dealing with the same issue, and I finally figured it out. Basically, OpenChrom will only read CSVs formatted in a very specific way, so you will have to change your .csv files to meet these requirements:
The first three columns MUST be have the headers 'RT(milliseconds)', 'RT(minutes) - NOT USED BY IMPORT', and 'RI', exactly as I have written them.
The second column ('RT(minutes) - NOT USED BY IMPORT') does not need any values; as its name suggests, it is not used by the import, but it still needs to be there! You will have to convert your times to milliseconds to populate the first column. The third column ('RI') is for retention indices, if you do not have them you must populate the entire column with zeros (0.0).
Every subsequent column must have an integer header representing the mass of the signal (e.g. '176' for m/z 176).
No trailing comma at the end of the line! E.g. a line of values should look like
1,2,3,4
5,6,7,8
and NOT
1,2,3,4,
5,6,7,8,
In Excel, the only way for my files to save like this is if I save them as CSV (MS-DOS).
Oh my God! I hope I help you in time. I just spent hours dealing with the same issue, and I finally figured it out. Basically, OpenChrom will only read CSVs formatted in a very specific way, so you will have to change your .csv files to meet these requirements:
The first three columns MUST be have the headers 'RT(milliseconds)', 'RT(minutes) - NOT USED BY IMPORT', and 'RI', exactly as I have written them.
The second column ('RT(minutes) - NOT USED BY IMPORT') does not need any values; as its name suggests, it is not used by the import, but it still needs to be there! You will have to convert your times to milliseconds to populate the first column. The third column ('RI') is for retention indices, if you do not have them you must populate the entire column with zeros (0.0).
Every subsequent column must have an integer header representing the mass of the signal (e.g. '176' for m/z 176).
No trailing comma at the end of the line! E.g. a line of values should look like
1,2,3,4
5,6,7,8
and NOT
1,2,3,4,
5,6,7,8,
In Excel, the only way for my files to save like this is if I save them as CSV (MS-DOS).
Okay, I understand now. OpenChrom allows for import of data in either CSD (total area like your data), or MSD perspectives (mass-speciated signals). I have no idea what the .csv requirements for CSD data should be (and frankly dont want to figure it out), but you should still be able to carry out your analysis by formatting your data as Ive described above (pseudo-MSD) and opening in the program.More
I do confess in your original post Im not sure what "Area" means. I am far from being a GC-MS expert (only learned the analysis to help with a class I am TAing) but all of our files are something like retention time vs. net intensity. If your Area represents net intensity measured by the MS, which I think it does, then just put it in the fourth column with some arbitrary integer header.More
Thanks, Ill look into this tomorrow. You may have saved me! So is "retention indicies" my "Area" column?More
Upvote
VOTE
Downvote
Literally the same questions and the same answers by different people? This is weird!<br />https://chemistry.stackexchange.com/questions/131941/how-do-i-import-csvs-to-openchrom
Literally the same questions and the same answers by different people? This is weird! https://chemistry.stackexchange.com/questions/131941/how-do-i-import-csvs-to-openchromMore
Oh my God! I hope I help you in time. I just spent hours dealing with the same issue, and I finally figured it out. Basically, OpenChrom will only read CSVs formatted in a very specific way, so you will have to change your .csv files to meet these requirements:
and NOT
In Excel, the only way for my files to save like this is if I save them as CSV (MS-DOS).
I hope this helps!
Oh my God! I hope I help you in time. I just spent hours dealing with the same issue, and I finally figured it out. Basically, OpenChrom will only read CSVs formatted in a very specific way, so you will have to change your .csv files to meet these requirements:
and NOT
In Excel, the only way for my files to save like this is if I save them as CSV (MS-DOS).
I hope this helps!
More
VOTE
VOTE
VOTE
VOTE
https://chemistry.stackexchange.com/questions/131941/how-do-i-import-csvs-to-openchromMore
VOTE