I have an Excel file including positions like below (based on hg 18) chr1:195005320-195066067
... I want to known which genes are located in each region in a seprate column in front of each region.Thanks
Or you may first map your NCBI36 (hg18) regions to GRCh37 (hg19) using the Ensembl Assembly mapper (http://www.ensembl.org/tools.html) and then use BioMart for the most recent version of Ensembl to retrivee your genes.
warning: your link is directed to GRCh37 not hg18.
thanks but in biomart there is not hg 18.That is hg 19.
it is hg18 if you trace the Ensembl archive back to v54. you may then build your query based on hg18, although the genes in there will be from v54 too.