South africa, the southernmost country on the african continent, renowned for its varied topography, great natural beauty, and cultural diversity, all of which have made the country a favoured destination for travelers since the legal ending of apartheid afrikaans. This article is within the scope of wikiproject south africa, a collaborative effort to improve the coverage of south africa on wikipedia. For postal codes and place name for which no corresponding toponym in the main geonames database could be found an average latlng of neighbouring postal codes is calculated. Stats sa as well as the department of social development, south african reserve bank and social surveys africa. With kutools for excels add text function, you can quickly add a same text string to every cell of a list in the same location. The provinces were formerly subdivided into magisterial districts and administrative districts. I have the postal codes so now i can verify the two against each other to. Use our interactive map, address lookup, or code list to find the correct zip code for your postal mails destination. Each row includes a citys latitude, longitude, province and other variables of interest.
Just put your data, and the editable template will visualize your data automatically. These postal code details have been gathered from the. Postal codes in electronic format mybroadband forum. When postal codes are represented as codes or ids, for example, 92374 or cf, categorize your data as postal code. Postal code of illiondaleekurhuleni edenvale, gauteng 1609 part of list of postal codes in south africa. Excel will automatically convert your data to a geography data type, and. Query stack overflow with tsql give your queries a.
List this article has been rated as listclass on the projects quality scale this article has not yet received a rating on. Note that the postal code may be searched with nearby approximation. Find a south african postal code please type in the city or suburbs name for the postal code that you are looking for please enter a south african city or suburb. These codes are used throughout the it industry by computer systems and software to ease the identification of country names. Mail may be delivered either to the physical address or to a po box, particularly in rural areas where no street delivery is available. Add countryarea code to a list of phone number with kutools for excel. Download excel file list of provinces of south africa. Source from complete list of south africa postal codes aggdata. A map of south africa where you draw a custom area on the map, then perform a search to return all south african postal codes found inside. Apr 09, 2020 our mapping solution makes it easy for all excel users to create interactive maps, sales presentation, or data visualization.
Use our postal code lookup for every country around the world. The paper deals with the status and availability of south african spatial postal codes as points and areas, as well as the implications linking demographic information to. South african postal codes in south africa zip codes south africa postal codes list database directory. Download south african postal codes list for free blogger.
Recently several users of postcodes australia have told us that it would be useful to be able to view all postcodes in a state on the same page. This is a list of all postal codes in south africa, along with additional information such as the state, county, and geographic coordinates. Practice management, icd10 codes docweb icd 10 codes updated. Postal codes street and box are readily available in text format, but no spatial set has been released by the south african postal office sapo. Read more about postal codes in south africa and beyond. The south african post code system was previously used in namibia, then south west africa, including the enclave of walvis bay, which remained part of south africa until 1994. Great for frequent travelers some of us have lived overseas for decades and we have been witness to an amazing evolution in the ability to make international telephone calls. Download list of districts of south africa in excel, csv and pdf free of cost. Theres the official south african post office sapo page that allows you to only search for the one you are looking for. These work group members are specific subject matter specialists and thus provide expert information regarding the subject matter, while survey standards staff members provide expertise regarding. The post code refers to the location to which post or parcels are sent to through the post office or courier company. Select the name of the placeaddresscity in south africa from the suggested list. Western cape zippostal code, western cape south africa, all city and suburbs codeszippostal codes of states, counties, towns, districts, places and streets of south africa za.
South african cities and provinces a complete list. Weve built it from the ground up using authoritative sources such as the ngia, us geological survey, us census bureau, and nasa. South africa place name, town name, dialing code, postal code, region in excel. Download excel file list of districts of south africa. The list of icd 10 codes has been updated and is available for download. Doing so allows arcgis maps for power bi to recognize the data as codes so that it can accurately map the locations. If you want us to add excel format of any data or information then please let us know. Postal code of,municipalityname,suburb,districtname,city,province. Postal code of municipalityname suburb districtname city province postal code of city of tshwane pretoria, gauteng 0001. I spent the most part of my saturday searching for a comprehensive list which i didnt find.
Lists of postcodes and suburbs in south australia sa. Western cape data and list of cities south africa postal. H please type in the city or suburbs name for the postal code that you are looking for alphabetic lookup results 622 found. Following independence, use of the south african postcode system was discontinued. We can scrape data using latest technologies and convert it into useful formats. These postal code details have been gathered from the postal code booklet published by the sa post office. United nations code for trade and transport locations. Map charts have gotten even easier with geography data types. South africa place name, town name, dialing code, postal. How to add countryarea code to a phone number list in excel. Nov 08, 2011 ive seen various requests for the postal codes of south africa or zip codes to be made available in a downloadable format but couldnt find any available for free. The numbers are not aligned with province boundaries. Home page travel list of postal codes in south africa.
Recently several users of postcodes australia have told us that it would be useful to be. We have attempted to list all south african postal codes on this site. If you do not like to use formula to solve this job, i can introduce a handy tool kutools for excel for you. South african postal codes south african postal codes spain spain postcodessri lanka sri lanka postcodessri lanka sri lanka postcodessri lanka sri lanka postcodesswaziland swaziland postcodes post office, official post codes english sweden sweden postcodes. Accpac pocket pc applications african bombay custom mobile development brew game development. Some of these districts straddled the border between two provinces.
List of country codes by alpha2, alpha3 code iso 3166. Complete list of zip codes and all administrative divisions for countries. Download list of provinces of south africa in excel, csv and pdf free of cost. Browse postal codes by south africa province and capital. Find the postal code for all cities, regions and subregions in south africa, and download as csv if you want.
Blaauwberg online accepts no responsibility for errors that. This is a subset of all 11,777 places in south africa and only some of the fields that youll find in our world cities database. In addition, many large organisations may use private bag address, with mail dispatched to the holder by a mail contractor. This is an online tool mashup to search postal code of a place, address or city in south africa. South african postal codes in south africa zip codes south. Were releasing this data subset for free under an mit license. In this section below you can download versatile free excel maps.
Download south african postal codes list for free ive seen various requests for the postal codes of south africa or zip codes to be made available in a downloadable format but couldnt find any available for free. List of cities and towns in south africa britannica. South africa postal code lookup by addresscity, map zip. Prepare your dataarcgis maps for power bi documentation. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks. The entire sic code list free from ehso sic code list the u. Africas largest volunteer driven open data platform. Below is a list of 73 prominent cities in south africa. Our extensive suite of services now includes future store closings and realtime api feed. South african area codes consists of 4 digits and refers to the city or.
South african postal codes in south africa zip codes. List of postal codes in south africa home page travel list of postal codes in south africa find the postal code for all cities, regions and subregions in south africa, and download as csv if you want. Please let us know if you find any errors in the data set. These codes are used throughout the it industry by computer systems and software to.
Please feel free to contact us if your post code is not listed, or if you spot any errors. In our previous article, we showed how to use conditional formatting if you want to create simple state maps in excel data visualization is a rather popular subject, and excel provides endless possibilities for collecting, organizing, and displaying continuously growing data. The location could be a suburb, a city, a government department, an institution or a post box area area. Itll take around a week for data processing and well revert to you with free data format. Currencies and additional currency information sorted by country. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the data tab data types geography.
Standard industrial classification sic system was the older way of classifying businesses to provide new comparability in statistics about business activity across north america. Download our postcode database south africa and enhance your website software with a postcode radius search capability. Complete list of south africa postal codes aggdata. Windmill park uit 9, kwaguqa uit 3, orlandowes uit 1, marulaneng, suideinde.