A phone number list in CSV format is easy to download and easy to misread. Before buying, check the column meanings, how numbers are preserved and which facts come with the records. A small structural preview can reveal integration problems before they become paid import work.

Start with the delivered schema

Ask for the actual column names and format version. A marketing screenshot may omit JSON fields, empty values or timestamps that your importer needs.

The current Pinglake phone export includes these field groups. Historical orders retain their saved format version; individual values depend on the source and purchased scope.

Columns Meaning Import check
series, identifier, country Record type, phone identifier and country code Import identifiers as text and retain the international prefix
phone_type, carrier, line_type Number-type and carrier metadata Preserve unknown values; do not invent a classification
created_at Ingestion time Keep it separate from detection and export time
platform_states_json Purchased platform facts and their check timestamps Parse as JSON; do not split the field on commas
matched_software_id, matched_metric, matched_attributes_json Purchased matching platform and fact attributes Interpret together with the nested platform facts
number_region, metadata_sources_json Region hints and metadata provenance Distinguish supplied information from inferred information
number_time_zones_json, number_validation_status, number_validation_reason Candidate time zones and numbering-rule results These do not establish current location or reachability

Other columns can be present, including fields shared with email exports. The existence of a column does not mean every row has a value. A phone dataset does not automatically include names, employers or job titles.

Keep phone numbers as text

Spreadsheet software can interpret an identifier as a number, remove a leading plus sign or display long digit strings in scientific notation. Use the import dialog and explicitly set the identifier column to text before loading it.

Store one normalized identifier per value in your destination system. Do not append a second country code to a field that is already in international form. For country-specific checks, see the Brazil, India and Indonesia buying notes.

Expect quoted JSON inside CSV fields

CSV columns can contain commas and quotation marks. Use a CSV parser that understands quoting, then parse JSON columns separately. Splitting a line with a plain comma separator can turn one platform-facts field into several broken columns.

Retain the full nested facts if your workflow needs multiple purchased platforms. A single flattened matching field may not describe every fact represented in a multi-platform record.

Read a masked preview for structure

A masked preview is intended to help you check fields, value shapes and the selected criteria. It is not a free working contact list or a statistical guarantee about the entire inventory.

This is a fabricated illustration of three fields, not a real record or a complete export:

identifier,country,phone_type
+551****32,BR,mobile

Check whether your import accepts the encoding and headers. Confirm where nested facts live and how null, empty and unknown values are represented. Do not use a masked identifier for contacting or network validation.

Reconcile the order and manifest

Once the order file has finished generating, Pinglake provides a ZIP containing CSV data and a manifest. Check the manifest’s format version, order identifier, unique-row quantity and generation time against your order.

Count parsed CSV records rather than physical text lines: quoted CSV fields can contain line breaks. Keep the manifest with your import so you can later identify which delivery produced the records in your system.

Check facts separately from formatting

A clean CSV does not prove that a number is active, that a named person owns it or that a campaign is permitted. Use the valid, active and registered guide to evaluate those claims separately.

When the format fits your workflow, review pricing and choose a country. Confirm the selected fields, quantity and frozen quote before payment.