Importing Title Lists into Excel Spreadsheets
Once you have downloaded your title list in comma-delimited format, follow these steps:
Close your browser and open Excel.
Select Open in the File menu and select the comma delimited file you saved.
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
The spreadsheet opens in the Excel window. Adjust your column widths, fonts, etc., as necessary.
From this point, titles can be sorted by date, ISSN, title, or other ways by using the Sort function under the Data Menu.
ProQuest Technical Support
| Close window