Capital IQ:

1. Mouse over Screening, and click Companies.
2. Find the box labeled Investment/Advisory Firms.  Under it, click Investment Style Managed.
3. Under Available Items, scroll down and add Venture Capital to Selected Items.  Add to criteria.
4. Under Company Details, Click on the Geographic Locations.
5. Search for or browse and select your city or country. Add to criteria.
6. Select other criteria if desired, and click on Run Search.  (For example, under Investment Criteria/ PE Funds, you will find things like Industries of Interest and Company Stages)
7. After viewing results, click on Add Display Columns to display other information. Then you can export to Excel.

Preqin:

In Preqin Pro view (vs Classic):

1. Click Search For from the top menu and select Fund Manager.
2. Under Asset Class, select Private Equity.
3. Under Strategy, select Venture Capital.  (Or click to expand to select more specific types of venture capital).
4. Select any geographies under Location.
5. Click More Filters to add any additional criteria, such as Sector.  Useful filters in Preqin include estimated dry powder, total amount raised, and ESG/Ethos.
6. Before exporting, click Manage Columns to customize what data you would like to include in your excel file.
7. Click Export.

PitchBook:

1. Go to Screener and choose Investors & Buyers.
2. From Investor Type choose Venture Capital.
3. From Investor Location page choose geography.
4. From Stated Preferences page, choose industry and verticals.
5. Add any remaining criteria and hit search.