How to create a Fasta file using info from a Excel file

Question

[2822462298]

I have an excel file which looks like this:

Genex AAAAA
Geney TTTTT
Genez GGGGG

How to convert it into a fasta file like:

>Genex
AAAAA
>Geney
TTTTT
>Genez
GGGGG

[lakhujanivijay]

What have you tried so far? Please do not expect ready made answers.

Answer 1

[Mensur Dlakic]

Save your Excel file as comma-delimited, say sequences.csv.

awk -F , '{print ">"$1"\n"$2}' sequences.csv > sequences.fas