Formatting Spreadsheets

  • Last Updated: October 11, 2022
  • Published: February 28, 2020

For many users, uploading spreadsheets is the simplest and most efficient way to enter needs and offers into FDLP eXchange. However, there are things to keep in mind to simplify the process and prevent errors.

Making sure that spreadsheets are properly formatted prior to uploading is the first and most important step. When you try to upload a spreadsheet that is not formatted correctly, the system will not accept it. If your spreadsheet contains 250 items or less, this will be indicated with an error message. When you get to this screen, you can check the box that says “Only show entries with errors.” Then you can fix the errors and submit into eXchange.

exchange tip 231 Image

However, if your spreadsheet contains more than 250 items, this step is skipped. Instead, items without errors are automatically entered into eXchange, and those with errors are put into a new spreadsheet, where you will be able to correct them and resubmit.

Here are a few things to keep in mind when creating spreadsheets to help ensure a successful upload:

  1. Use the templates for uploading:
    • Spreadsheet Templates and Samples:
      Template for Needs Spreadsheet (.csv.xlsx)
      Template for Offers Spreadsheet (.csv.xlsx)
      Sample Needs Spreadsheet (.csv.xlsx)
      Sample Offers Spreadsheet (.csv.xlsx)
    • exchange tip 232 Image
    • Required fields in the templates are indicated in bold. Make sure that these fields are filled in for each item in a spreadsheet.
  2. The eXchange system requires that that information be entered in a specific way. For example, classification type should be input as “SuDoc” rather than as “Su Doc,” “SuDocs,” or “Superintendent of Documents.” The Data Dictionary spells all of this out and is a good resource to keep on hand when creating or reviewing spreadsheets.exchange tip 233 Image
  3. Do not add any formatting to the template. This includes:
    • Adding cover sheets
    • Using more than one tab per upload
    • Hiding, merging, or deleting columns or rows. If you are not using a non-required field, leave it blank, but do not remove the column.
  4. If you are using a spreadsheet created from a report run from your ILS, make sure that all date fields contain a single date or year. Remove all brackets, ranges, etc.
    image 233
  5. Make sure classification numbers are in the correct format and without extra characters or symbols.
  6. If you make all these changes and your spreadsheet still does not upload, copy and paste into a clean template. Sometimes there are formatting changes that are not apparent.