Reference guides

Practical notes for postal, country, holiday, and CSV data work.

Use these guides to understand source limits, choose the right workflow, prepare CSV inputs, and interpret exported reference fields.

Postal data

ZIP code vs postal code: what to check before enrichment

Compare ZIP codes and postal codes, understand country-specific formats, and choose the right reference workflow.

Read guide
Postal data

ZIP code centroid vs boundary: how to read map results

Understand why postal maps often show a point instead of an official delivery boundary.

Read guide
Postal data

ZIP code to timezone: accuracy notes for CSV enrichment

Use postal reference data to enrich approximate timezones while avoiding address-level assumptions.

Read guide
Country data

ISO alpha-2 vs alpha-3 country codes

Compare ISO2, ISO3, numeric country codes, and when each field is useful in data cleanup.

Read guide
Country data

Calling code vs country code in customer data

Separate phone calling prefixes from ISO country identifiers before exporting standardized rows.

Read guide
Country data

Currency code to country: common data caveats

Understand why a currency code can match several countries and how to review results.

Read guide
Holidays

Public holiday vs bank holiday vs observance

Compare holiday labels before using a country-year holiday table for business-day checks.

Read guide
Holidays

How to check business days from a CSV

Prepare a CSV date column, select country context, and export business-day review fields.

Read guide
CSV

Remove duplicate CSV rows without losing review context

Choose exact-row or key-based dedupe and keep a report of removed rows.

Read guide
CSV

CSV delimiter and quoted comma guide

Detect comma, tab, semicolon, and pipe delimiters and review malformed rows before export.

Read guide
Postal data

How to enrich postal code CSV data

Map postal-code columns, append reference fields, review unmatched rows, and export clean results.

Read guide