Standardize postal addresses effectively, the prompt ensures that addresses are formatted consistently, removing any irregularities, abbreviations, or unnecessary information. The goal is to follow a universal format (or country-specific format if required).

Standardize the following postal address according to the official postal format for the given country. Ensure the address is formatted consistently by correcting abbreviations, ordering elements correctly (street, city, postal code, etc.), and including any missing information where possible. If the country is not specified, use an internationally recognized format.

Example Input:
123 Elm St, Apt 4b, Somecity, NY, 12345, USA
Flat 12, 456 Oak Rd, Newtown, NDL 5678, UK

Expected Output:
123 Elm Street, Apt 4B, Somecity, NY 12345, USA
Flat 12, 456 Oak Road, Newtown, NDL 5678, UK

The address: %address%

How to use this prompt on a CSV file?

Datablist allows you to take an entire CSV file and run prompts directly on every line. Whether you're cleaning data, generating summaries, or transforming text, this method saves hours.

Open Datablist (it's free)

The great news is that the prompt you need is already available in Datablist under the "Templates" section. No need to start from scratch! Simply select the template that fits your task, and it’s ready to run on every line of your CSV. This makes it even easier to transform your data with just a few clicks.

Import your CSV file in Datablist. Then select "Enrich" from the header.

Select Enrich
Select Enrich

Then select the template: Normalize/Standardize postal addresses

Select Enrich
Select Template

Replace the variables from the prompt with your collection's properties using {{

Use your data
Define variables using your collection's properties