Ad Hoc Query - Copy and Paste a spreadsheet column into query operator

We would like to be able to cut and paste values from an Excel column into ‘One of’ criteria values in Ad-Hoc Query. For example, we have an Excel containing a column of Lookup IDs or Zip codes and we want to paste these into the 'One of' Lookup ID or Zip code values so we don't have to retype the values into the Query.
  • Guest
  • Jun 29 2015
  • Reviewed: Voting Open
Organization Name (Please enter full organization name)
Reported Version
  • Attach files
  • Guest commented
    April 20, 2016 06:24

    We use this frequently in the Raiser's Edge and would certainly hope to be able to use it in BBCRM.

  • Jess Johnson-Shapter commented
    January 31, 2018 02:53

    Yes! Copy/pasting over 200 postcodes is not my idea of fun, especially when you cannot use postcode ranges in this instance.

  • Deb Hanson commented
    January 22, 2019 16:34


  • Lisa Fields commented
    May 23, 2019 15:04

    Any progress on this since 2015?