How do I convert a Train Timetable into an Excel Document?
Hello r/excel
I'm a bit stuck with this one.
I have a collection of timetable PDFs that I would like put onto a spreadsheet, so that I can do some research on the given data.
The problem is: Different Symbols on the timetable are making the problem more complex than it needs to be.
I've asked Gemini/Grok to develop programs which I can use python for (Novice), but no matter what, it cannot determine that the Blue Arrows are. The Blue Arrows usually just determine when a train is a slower service that gets bypassed by a faster service, but can also determine when a train splits/joins together. There's also another problem with those I have to solve but that's another thing.
Then there's all the other symbols which create noise on my spreadsheet, such as the black boxed numbers next to the stations which denote interchange times.
What I would like, is a way to extract these timetables into a clean, readable excel sheet that a program can parse through and extract data for me.
How do I do this?
[link] [comments]
Want to read more?
Check out the full article on the original site