Daily Diary → Journey CSV

This page understands the standard Daily Diary table (Annexure-1) whose columns are numbered 1 to 13. If your file is different, you can ask an AI assistant (Claude, ChatGPT, Gemini) to make the CSV: attach your diary and paste this instruction.

Copy the instruction

Convert the attached Daily Diary (Annexure-1) into a CSV file. This is an extraction task: every value must come from the file. Do not estimate or invent anything; if something is unclear, ask me.

Output exactly these 13 columns, in this order:
DepDate,DepHH,DepMM,FromPlace,ArrDate,ArrHH,ArrMM,ToPlace,Distance,Mode,Class,Fare,Duration

Rules:
- One CSV row per journey row (leg). A row that only has a date is a date header: it sets the date for the legs below it and is not a journey.
- DepDate / ArrDate: DD/MM/YYYY. If a journey ends on the next day, use the arrival date written in the diary.
- DepHH, DepMM, ArrHH, ArrMM: two digits (08, 05).
- FromPlace / ToPlace: place name in English with the station code in brackets, e.g. Chhindwara (CS). Use CS for camp station/office, BS for bus stand, POD for sample point/place of duty, RS for railway station. Keep "Hotel" as part of the name. If there is no code in the diary, add none.
- Distance: the km written in the diary.
- Mode: in English (Auto, Bus, Rail, Foot, Taxi ...). Use Rail for train.
- Class: write General for every row.
- Fare: the rupees written in the diary (ignore paise).
- Duration: write NA in every row.
- Include only journeys for which a fare was paid. Leave out every journey with no fare, and every day on which no fare was paid.
- No Hindi text may remain in the CSV.

Before giving me the file, check: the number of rows, that no day with a fare is missing, that the Duration column is NA in every row, and tell me about anything doubtful in the diary instead of guessing.