How to open a .tabular file in R or excel?

Question

[writetoroopali]

Hi

I am trying to use featureCounts to get gene expression data for a paired-end single cell RNA-seq data. The function returns a .tabular file and I am unable to open it in excel or R.

Can someone please help me on this?

[cpad0112]

.tabular file is a tab separated values (.txt). Take a back up of .tabular file, change the extension of existing file to .tsv or .txt and then try opening with excel. One has option to change the output while using featurecounts using -o output.txt. I guess you are in windows, try using software like notepad++ (text viewer) for viewing texts instead of notepad or wordpad

Answer 1

[h.mon]

What is the relation of your title ("How long is the waiting time for a job to run?") to your question (how to open a text file containing tab-separated values in Excel)?

Save it as .tsv (or .csv) and open it in Excel.

[writetoroopali]

sorry I posted something else by mistake. Just modified it. Thanks.

Answer 2

[ahmad mousavi]

Hi Just drag and drop it in a excel window, If you see all data were in one column, then go to Data tab and Use Text to Column and then use Tab for delimiting your data.

See this link.