Project Name
AI Address Checker Tool
Year
2024
About Project
The AI Address Checker Tool is a smart solution designed to streamline and validate address data by automatically extracting and verifying location details like city and area from full address strings. This tool was developed to solve the issue of inconsistent address formats between internal business systems and third-party delivery companies.
By integrating AI-powered text extraction and geocoding APIs, the tool intelligently analyzes free-text address entries—whether typed manually or exported from systems—and converts them into standardized, verifiable location data. This helps improve delivery accuracy, reduce manual errors, and enhance operational efficiency for logistics, e-commerce, and delivery-based businesses.
Keywords
B2B
Web
AI
UX Case Flow
The Challange
Pain Points & Insights
Strategic Directions
The Challange
Pain Points & Insights
Strategic Directions
UX Approach
User Flow
Hight Fidelity (Hi-Fi) Prototype
The Challange
Pain Points & Insights
Strategic Directions
UX Approach
User Flow
Hight Fidelity (Hi-Fi) Prototype
UX Approach
User Flow
Hight Fidelity (Hi-Fi) Prototype
The Challenge
From Lunaria business system, we export
This file includes customer data (Customer Name - Order Number - Full Address and more).
The Case is :
Lunaria’s system only exports the full address as a single field.Lunaria’s system cannot be modified, nor can it be adjusted each time the delivery company changes.
From Lunaria business system, we export
This file includes customer data (Customer Name - Order Number - Full Address and more).
The Case is :
Lunaria’s system only exports the full address as a single field.Lunaria’s system cannot be modified, nor can it be adjusted each time the delivery company changes.
Lunaria Orders File.xlsx
Lunaria Bloom business system
Lunaria Bloom business system
Lunaria Orders File.xlsx
Lunaria Orders File.xlsx
But The file format of this Address data doesn’t match what the current delivery company expects & Lunaria’s system cannot be modified. The Address data it has to be in Three columns ( Full Address + City + Area )
Delivery Company System Accepted Format
But The file format of this Address data doesn’t match what the current delivery company expects & Lunaria’s system cannot be modified. The Address data it has to be in Three columns ( Full Address + City + Area )
Delivery Company System Accepted Format
Delivery Company System Accepted Format
Pain Points & Insights
Current Solution is : Manual Editing
Pain Points & Insights
Current Solution is : Manual Editing
Why not Manual Editing ?
Why not Manual Editing ?
Human error risk
Human error risk
Human error risk
Especially under heavy orders volume
Especially under heavy orders volume
Especially under heavy orders volume
Poor scalability
Poor scalability
Poor scalability
The system Can’t handle growth.
The system Can’t handle growth.
The system Can’t handle growth.
Slow fulfillment
Slow fulfillment
Slow fulfillment
Long time from order to delivery.
Long time from order to delivery.
Long time from order to delivery.
Strategic Directions
External APIs + Python
~70% accuracy
1st Solution
Simply the API takes a normally written address , for example :
” 2nd building after Omar Market, side street off El Haram St., Giza” and then converts it into map coordinates. That means it extracts the Latitude and Longitude, which are the exact numbers that pinpoint the location on a map.
Pros
Very accurate and can analyze addresses even if they’re not written in a specific format.
Handles Arabic well — no need for the address to be in English.
Cons
These APIs returned multiple options for cities or areas, especially in regions with similar names.
We still had to manually clean and correct results — not a scalable or efficient solution.
1st Solution
External APIs + Python
~70% accuracy
Simply the API takes a normally written address , for example :
” 2nd building after Omar Market, side street off El Haram St., Giza” and then converts it into map coordinates. That means it extracts the Latitude and Longitude, which are the exact numbers that pinpoint the location on a map.
Pros
Very accurate and can analyze addresses even if they’re not written in a specific format.
Handles Arabic well — no need for the address to be in English.
Cons
These APIs returned multiple options for cities or areas, especially in regions with similar names.
We still had to manually clean and correct results — not a scalable or efficient solution.
2nd Solution
Customized AI Model
~92% accuracy
We trained the custom AI model using a reference file from the delivery company, which includes cities and their corresponding areas. This helps the model accurately identify and extract structured location data from messy, unstructured addresses.
The AI model is optimized to select best match, not just multiple guesses , trained on Egyptian cities, areas, and common misspellings and also Arabic language. The extracted file from the AI Model is ready to be uploaded directly to the Delivery Company.
The AI model that we tried & trained Tested on 500+ records with 98.7% accuracy.
Pros
Optimized to select best match, not just multiple guesses
OpenAI custom model performs best in understanding freeform Arabic/English mix, landmarks, and inconsistent input — especially if trained well on your specific data (e.g. Egyptian delivery addresses).
Minimizes the risk of human error , by not doing the manual change and address analyze.
Cons
It's a matter of time and training the model, with continuous monitoring to reach 100% efficiency.
Needs a good UX solution
2st Solution
Customized AI Model
~92% accuracy
We trained the custom AI model using a reference file from the delivery company, which includes cities and their corresponding areas. This helps the model accurately identify and extract structured location data from messy, unstructured addresses.
The AI model is optimized to select best match, not just multiple guesses , trained on Egyptian cities, areas, and common misspellings and also Arabic language. The extracted file from the AI Model is ready to be uploaded directly to the Delivery Company.
The AI model that we tried & trained Tested on 500+ records with 98.7% accuracy.
Pros
Optimized to select best match, not just multiple guesses
OpenAI custom model performs best in understanding freeform Arabic/English mix, landmarks, and inconsistent input — especially if trained well on your specific data (e.g. Egyptian delivery addresses).
Minimizes the risk of human error , by not doing the manual change and address analyze.
Cons
It's a matter of time and training the model, with continuous monitoring to reach 100% efficiency.
Needs a good UX solution
UX Approach
As a result, the AI model (2nd solution) proved to be the most effective solution for this use case. It is now UX's turn to design a seamless, guided tool for this solution , the “AI Address Checker Tool” , this tool has to be :
All-in-One Tool:
Everything in one place — no switching tabs or editing files manually.
Error Reduction:
Minimizes the risk of human error.
Scalable:
Supports bulk file processing for thousands of entries.
Preview :
Able to preview your files rows of data , before downloading , and then apply the adjustments and then downloading again.
All-in-One Tool:
Everything in one place — no switching tabs or editing files manually.
All-in-One Tool:
Everything in one place — no switching tabs or editing files manually.
Error Reduction:
Minimizes the risk of human error.
Error Reduction:
Minimizes the risk of human error.
Scalable:
Supports bulk file processing for thousands of entries.
Scalable:
Supports bulk file processing for thousands of entries.
Preview :
Able to preview your files rows of data , before downloading , and then apply the adjustments and then downloading again.
Preview :
Able to preview your files rows of data , before downloading , and then apply the adjustments and then downloading again.
All-in-One Tool:
Everything in one place — no switching tabs or editing files manually.
Error Reduction:
Minimizes the risk of human error.
Scalable:
Supports bulk file processing for thousands of entries.
Preview :
Able to preview your files rows of data , before downloading , and then apply the adjustments and then downloading again.
AI Analyze the full address column
user preview the analysis result
NO Issues
Export
the file matched to the delivery company’s format.
With Issues
User upload orders file.xlsx
Write the prompt to adjust the result, & regenerate
User Flow
Current Solution is : Manual Editing
As a result, the AI model (2nd solution) proved to be the most effective solution for this use case. It is now UX's turn to design a seamless, guided tool for this solution , the “AI Address Checker Tool” , this tool has to be :
User Flow
Current Solution is : Manual Editing
As a result, the AI model (2nd solution) proved to be the most effective solution for this use case. It is now UX's turn to design a seamless, guided tool for this solution , the “AI Address Checker Tool” , this tool has to be :
AI Analyze the full address column
user preview the analysis result
NO Issues
Export
the file matched to the delivery company’s format.
With Issues
User upload orders file.xlsx
Write the prompt to adjust the result, & regenerate
User upload orders file.xlsx
AI Analyze the full address column
user preview the analysis result
NO Issues
Export the file matched to the delivery company’s format.
Write the prompt to adjust the result, & regenerate
With Issues
Hight Fidelity (Hi-Fi)
Prototype
As a result, the AI model (2nd solution) proved to be the most effective solution for this use case. It is now UX's turn to design a seamless, guided tool for this solution , the “AI Address Checker Tool” , this tool has to be :
The user uploads the “Orders File.xlsx”
This file contains an “Address” column. which needs to be analyzed to extract the city and area from each address.
The user uploads the “Orders File.xlsx”
This file contains an “Address” column. which needs to be analyzed to extract the city and area from each address.
Lunaria Bloom
Lunaria Bloom
AI Address Checker Tool
AI Address Checker Tool
Home
Home
Settings
Settings
Upload Addresses File
Upload Addresses File
AI Do Magic
AI Do Magic
Export File
Export File
First : Upload Addresses Excel File
First : Upload Addresses Excel File
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Upload File
Upload File
Browse Lunaria’s orders Excel file
Browse Lunaria’s orders Excel file
Previous
Previous
Next
Next
Lunaria Bloom
Lunaria Bloom
AI Address Checker Tool
AI Address Checker Tool
Home
Home
Settings
Settings
Upload Addresses File
Upload Addresses File
AI Do Magic
AI Do Magic
Export File
Export File
First : Upload Addresses Excel File
First : Upload Addresses Excel File
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Upload
Upload
25-5-2030 Orders
25-5-2030 Orders
.xlsx
.xlsx
11% completed
11% completed
Previous
Previous
Next
Next
Lunaria Bloom
Lunaria Bloom
AI Address Checker Tool
AI Address Checker Tool
Home
Home
Settings
Settings
Upload Addresses File
Upload Addresses File
AI Do Magic
AI Do Magic
Upload Addresses File
Upload Addresses File
First : Upload Addresses Excel File
First : Upload Addresses Excel File
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Upload
Upload
25-5-2030 Orders
25-5-2030 Orders
.xlsx
.xlsx
File size 0.13 MG
File size 0.13 MG
Previous
Previous
Next
Next
*** The user Adjustment request is handled & the result will be shown in the generated table
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
Hang tight — Table is being generated
Previous
Next
AI analyzes the file's Address column.
the AI extract the city and area from each address entry,
and generate a clean table.
*** For adjustments: Write your request as a prompt
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo
Mirage City
Villa 15, next to JW Marriott
Cairo
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
Hang tight — Table is being generated
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo
Mirage City
Villa 15, next to JW Marriott
Cairo
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
After the city word add Egypt , like : New Cairo , Egypt
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Third : Export File
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Download
Delivery Company File
.xlsx
File size 0.13 MG
Download File
Done
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Settings
AI Model API Link
Please write the AI model API link
Reference File (Cities + Areas)
Upload File
Delivery Template
Upload File
Cancel
Save
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo , Egypt
Mirage City
Villa 15, next to JW Marriott
Cairo , Egypt
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza , Egypt
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo , Egypt
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
The User’s file is finally ready.
This data is formatted based on the delivery Company
template the user provided in the settings page.
*** Settings page requests three inputs :
1- The AI model API link.
2- Reference File.
3- Delivery Company Template.
*** The user Adjustment request is handled & the result will be shown in the generated table
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
Hang tight — Table is being generated
Previous
Next
AI analyzes the file's Address column.
the AI extract the city and area from each address entry,
and generate a clean table.
*** For adjustments: Write your request as a prompt
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo
Mirage City
Villa 15, next to JW Marriott
Cairo
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
Hang tight — Table is being generated
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo
Mirage City
Villa 15, next to JW Marriott
Cairo
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
After the city word add Egypt , like : New Cairo , Egypt
Previous
Next
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Third : Export File
Click “Upload File” The file that needs address (Orders Locations ) adjustment.
Download
Delivery Company File
.xlsx
File size 0.13 MG
Download File
Done
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Settings
AI Model API Link
Please write the AI model API link
Reference File (Cities + Areas)
Upload File
Delivery Template
Upload File
Cancel
Save
Lunaria Bloom
AI Address Checker Tool
Home
Settings
Upload Addresses File
AI Do Magic
Export File
Second : AI do magic
Click “Start Analysis” to let the AI adjust the addresses. If something doesn’t look right, just write a comment or prompt to tell the AI what to fix — it will
apply the changes for you.
Generated File Preview
City
Area
Full Address
New Cairo , Egypt
Mirage City
Villa 15, next to JW Marriott
Cairo , Egypt
Faisal
Bldg 22, 3rd floor, next to El Mesbah mosque
Giza , Egypt
Shekih Zayed
8 Sherif St, close to El Abd Bakery
Cairo , Egypt
Nasr City
Behind Koshary Tahrir, Abbas El Akkad St.
Describe what to fix or adjust...
Enter your notes or desired adjustments — the AI will apply them and regenerate the output.
Previous
Next
The User’s file is finally ready.
This data is formatted based on the delivery Company
template the user provided in the settings page.
*** Settings page requests three inputs :
1- The AI model API link.
2- Reference File.
3- Delivery Company Template.
More Highlight Projects
More Highlight Projects
Learnly - Landing Page
Designed Learnly’s landing page to provide a clean, user-friendly gateway for learners, focusing on engagement and conversion.
Design Refactoring
Pharmacy Mobile App - Refactor
Refactored the app’s UI to deliver a more modern and clean pharmacy experience.
Score Wallet APP
Score Wallet APP
Empowers teachers with a simple tool to store and access student scores.