Excel mangles NCBI gene symbols

Using Microsoft’s Excel for bioinformatics work sucks, but sometimes a spreadsheet is the best format for communicating results to other scientists.

The program’s default behavior mangles some NCBI gene symbols when you import them from a text file. Here is how to deal with it. Suppose you have the following list of gene symbols,

gene_list

and you import them into Excel. The middle three gene symbols get treated as dates:

wrong

This definitely ruins your day.

The trick to avoiding this problem is to go to the third step of the Text Import Wizard and set the Column data format to “Text”:

step_03_with_arrow

Then the gene symbols import correctly:

final

This entry was posted in science and tagged , , , , , . Bookmark the permalink.

One Response to Excel mangles NCBI gene symbols

  1. That boggles my mind. Rich, brilliant scientists having trouble with Excel? Simple problems too. Wow.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>