---
title: "Validate a Linked Helper export"
url: "https://lookvalid.com/integrations/linkedhelper.md"
canonical_url: "https://lookvalid.com/integrations/linkedhelper"
last_updated: "2026-10-22"
type: "how-to"
summary: "A guide to checking the phone numbers in a lead list you exported from Linked Helper's Data Export feature as a CSV file."
related: ["https://lookvalid.com/integrations.md", "https://lookvalid.com/docs/api/phone.md", "https://lookvalid.com/docs/quickstart.md"]
---

# Validate a Linked Helper export

A guide to checking the phone numbers in a lead list you exported from Linked Helper's Data Export feature as a CSV file.

Phone numbers in an exported prospect list arrive in every shape: with and without a country code, with brackets, dots or extension text pasted in. Calling or texting from that file means wrong dials and a lot of manual cleanup in the dialer. Normalizing the numbers in the file you already own, before it is imported into a calling tool, saves the cleanup later.

## What LookValid checks

- [Phone Numbering-Plan Validation](https://lookvalid.com/products/phone.md): Checks each number against its country numbering plan and returns one international format, so duplicates across rows can be matched. Returns the number type from the plan (mobile, fixed line, VoIP, toll free and others), so you can split a texting list from a calling list. It cannot tell whether a line is active. (1 credit per valid number)
- [Country Calling Codes](https://lookvalid.com/products/country-code.md): Explains calling codes for the countries in your list, with national number lengths, for rows where the country is unclear. (1 credit per lookup (an unknown code, country or name is free))
- [Phone Spam Check](https://lookvalid.com/products/phone-spam.md): Returns public consumer complaint counts for a number, to help you spot rows that look like they belong to a reported number. (1 credit per number with complaints on record)

## Connect it in four steps

1. Create a LookValid account, issue a key under API keys in the dashboard, and use Linked Helper's Data Export to save your leads as a CSV file on your own computer, choosing the columns to include (keep the phone column).
2. Run the script in a terminal where LOOKVALID_API_KEY is set for that session only, so the key is not stored in the export or the code.
3. For each row, send the number to the phone endpoint; on found:false keep the row in a separate file for manual review, and stop the run on an error answer with its code.
4. Add phone_e164, phone_kind and phone_ok as columns in the copy, then dial or text from phone_e164 and filter on phone_kind.

A Python script on your own computer that reads the exported file row by row and writes a cleaned copy. The call is `POST https://YOUR_API_HOST/v1/phone`.

```python
import json
import os
import urllib.error
import urllib.request

API_URL = "https://YOUR_API_HOST/v1/phone"


def clean_linkedhelper_phone(value):
    request = urllib.request.Request(
        API_URL,
        data=json.dumps({
            "phone": value,
        }).encode(),
        headers={
            "Authorization": "Bearer " + os.environ["LOOKVALID_API_KEY"],
            "Content-Type": "application/json",
        },
        method="POST",
    )
    try:
        with urllib.request.urlopen(request, timeout=30) as response:
            result = json.load(response)
    except urllib.error.HTTPError as error:
        failure = json.load(error)["error"]
        raise RuntimeError(failure["code"] + ": " + failure["fix"])
    if not result["found"]:
        return None
    return {
        "phone_e164": result.get("data", {}).get("e164"),
        "phone_kind": result.get("data", {}).get("number_type"),
        "phone_ok": result.get("data", {}).get("valid"),
    }
```

| Response field | Goes into |
| --- | --- |
| `data.e164` | phone_e164 |
| `data.number_type` | phone_kind |
| `data.valid` | phone_ok |

## Without code

Without a script, load the exported file into a spreadsheet or an automation platform that loops over rows and add a generic HTTP request step that posts each number to the phone endpoint with your key in the Authorization header. Map the international format and the type into new columns. No dedicated app is needed and the tool the file came from is never touched.

## Questions

### What does a full list cost in credits?

One check per row at the price on the pricing page.

### Do you connect to my Linked Helper account?

No. This guide is only about a file you exported and keep. Nothing here connects to, drives or collects from the tool.

### Can I tell from the result that a number is reachable?

No. The phone check reads the numbering plan, so it confirms the shape and type of a number, not whether it is switched on.

## Sources

- [Linked Helper: Data Export feature page](https://www.linkedhelper.com/features/data-export), read 2026-10-18

## Related

- [LookValid integrations](https://lookvalid.com/integrations.md)
- [Phone Numbering-Plan Validation reference](https://lookvalid.com/docs/api/phone.md)
- [Quickstart](https://lookvalid.com/docs/quickstart.md)