Import Prior Art References from a Spreadsheet

Share this article:

 

AppColl integrates with EspaceNet, allowing you to retrieve already filed prior art references for issued matters. Click here for more details. The below process is still available and is necessary for pending matters.

If you maintain prior art references in spreadsheets or other means outside of AppColl, you are able to import them into AppColl using the spreadsheet file, attached below.  

Attachments

Prior Art Import Template.xlsx

 Populate the Spreadsheet

  1. Click the Prior Art Import Template link above.
  2. Open the downloaded Prior Art Import Template.
  3. Fill in the mandatory columns as indicated in Row 2. The remaining rows are optional. Please note: When you paste the data from another source, use Paste Values (Paste Special on Mac) and not just Ctrl-V or Cmd-V. This will prevent changes in formatting. 
  4. Remove column A.
  5. Remove the instructions in Rows 2-6, but keep Row 1 intact, as this is needed by AppColl. 

  1. Save the spreadsheet. Please note that spreadsheets can be saved as xlsx or csv files. 

 Import the Spreadsheet

  1. Go to the Prior Art module.
  2. Click the Import CSV or XLSX link.

  1. Click the Choose File button to browse for and select our saved spreadsheet.
  2. Click Import

  1. AppColl will check the file for any errors. Cells in Yellow are simply warnings and can usually be ignored. Review any Warning messages. 
  2. If there are no Red errors, click the Import All Rows button.

  1. If there are Red errors, hover over each error row to read the error message and click the Pencil icon to correct the field. Cells in Red have an error that must be fixed.
  2. At any time, you can click the Save and Validate button to see any fixed row's error disappear.
  3. Once all errors are fixed, click the Import Valid Rows button.

  1. When the import is complete, you should see a message indicating success.