Skip to main content
OCLC Support

Download large files for Internet Archive and HathiTrust collections and for My Selected Titles (KBART)

Selecting to download My Selected Titles or the titles from a very large collection may result in a truncated file of titles due to the size limits of text editors and spreadsheet applications.

Text editors and spreadsheet applications such as Notepad, TextEdit, and Microsoft Excel, have size limits. At the time of this writing, Microsoft's support website states that Excel worksheets are limited to 1,048,576 rows. See Microsoft Office Support for the current specifications and limits.

You will not be able to open very large files and edit them using the workflow you use for other knowledge base collections because you will not see all of the titles if there are over 1,048,576.

If you wish to download the titles from a very large collection such as a HathiTrust collection or an Internet Archive collection, or if you wish to download a file from My Files that includes all of your selected titles, the .txt file will download but will truncate your titles. 

  • In order to get a complete list of titles, you will need to use a spreadsheet program and a split command.
  • Alternatively, you can use programs made for very large files. Examples for Windows machines include Sublime and Notepad++.

 Note: For more information on downloading a KBART file of titles from a collection, see Collection-level settings in knowledge base collections, Titles.  For more information about downloading My Selected Titles, see Download a file from My Files.