UK Postcode Lookup (Bulk)

Add council, region, constituency and latitude/longitude to a list of UK postcodes.

๐Ÿ”’ Runs in your browserโšก Instant results๐Ÿ‘ค No sign-upโญ Downloads with Pro

Add location data to a list of UK postcodes

Got a customer list, delivery addresses or staff records with postcodes? Add the local council, ward, region, country, parliamentary constituency and exact latitude and longitude to every row in seconds, ready for maps, sales territories and reports.

Great for

Postcode data comes from Postcodes.io, a open service built on Office for National Statistics and Ordnance Survey open data. Contains OS data ยฉ Crown copyright and database right. Contains Royal Mail data ยฉ Royal Mail copyright and database right. Source: Office for National Statistics licensed under the Open Government Licence.

Frequently asked questions

Is my file uploaded?

No. Only the postcodes themselves are sent to postcodes.io to look them up. Names, emails and everything else in your file stay on your device.

Why are some postcodes not found?

They may be mistyped, very new, or retired. These rows are marked in the "Postcode check" column.

How many postcodes can I look up?

Thousands at a time. They are looked up in batches of 100.

More data analysis & spreadsheet tools

๐Ÿ“Š
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
๐Ÿ“ˆ
Instant DashboardPower BI style dashboard from any Excel file
๐Ÿ”
CSV โ†” Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
๐Ÿงฉ
Excel File MergerCombine many spreadsheets into one
๐Ÿงน
Duplicate RemoverFind and delete duplicate rows
๐Ÿ“ˆ
Chart MakerPaste data, get a chart, download PNG or PowerPoint
๐Ÿ—„๏ธ
Excel to SQLCREATE TABLE & INSERT statements from any spreadsheet
๐Ÿงฎ
SQL Query BuilderBuild SQL with clicks, explained in English, run on your data
โœจ
SQL FormatterMake messy SQL clean and readable
๐Ÿงฝ
Data CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
๐Ÿ”—
VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
๐Ÿ†š
Compare Two Excel FilesSee added, removed and changed rows and cells
๐ŸงŠ
Pivot Table BuilderGroup, total and chart your data with clicks
๐ŸŒ
Web Table to ExcelCopy tables from websites into clean Excel
๐Ÿ”ฃ
JSON โ†” Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
๐Ÿ“
UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
๐Ÿ”„
Unpivot / Reshape DataColumns to rows and back, ready for Power BI
๐ŸŽฏ
Outlier FinderSpot unusual values, typos and errors
๐Ÿ“
Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
๐ŸŽฒ
Random Sample PickerRandom rows for audits, surveys and prize draws
๐Ÿงช
Test Data GeneratorRealistic fake UK data for testing and demos

See all 108 tools โ†’