Home > Community > How do I import CSVs to OpenChrom?
Upvote

19

Downvote
+ Chemistry
+ Chromatography
Posted by
Leliz Lampe

How do I import CSVs to OpenChrom?

My end objective is to compare GC outputs of samples in two groups using PCA. I have bene given the data in Excel format but have saved to CSV.

Whilst I can locate CSV files through OpenChrom, they all appear blank when I do so.

Having spend a lof of time trying to find the information, I cannot find the relevant info about how my CSV (or Excel) file should be formatted for OpenChrome.

  • I have columns for retention time (labelled "RT") and area (labelled "Area").
  • I have tried a simple file with two columns (RT and Area) for one sample. I have also tried files with multiple samples and columns, both with and without sample no. headers. (see pictures).

Whatever option I try, the charts in OpenChrom appear completely blank. I don't know if it's the data itself, the headings, the process I'm going through, not a clue what's going on to be frank.

Lastly, I would like to apologise that this may be a basic/naiive question for the forum. I've essentially been dumped with the work of running PCAs comparing GC data sets with little to no experience in doing so.

Thank you.

Sample

Sample

Sample

Related Posts

33  Upvotes · 2 Comments
16  Upvotes · 3 Comments
15  Upvotes · 8 Comments
17  Upvotes · 8 Comments
16  Upvotes · 10 Comments
TOP