I frequently need to query for a list of voters/donors based on their Trail Blazer ID. Usually this information comes from an Excel spreadsheet that I have modified. Trail Blazer has no easy way to query a list of ID's and have the list returned.
Some time ago I created a tool that allows me do this. It will take a columnar list of ID's (usually copied from Excel) and turn them into a comma separated list that I can then paste into the SQL tab.
This is an advanced technique so only those who are willing to devote a little time to learn the process should proceed.
In the video below, I have created an example where I export data to an Excel file, add data to the file, and query for those records I updated in the spreadsheet. I have also placed the tool referenced in this video on our website.
Let me know if you find this useful.