A map of all German TestDaF test centres.
Clicking through the list of test centres can be tedious if you are simply trying to find the centre closest to you. Therefore, I have taken the information from the TestDaF website and plotted them on a map.
Visit the interactive version here (unfortunately, not all places could be mapped, and some are mapped incorrectly).
A complete list (as of 11.02.2019) of all test centres can be found in testcentres.txt
. The output from scraping can be found in testcentres.xlsx
.
To update the map to reflect any changes on the TestDaF website, follow the steps outlined below.
- use any scraping tool to get the list of test centres from the TestDaF website
- for example the webscraper.io Chrome extension.
- or manually copy all the place names ;)
- Use the following entry points for the scraper
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-d-bis-f/
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-g-bis-i/
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-j-bis-l/
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-m-bis-o/
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-p-bis-s/
https://www.testdaf.de/fuer-teilnehmende/die-pruefung/testzentren/testzentren-in-deutschland-von-a-bis-c/testzentren-deutschland-von-t-bis-z/
- And the following CSS selector
div.deut_einzel > ul > li:nth-of-type(1), li:nth-of-type(2) li a.testtz
- make sure to enable multiple selections
- begin scraping and download the CSV file
- Take the CSV file and extract the column with place names
- Remove any empty entries
- Remove line breaks and tabs within entries
- remove any numbers that my accidently be within an entry
-
A VBA script for Excel that removes numbers
Function RemoveNumbers(Txt As String) As String With CreateObject("VBScript.RegExp") .Global = True .Pattern = "[0-9]" RemoveNumbers = .Replace(Txt, "") End With End Function
-
- export list of cleaned place names
- Map the list of places in any mapping software
- Mapcustomizer is convenient because it has a bulk input option.
- Enjoy an easily accessible map of TestDaF centres.