Clay Icon

Filter Companies in CSV File for Clay Table Management

Ā·
Ā·

I have a table in clay and I want to filter out certain companies. Can I upload a csv and filter out the companies in that csv

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Yes, you can exclude specific companies from your table using a CSV. Here's how: 1. First, import your CSV containing the companies you want to exclude into a Clay table 2. Then, when working with your main table: ā€¢ Go to "Add Table" > "Find Companies" ā€¢ Use the "Exclude" section to select the table containing your CSV data ā€¢ Choose the matching criteria (like social URL or domain)The results will automatically exclude any companies that match those in your reference table. Sources: Find Company overview | Documentation | Clay University Enhanced table exclusions, simplified email sequencers, Notion integration, Google Docs integration, and more!

  • Avatar of kushagra
    kushagra
    Ā·
    Ā·
    1. 1.

      Upload to the companies you want to exclude into a new table

    2. 2.

      Use lookup multiple rows enrichment in the original table to find matching companies (based on domain)

    3. 3.

      Apply the filter in original table to say where lookup column has no results

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Here's how to upload your companies into a new table: 1. First, create a new table: ā€¢ Open your workspace ā€¢ Click Create New > Table ā€¢ Choose Company Table 2. Then import your CSV file: ā€¢ Click Actions > Import > Import Companies From a CSV ā€¢ Upload your file or drag and drop it into the import area ā€¢ Select Create New Table > Import Sources: Import a File Create New Table

  • Avatar of Ross W.
    Ross W.
    Ā·
    Ā·

    Thank you Kushagra. Could you explain step 3?

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Here's how to exclude companies using your CSV table: 1. Go to "Add Table" > "Find Companies" 2. Look for the "Exclude" section in the search interface 3. Select your previously imported table (the one containing the companies you want to exclude) 4. Choose the matching criteria that Clay should use to identify duplicates, such as: ā€¢ Social URL ā€¢ DomainOnce configured, your search results will automatically exclude any companies that match those in your reference table. This exclusion feature helps avoid duplicates and ensures your current search doesn't include companies you've already identified elsewhere. Sources: Find Company overview | Documentation | Clay University Enhanced table exclusions, simplified email sequencers, Notion integration, Google Docs integration, and more!

  • Avatar of kushagra
    kushagra
    Ā·
    Ā·

    just a simple filter like this

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    To exclude specific companies from your search results: 1. Go to "Add Table" > "Find Companies" 2. Look for the "Exclude Companies" section in the search interface 3. Select any existing Clay table that contains the companies you want to exclude 4. Choose your matching criteria (like social URL or domain) to identify which companies to excludeThe search results will automatically filter out any companies that match those in your reference table. This exclusion feature helps ensure your current search doesn't include companies you've already identified elsewhere. Sources: Find Company overview | Documentation | Clay University Enhanced table exclusions, simplified email sequencers, Notion integration, Google Docs integration, and more!

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Hi Ross W.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: