Using the Swiss rail pass calculation spreadsheet
A traveler named Pbcemail is confused about using a spreadsheet to determine the best pricing for a week in Switzerland. They are struggling to get price data, especially using the SBB app on both a Chromebook and Windows 10. Help is needed to navigate the app for pricing and selecting transportation modes.
- Open the spreadsheet in Excel or Google Sheets to edit and view pricing data properly.
- Use the SBB website or app by entering your trip details to find pricing easily and select transport modes.
- To display full or half fares in the app, go to Settings in the menu and edit Passenger Information appropriately.
- Look for Supersaver fares on the timetable for possible discounts on specific train departures.
AI-generated summary. Details may be outdated. Check with our travel experts to be 100% sure.-
I am completely confused. I downloaded the spreadsheet, but it is read only. I finally scrolled down below the examples and was able to enter some segments, but I can’t figure out how to get the price data. I have tried various links from here and tried using both a Chromebook with the SBB app, and Windows 10 with google chrome browser. I also put the SBB app on my phone, but it is too difficult to use on the phone. Also, how do you select a single mode of transportation? I am trying to determine the best pricing for my week in Switzerland by myself as suggested by you on many issues.
🇨🇭 The official SBB tourist webshop✓ Discounts for passholders ✓ Instant mobile e-Ticket ✓ Free cancellation option
Unlimited travel
Swiss Travel Pass
Unlimited train, bus, & boat travel across Switzerland.
With discounts
Mountain excursions
Official e-Tickets with pass holder discounts. Skip the ticket counter.
Unlimited travel
Regional passes
Unlimited travel in the Berner Oberland, Jungfrau Region or Lucerne Region.
-
Hi Pbcemail
You have to open the spreadsheet in a program like Excel. If you don’t have Excel you can use google sheets, it’s free.
it took me a while to figure it out as well. Just replace what’s listed with what you’d like to do.
I’m sure others can provide more detailed advice and links to help you, but I am using Chrome on my laptop and the SBB timetable page provides pricing information for any trip you choose. Plug in the beginning & end points, date, time, etc. and click “Search.” From the list of responses, I just click a red box to the right of any specific trip option, and it shows the price, lets you pick one way or roundtrip, 1st or 2nd class, etc. The price shown is 1/2 the full fare price (they indicate it is the Swiss Half Fare price).
To select a single transport mode, click on the Advance Search option next to the origin/destination location pair and scroll down to the Transport Type box where you can select or deselect any of the transport methods.
Hello Pbcemail and Welcome to MySwissAlps,
If you find the SBB mobile app too difficult to use you are doing something wrong. It is by far the most simple way to find prices.
To select a single mode of transport click on the icon in the first attachment. The select the mode of transport you want from the list shown in the second attachment.
The SBB website shows half-fare prices by default, the mobile app allows you to nominate whether to show full or half-fares (by editing the passenger details in settings) and is also smart enough to offer you the Saver Day Pass (http://www.myswissalps.com/saverdaypass) if that offers the best fare. The app can also display a platform map (at least at the larger stations) to help you make connections. You can also easily filter modes of transport (eg bus or ship).
The app (or website) will always show the fastest, most direct routes unless you tell it you want to go a longer way round by including other stations to go VIA. For example, if you wanted to follow the Golden Pass route you would need to search the SBB app looking for Luzern to Montreux via Interlaken and Zweisimmen.
Hi Pbcemail,
if you are not familiar with the SBB timetable then first study the descriptions at http://www.myswissalps.com/timetable. It also explains how to find ticket prices.
For the calculation spreadsheet (http://www.myswissalps.com/train/ticketspasses/practical/chooserailpass) you should be able to write everywhere not just in a few places. (The little red triangles in the corners give you extra hints and tips.) You should open the spreadsheet in Google Spreadsheet (within the Google Drive) or in Excel. Do you know how to use any of them?
Please let us know how are you doing. If you are not familiar with these systems it can be difficult for first sight. If you have any print screen where you stuck it would also help us to understand the problem.
I’ve found these video guide on Youtube, they might help you: http://www.youtube.com/watch?v=jSwP4UwpD-w&list=PL2y5uecQPrF0co4GZXKRa2S1BIzIu6SVa
Ildiko
🇨🇭 The official SBB tourist webshop✓ Discounts for passholders ✓ Instant mobile e-Ticket ✓ Free cancellation option Unlimited travel
Swiss Travel Pass
Unlimited train, bus, & boat travel across Switzerland.
With discounts
Mountain excursions
Official e-Tickets with pass holder discounts. Skip the ticket counter.
Unlimited travel
Regional passes
Unlimited travel in the Berner Oberland, Jungfrau Region or Lucerne Region.
I’m a little confused with part of the SBB app. You say it can be set to show full fare prices instead of the default half fares. To put it in the words of Ricky Ricardo “‘Splain”.
I opened the advanced search and checked ‘show prices in timetable’ and all that seems to do is, well, show prices in the timetable. What does the ‘%from CHF5.80’ mean? One would think there would be check boxes for ‘show full fare’ and ‘show half fare’. Clarification needed.
Thanks.
To set full or half fare click the menu button (top left). Then go Settings -> Travellers -> Edit Passenger Information and tick or leave blank the appropriate box. See attached. You can also edit passenger information when you go to “Select a Ticket” for a particular journey. See second attachment. (1/1) next to your name means full fare, (1/2) means what it says. 😉
% in front if a price means there is a Supersaver fare available. Supersaver fares are tied to a particular train departure. Regular fares are valid for a whole day for a single trip on a given route.
- The thread ‘Using the Swiss rail pass calculation spreadsheet’ is closed to new replies.
