Question: How to convert SAM file to tabular ??
gravatar for felipe_o_torquato
20 months ago by
felipe_o_torquato10 wrote:

Hi everyone,

I am trying to convert the SAM file to tabular ?? Does anybody know?

Is there any way to open SAM file in excel?

many thanks in advance

convert format excel sam tabular • 1.2k views
ADD COMMENTlink modified 20 months ago by Jennifer Hillman Jackson24k • written 20 months ago by felipe_o_torquato10
gravatar for Jennifer Hillman Jackson
20 months ago by
United States
Jennifer Hillman Jackson24k wrote:


SAM datasets are already in tabular format. SAM is a more specific datatype assignment (header and column metadata is recognized).

Many tools that accept tabular format within Galaxy will accept SAM format directly. Others will require that the header is removed first. And certain others will require that both the header is removed and the datatype assignment is changed to be "tabular".

If the header is removed and the dataset is downloaded, it can be imported into Excel on your local computer as tabular data. If needed, change the file extension after downloaded to be ".txt" and make sure Excel knows that the imported data is in tabular format (not csv, etc).

To remove the header, there are a few options. These are the most direct:

  • Text Manipulation > Remove beginning of a file where the number of lines is equal to the number of lines in the header.
  • Filter and Sort > Select with the option NOT matching and the expression ^@

To change the datatype:

Best, Jen, Galaxy team

ADD COMMENTlink written 20 months ago by Jennifer Hillman Jackson24k
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 148 users visited in the last hour