# If you upload a sheet and forget to map the email address, can that skew your segments?

**URL:** https://forum.mautic.org/t/if-you-upload-a-sheet-and-forget-to-map-the-email-address-can-that-skew-your-segments/4963
**Category:** Product Support
**Created:** [August 19, 2016, 3:11am UTC](https://forum.mautic.org/t/if-you-upload-a-sheet-and-forget-to-map-the-email-address-can-that-skew-your-segments/4963 "2016-08-19T03:11:29Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [August 19, 2016, 3:11am UTC](https://forum.mautic.org/t/if-you-upload-a-sheet-and-forget-to-map-the-email-address-can-that-skew-your-segments/4963/1 "2016-08-19T03:11:29Z")

</div>

I think I may have uploaded a list that did not include email addresses and maybe that is why my database that shows only 1 record (as it should) actually shows 200 contacts in some of my segment counts., but show nothing when you drill down into them.  
  
  
  
What database table can I go to to delete these records if that be the case? Also, if that was the reason for all of this, can we develop a solution to prevent an upload without email addresses mapped?

---

<div class="post-metadata">

### Author: ![lead2crm](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lead2crm/32/1634_2.png) [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [August 19, 2016, 3:11am UTC](https://forum.mautic.org/t/if-you-upload-a-sheet-and-forget-to-map-the-email-address-can-that-skew-your-segments/4963/2 "2016-08-19T03:11:29Z")

</div>

I think I may have uploaded a list that did not include email addresses and maybe that is why my database that shows only 1 record (as it should) actually shows 200 contacts in some of my segment counts., but show nothing when you drill down into them.

What database table can I go to to delete these records if that be the case? Also, if that was the reason for all of this, can we develop a solution to prevent an upload without email addresses mapped?
