Print page  |  Close window

		Quick Reference Guides ProQuest Technical Support

Title List

Use this page to download or view a complete list of the publications available to your institution through ProQuest. On this page you can:

• View Title Lists
• Download Title Lists
• Import Title Lists into Excel
• Make Title Lists available to patrons

Viewing Title Lists

To view title lists, follow these steps:

1. Make sure you are on the Collection Information, Title List page:

• Click the Collection Information tab, and make sure the Title List tab is selected.
• Or, select View/download ProQuest title lists from the Quick Picks drop-down menu.

2. If you have access to multiple Accounts or clients, select the desired Account from the drop-down menu located above the tabs. (If there is only one client available, the Account is static text, rather than a pull-down).
3. Select the desired database(s) from which you want to retrieve titles.
   To select multiple databases, Windows users should hold down the Ctrl key while clicking on databases. Macintosh users should hold down the Apple/Command key while clicking on databases.
4. Check Full Text Titles Only if you want to limit the results to publications available in full text format.
5. Select the information you want to view for each publication. You can use the Select/Clear all fields links to quickly select or clear all fields.
6. Select the Delivery Format you want.
7. Click Create Title List.
8. What you see next depends on the Delivery Format you selected:

• HTML
  You see the list on the screen.
• Microsoft Excel
  You will see a spreadsheet in the browser window.
• Text-only ASCII
  You see the text file in your browser.
• ProQuest
  You see the title list in your browser.

^back to top

Make Title Lists available to patrons

To make your title list available to your patrons, follow these steps:

1. Make sure you are on the Collection Information, Title List page:

• Click the Collection Information tab, and make sure the Title List tab is selected.
• Or, select View/download ProQuest title lists from the Quick Picks drop-down menu.

2. If you have access to multiple Accounts or clients, select the desired Account from the drop-down menu located above the tabs. (If there is only one client available, the Account is static text, rather than a pull-down).
3. Select the desired database(s) from which you want to retrieve titles.
   To select multiple databases, Windows users should hold down the Ctrl key while clicking on databases. Macintosh users should hold down the Apple/Command key while clicking on databases.
4. Check Full Text Titles Only if you want to limit the results to publications available in full text format.
5. Select the information you want to view for each publication. You can use the Select/Clear all fields links to quickly select or clear all fields.
6. In the Delivery Format section, click URL. Then click Create Title List.
   You see the Create a Title List page.
7. Copy the resulting URL in the URL field (in the yellow highlighted area) and paste it into a browser Address bar.
   Then, either save the link or drag the address bar contents to your desktop to create a shortcut to the title list.

^back to top

Downloading Title Lists

To download your title lists, follow these steps:

1. Make sure you are on the Collection Information, Title List page:

• Click the Collection Information tab, and make sure the Title List tab is selected.
• Or, select View/download ProQuest title lists from the Quick Picks drop-down menu.

2. If you have access to multiple Accounts or clients, select the desired Account from the drop-down menu located above the tabs. (If there is only one client available, the Account is static text, rather than a pull-down).
3. Select the desired database(s) from which you want to retrieve titles.
   To select multiple databases, Windows users should hold down the Ctrl key while clicking on databases. Macintosh users should hold down the Apple/Command key while clicking on databases.
4. Check Full Text Titles Only if you want to limit the results to publications available in full text format.
5. Select the information you want to view for each publication. You can use the Select/Clear all fields links to quickly select or clear all fields.
6. Select the Delivery Format you want.
• HTML to download an HTML page.
• Microsoft Excel to use in Microsoft Excel.
• Text-only ASCI to download a text file.
7. Click Create Title List.
8. How you proceed next depends on the format you selected:
   • HTML
     1. You see the list on the screen.
     2. Select Save As from the File menu.
     3. Navigate to where you want to save the file.
     4. Click Save.
     5. The file is now ready to edit or add to your site.
   • Microsoft Excel
   1. You will see a spreadsheet in the browser window.
   2. Select Save As from the File menu.
   3. Change the Save as type: option:
   • If you have Excel installed on your computer, save as an Excel worksheet.
   • If you don't have Excel on your computer, save the file as a comma delimited text file and follow the directions below to import the information into Excel.
   4. Click Save.
   5. The file is now ready to edit.
   • Text-only ASCII
   1. You see the text file on your screen.
   2. Select Save As from the File menu.
   3. Navigate to where you want to save the file.
   4. Change the Save as Type option to Text.
   5. Click Save.
   6. The file is now ready to edit.
   • ProQuest
     1. You see the title list in your browser.
     2. Select Save As from the File menu.
     3. Navigate to where you want to save the file.
     4. Change the Save as Type option to Text.
     5. Click Save.
     6. The file is now ready to upload to ProQuest Library Holdings.

^back to top

Importing Data into an Excel Spreadsheet

Follow these steps to import the csv file into Excel:

1. Download the desired title list.
2. Close your browser and open Excel.
3. Choose Open from the File Menu and select the comma delimited file you saved.
4. The Excel Wizard will ask a few questions for formatting. Choose these settings:
• Data type: delimited
• Delimiters: comma (deselect any other settings)
• Column data format: general
5. Click Finish.
6. The spreadsheet will open in the Excel window. Adjust your column widths, fonts, etc., as necessary.

You can now sort titles by date, ISSN, title, or any other column by using the Sort function under the Data Menu.

^back to top

Databases—select databases to include in title list

ProQuest provides access to a wide variety of databases. This option lets you limit the results to those databases your library subscribes to, or to provided targeted title lists.

Report Columns—select fields to include in the list

Report Columns section lets you select the information you want to view or download. Most of the options are self-evident, two may need more explanation:

• Scholarly/Peer Reviewed Indicates whether a publication is scholarly, including peer reviewed.
• Summary for all full text formats Shows coverage for ALL “full text” formats combined (such as text, text+graphics, and .pdf). This lets you quickly compare ProQuest title lists with other electronic resources.

Delivery Format  

The Delivery Formats section lets you select the format to use when viewing and downloading your title list:

• HTML Select this format to view or save a web page.
• Microsoft Excel Select this format to view or save an Excel spreadsheet.
• Text-only ASCII Select this format to view or save a text file.
• ProQuest Select this format to view the title list in the format used to upload to ProQuest Library Holdings.
• URL Select this format to create a link to the Title List for your patrons to view.

Print page  |  Close window