# Filter data by Upload File

**URL:** <https://community.hubspot.com/t/filter-data-by-upload-file/82677>\
**Category:** CRM\
**Tags:** free\
**Created:** [June 5, 2023, 5:53pm UTC](https://community.hubspot.com/t/filter-data-by-upload-file/82677 "2023-06-05T17:53:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JGray30](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jgray30/32/7787_2.png) [@JGray30](https://community.hubspot.com/u/JGray30)\
**Post date:** [June 5, 2023, 5:53pm UTC](https://community.hubspot.com/t/filter-data-by-upload-file/82677/1 "2023-06-05T17:53:30Z")

</div>

Hi

I have uploaded data from an Excel Spreadsheet, I want ot make sure every record has uploaded. The only way I figured I could do that, is to create a filter by the “Original Source Drill Down 2” column that states “Prospects V2”

My spreadsheet has 571 records, some were rejected which I have fixed. is there any way I can create a View under contacts that shows only those records that were imported from the spreadsheet “Prospects V2”

Thank you

---

<div class="post-metadata">

**Author:** ![jolle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jolle/32/44040_2.png) [@jolle](https://community.hubspot.com/u/jolle)\
**Post date:** [June 5, 2023, 6:52pm UTC](https://community.hubspot.com/t/filter-data-by-upload-file/82677/2 "2023-06-05T18:52:19Z")

</div>

Hey @JGray30, thanks for reaching out!

Just like you mentioned, the “Original source drill-down 2” contact property will contain the name of the import (as long as that is what originally created them).

You can either:

1. Head to **Contacts \> Contacts** and create a saved view/add a filter for “Original source drill-down 2” = “Import Name”
2. Or head to **Contacts \> Lists** and create a list for “Original source drill-down 2” = “Import Name”

Just be sure to check out the results of your import to see if there were any duplicate contacts. You may not see a match in the number of contacts between your spreadsheet and the records in HubSpot if any of them had the same email address.

Hope this helps!!

---

<div class="post-metadata">

**Author:** ![JGray30](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jgray30/32/7787_2.png) [@JGray30](https://community.hubspot.com/u/JGray30)\
**Post date:** [June 6, 2023, 5:41am UTC](https://community.hubspot.com/t/filter-data-by-upload-file/82677/3 "2023-06-06T05:41:51Z")

</div>

Hi

I am creating or trying to create the list, based on my report "

Prospect Reject V2 ACT.xlsx

Using the **Original source drill-down 2** contains any of **Prospects Reject V2 ACT.xlsx**. It does not create the list?

---

<div class="post-metadata">

**Author:** ![jolle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jolle/32/44040_2.png) [@jolle](https://community.hubspot.com/u/jolle)\
**Post date:** [June 6, 2023, 12:34pm UTC](https://community.hubspot.com/t/filter-data-by-upload-file/82677/4 "2023-06-06T12:34:10Z")

</div>

@JGray30 go to a contact that you know was created in that import and check out their **Original source drill-down 2** value. That’s what you can use in your list!