What to write in a travel journal of places, with a template to copy
A page that says 'great trip, loved the old town' tells you almost nothing five years later. Which town? Which month? Was it the first visit or the third? A travel journal of places answers those questions with a few fixed fields instead of long prose, so the answer is always in the same spot.
The method here uses one row per place, not one entry per trip. A trip through three countries becomes three or more rows, each with the same fields. That structure makes the journal easy to sort, easy to turn into a map, and easy to check against the rules you set when counting countries visited.
Eight fields that turn notes into a record
Each field below answers one question you will want to ask later. Keep the labels identical from row to row. Then the journal can live in a spreadsheet, in a notebook with ruled columns, or in a plain text file, and you can still sort and filter it.
| Field | What to write | Why it helps |
|---|---|---|
| Date | First day in the place as YYYY-MM-DD, plus the last day if you stayed | Rows sort in time order |
| Place | The name used on the spot, then your own-language name if it differs | Avoids mix-ups between similar names |
| Country and region | A two-letter country code and the region or state name | Lets you group rows on a map |
| Coordinates | Decimal degrees with two to four decimals | Lets you plot the exact spot later |
| Visit type | Passed through, stopped, or stayed overnight | Feeds your counting rules |
| What marked you | One to three sentences about what you saw or learned | Keeps the record personal |
| Evidence | The photo folder name, a postcard, a saved note | Backs up the entry |
| Source | The atlas page, book or map you used to check the facts | Helps you correct errors later |
The visit type field matters most for counting. Write down what physically happened: you changed planes, you crossed a bridge on foot, you slept in a village. Decide later which of those events count toward your totals. If you log only the count and not the event, you cannot apply a new rule to old trips, and any change of mind means starting over.
Write dates, places and coordinates so they sort
Write dates as year, month, day, separated by dashes: 2025-03-09. This is the profile of ISO 8601 described in a W3C note, and it has a practical benefit. Sorted alphabetically, the rows also sort in time order. A format such as 03/09/2025 is ambiguous, because some readers see 9 March and others see 3 September. The same note allows a year alone or a year and month, which is handy for old trips you can only place roughly.
For places, write the name as people use it locally, then your familiar form if the two differ. Add the ISO 3166-1 alpha-2 country code, the two-letter code such as JP or BR. ISO 3166-2 extends the idea to regions by joining the country code with a short suffix; the ISO's own example is ID-RI for the Riau province of Indonesia. These codes never change with the language of your notes, which makes them reliable sorting keys.
For coordinates, decimal degrees are easier to store than degrees, minutes and seconds. Use a minus sign for south and west. The U.S. Geological Survey gives about 69 miles (111 km) for one degree of latitude, so two decimals fix a place to roughly 1 km and four decimals to roughly 11 m. A degree of longitude shrinks toward the poles: at 38° N it spans about 54.6 miles (88 km). The guide to latitude and longitude explains both formats in detail.
Keep the journal useful after the trip
Fill in the factual fields the same day, while the details are fresh, and add the memory sentence within a few days. Facts such as the exact date and the visit type are easy to lose and hard to rebuild. Coordinates can wait until you are home, because you can read them from a map or from the location data of your photos. The guide to organizing travel photos by place shows how to match photo folders to journal rows.
- Date written as YYYY-MM-DD
- Place name and two-letter country code
- Coordinates copied from one consistent source, with the source noted
- Visit type chosen from three fixed words
- One sentence about what marked you
- Evidence folder named the same way as the row
- A second copy saved in a different place
That last item follows the Library of Congress advice for personal digital photographs: keep at least two copies, store them in different places, and check once a year that you can still open them. A journal is small, so copying it takes seconds.
When the rows are complete, they hold everything a map needs: a country or region to color and coordinates for a pin. The travel map editor marks countries and, for some large countries, states and provinces. Any other tool can read the same columns, so the journal stays useful if you change tools.
Common mistakes with travel journals
- Writing one long entry per trip
A single narrative for a three-country trip cannot be sorted or counted. Split it into rows, one per place, and keep the story in the memory field.
- Mixing date formats
Entries such as 4/5/25 and 5 April 2025 in the same journal break sorting and cause confusion about day and month. Pick YYYY-MM-DD and use it everywhere.
- Pulling coordinates from several sources
One tool may point to a city center and another to an airport, a few kilometers apart. Choose one convention, such as the city center, and write it in the Source field.
- Recording only the result of a counting rule
If the journal says 'country visited: yes' and nothing else, you cannot change the rule later. Record the event instead: passed through, stopped, or stayed overnight.
- Keeping the only copy in one place
A single notebook or a single phone can be lost. A second copy in another location takes almost no effort and protects years of notes.
Frequently asked questions
Should a travel journal of places be on paper or on a screen?
Either works if the eight fields stay the same. Paper is quick to sketch in and needs no power. A spreadsheet or text file is easier to sort and search. Some people keep both: paper in the field, a digital copy at home. The guide to paper versus digital travel maps compares the two formats.
How precise should coordinates be?
Two decimals place you within roughly 1 km, which is enough to find a town or a district. Four decimals place you within roughly 11 m, which suits a single building or viewpoint. More decimals add digits without adding useful accuracy for a journal.
Do I log every place I only passed through?
Log what you want to be able to count later. A short row with the visit type 'passed through' takes a few seconds and keeps the record complete. You can then decide, or change your mind, about whether those rows count.
Which country code system should I use?
ISO 3166-1 alpha-2 is the most common choice: two letters such as DE or BR. The three-letter alpha-3 codes work equally well. Pick one system and keep it. The UN statistics division also publishes numeric codes, which some spreadsheets prefer.
Can I add trips I took years ago?
Yes. Fill in what you remember and write the date at the level you are sure of, such as a year alone or a year and month. Mark the Source field with 'memory' so you know the entry is less exact than the ones you log on the day.
Sources
- Date and Time Formats (NOTE-datetime) W3C
- ISO 3166: international standard for country codes and subdivisions ISO Help Centre
- How much distance does a degree, minute, and second cover on your maps? U.S. Geological Survey
- Digital Photos - Personal Archiving Library of Congress