Timetable Formatter (Sort and Filter CSV/TSV Times)
Paste timetable CSV or TSV data to read the time column, sort departures, keep a time window and export the result as CSV. Handles after-midnight times such as 24:10 and lists unreadable rows by line number.
- Runs in your browser (no upload)
Tab-separated data copied from Excel or a spreadsheet works too. Times are read as 7:40, 07:40, 24:10 or 7:40:30.
Use it to list trips just after midnight at the end of the previous day. Times written as 24:10 always count as the next day.
For example 07:00 to 09:00. Leave blank for no limit. Both ends are included.
Result
Tidied timetable
| Line | Service | Departs | Destination | Platform |
|---|---|---|---|---|
| 3 | Local 1 | 6:15 | Central | 1 |
| 2 | Rapid 3 | 7:40 | Airport | 2 |
| 4 | Local 5 | 8:05 | Central | 1 |
| 7 | Rapid 4 | 12:20 | Airport | 2 |
| 6 | Local 7 | 23:30 | Central | 1 |
| 5 | Last 9 | 24:10 | Depot | 1 |
How to use
- Paste your timetable data (CSV, or tab-separated data copied from a spreadsheet).
- If needed, choose the delimiter, whether there is a header row, the time column and the day boundary (the time column is detected automatically).
- Choose the sort order and a time window, check the result and download or copy it as CSV.
FAQ
Can it read times like 24:10 or 25:05?
Yes. Timetables use them for trips after midnight, so times up to 47:59 are treated as the next day and sorted after 23:30. You can also show them on a 0–23 hour clock, such as 00:10.
Trips at 0:20 end up at the top. What can I do?
Set the "Day boundary" to 3:00, for example. Earlier times then count as the next day and are listed at the end. The time window uses the same rule.
Is the exported CSV safe to open in Excel?
Cells starting with =, +, -, @ and similar get a leading ' so they are never run as formulas, and the file is saved as UTF-8 with a BOM so characters display correctly.
Notes & limitations
- What you enter is processed only on this page and is not sent to YUCTS servers.
- This tool does not fetch timetables. Check exact times with the operator's official information.
- Times are only read as hours:minutes or hours:minutes:seconds (formats such as "7h40" are not read).
- Up to 1,000,000 characters can be pasted. The page shows the first 200 rows; the CSV contains every row.
Related tools
- Luggage Size Calculator (Linear Size and Volume)Enter the length, width and height of your bag to get the sum of the three sides (linear size) and the volume in liters, shown in both centimeters and inches, and check it against a size limit you enter.
- Transfer Time Calculator (will I make my connection?)Enter your arrival time, the next departure and the time you need to change (walking and so on) to see the minutes available, the spare time and whether you will make it, even across midnight and for several transfers.
- Transit Pass vs Single Tickets CalculatorEnter the single fare, the number of rides and the price of day passes or travel passes to see each option's cost, the cheapest choice and how many rides it takes for a pass to pay off. Fares are typed in by you.
- Fuel Cost Calculator (Trip Cost and Split)Work out the fuel needed, the fuel cost of a trip and the share per person from the distance, fuel economy (L/100km, km/L or mpg), the fuel price and the number of people. Supports round trips and tolls.
- EV Charging Cost CalculatorEstimate the cost of charging an electric car from the battery capacity and charge levels (or kWh to add), charging efficiency and electricity price. Supports per-kWh or per-minute billing, fixed and parking fees.
- Speed, Distance and Time CalculatorEnter any two of speed, distance and time to get the third. Works with km/h, m/s, mph and knots, km, m and miles, and hours/minutes/seconds, and shows unit conversions and pace.