Skip to main content
OCLC Support

Why didn't my KBART load? I’m using an Excel file.

Symptom
  • Collection history shows invalid records after attempting to upload KBART.

Applies to
  • WorldShare Collection Manager
Resolution

While Excel is useful in many ways, it often changes the integrity of the data.

Some examples of how Excel changes data include: 

  • rounds/truncates decimal points
  • changes extremely long digits integers to scientific notation
  • removes leading zeros from digit strings
  • changes date formats
  • changes encoding on special characters
  • changes strings like "01-01" to "1-Jan"

If you choose to use Excel, we recommend that you copy data from a second text editor application into a new text-formatted MS Excel workbook. Please see instructions below. 

  1. Open a new blank workbook in Excel.
  2. Select all cells in this workbook.
  3. Format these cells as "text".
  4. Open your KBART file in a separate Text Editor application (e.g. Notepad++, TextEdit).
  5. In the text editor, select and copy all the data from your KBART file.
  6. Paste the data into the blank Excel workbook from step 1.
  7. Make any needed adjustments to the KBART file (remove titles, change coverage, etc.).
  8. Important: check that you have a a unique numerical value for the oclc_entry_id field of each title.
  9. Save file in appropriate encoding level (e.g. UTF-8, UTF-16).
  10. Upload the KBART file in WorldShare Collection Manager within the Titles accordion.
Additional information

For additional information about KBART files, please see KBART values and formatting. 

See Create a knowledgebase collection for more detail on creating or updating a collection with a KBART file

Page ID
32152