I got fewer emails in the file than the search suggested

You exported 800 rows and only 210 have an email address. Here is how to work out which of the four causes it is.

1. The "Has email" filter was not on

By far the most common. Without it, the export contains every matching business, and email coverage varies enormously by market. With it, every row in the file has an address, and the count you saw before exporting is exact.

Fix: turn on Has email and look at the count again. The difference between the two counts is the email coverage in your market. Re-exporting inside 30 days does not re-bill the rows you already have — how credits work.

2. Your market genuinely does not publish email addresses

Map listings never carry an email; every address we hold was found on the business's own website. No website, or a website with only a contact form, means no address to find. Trades that get work by phone often have neither.

Check: compare the count with Has website on against the count with Has email on. If website coverage is high and email coverage is low, you are looking at contact forms. If both are low, the market is not online. The full explanation.

3. You are counting the wrong email column

There are nine email columns, not one. Email is the primary address and is the one to count. Contact email, Sales email, Individual email and the rest are a role split of the same set — a business with one published address fills Email and usually just one of the role columns, so counting non-empty cells across all nine will not tell you how many businesses you can contact. How the role split works.

4. You are reading the wrong column

Sorting a spreadsheet without selecting every column detaches the data from the names. If the emails look shifted or mismatched, re-open the original file and sort properly, or open the XLSX version instead. See opening the file correctly.

Were you charged for the empty ones?

Yes — a credit buys a business, not a field, and a row with only a name costs the same as a row with all 64 columns filled. That is exactly why the Has an e-mail on the website filter exists and why it is free to use. It is not a case for a refund, but it is a case for filtering next time.

If the file is broken in a way this article does not describe — systematically empty columns, or rows that plainly did not match your filters — that is a case for a refund, with no window. Refunds.

Improving coverage where the data is thin

• Export with Has website instead and use the Chrome extension on the sites that matter — it reads contact details from the page you are looking at.
• Widen the area rather than the category. Email coverage is more a property of the market than of the niche.
• Use Phone international and Phone type. In some markets calling is simply the channel that works.