Import Query: Introduction

With Import Query, multiple PubMed queries or author names can be saved to an Excel or CSV (Comma-Separated) file and imported to query PubMed. The file can also specify Regular Expression / Wildcard / Boolean searches to run on each set of results.

Import Query will use the values in the first column (column A in Excel) to query PubMed. The PubMed query  has to be surrounded by a pair of braces {}. It has to comply with PubMed Query language. The other columns specify Regular Expression / Wildcard / Boolean Searches. To search using a Regular Expression, prefix the search term with [R]. To search using Wildcards, prefix the search term with [W]. For Boolean search use [B]. If no prefix is specified, the default is Wildcard search.

For more information on Regular Expression / Wildcard / Boolean searches, including how to search on multiple-word phrases, see the Regular Expression / Wildcard Search Help Page and the Boolean Search Help Page.
 

Author Name List

To query PubMed on a list of authors, create an Excel or CSV file with names listed in the first column (column A in Excel), one name per row.

The Import Names Wizard allows you to choose whether to use all names in one search, or use each name in its own search.

PubMed Query List

To import multiple PubMed queries, specify each query in the first column of a row (column A in Excel0.

The PubMed query must be in braces {} and can have in it any characters defined in PubMed query  language, e.g. {"gene expression profiling"[MeSH] AND ("lung"[MeSH Terms] OR lung[Text Word]) AND ("carcinoma, non-small-cell lung"[MeSH Terms] OR nsclc[Text Word]) AND hasabstract[text] AND English[Lang] AND ("human"[MeSH Terms] OR "hominidae"[MeSH Terms]) AND ("2001"[PDAT] : "2004"[PDAT])}. The easiest way  to get a complex PubMed query is to formulate it with limits on the PubMed search page, perform the search, click on Details subheading to switch to Details view, and copy Query Translation text from the text box.