BJA Imports Help

Please use these steps to import award information from the Grant Management System. Fiscal Year imports and quarterly/periodic updates all use the same import form.

  1. Please export your award data from GMS/ERT.
  2. Using Excel or another spreadsheet program,
    save the data as a comma-separated-values (CSV) file.
  3. In Excel, choose Save As from the File menu;
    choose CSV (Comma delimited) as the type.
  4. Save the file to your computer.
  5. Visit the import page
    while logged in as a "Coordinator."
  6. Use the Browse button to select the CSV file.
  7. Click Import.

Rows will be imported as awards when they include an Award Number and an OJP Vendor Number. The OJP Vendor Number must already have been assigned to a provider in the system.

Awards will be updated when they already exist in the Reporting Portal and when the spreadsheet contains updated data.

Help Book