Video: Quick Tip - How to Import Gene Symbols into Excel
This video provides a solution to a common problem encountered when pasting genetic data into Microsoft Excel. Excel will auto-convert some types of text into calendar dates that no longer correspond to the original information. This corruption of data will lead to errors in any downstream application of the data, such as searching for products or placing orders. Here, we offer a way to avoid these errors caused by auto-conversion of data to calendar dates.
We hope that this video will help you to avoid inadvertent errors when importing gene names into Excel.
- Create a Cherry-pick library - Begin here to turn your gene list into an RNAi Library
- For more information on this topic, see this publication:
Barry R Zeeberg, Joseph Riss, David W Kane, Kimberly J Bussey, Edward Uchio, W Marston Linehan, J Carl Barrett and John N Weinstein "Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics" BMC Bioinformatics 2004, 5:80 doi:10.1186/1471-2105-5-80