Note: Clicking on Amazon links may mean I get some kickback from Amazon if you buy something.
I have been riding a Diamondback 1260sc for the duration of the pandemic using the Peloton App as my guide. The things that you miss when you don’t have a Peloton bike are an extra $26 per month in fees, and engagement with the metrics that “put you on the leaderboard.” The only way you get metrics in the app, at all, is if you connect a heart rate monitor (like the Wahoo Tickr), use an iPhone app to bridge your Apple Watch to an iPad (you can also use your iPhone natively), and add a cadence monitor, like the Wahoo Cadence. The Wahoo Cadence syncs fairly seemlessly as these things go.
So you get heart rate and cadence while you’re riding, but that’s it. No watts, no “output” – though if you’re lucky to have a console on your bike, like with mine, you can see some of that information.
I was growing hungry for finding out what my statistics would look like if I were riding on the Peloton. Thankfully, Peloton does give you a way to download the csv file, which you can export into a spreadsheet of your choice, like Excel, Numbers, or Google Sheets. I chose Sheets for mine, and was able to see all the blank spots that I could potentially fill.
My big peeve was that, though Peloton had registered in the app what my cadence from the Wahoo Cadence was, it did not put that information in the spreadsheet – so I had to manually enter it. That left the fields I was most interested in: Average Watts and Total Output. There were three bits I could take from the console on my bike, Date, distance and calories – these are kilocalories, and actually the amount of energy generated during the workout. These can be converted into joules (1 kcal is 4184 joules), with that divided by time (in seconds), you get the average watts for your workout.
For total output, this is measured in kilojoules. I do a kcal to kj conversion, which is 1 kcal to 4.184 kj. This is how I figure out where I may land on the leaderboard, and can retroactively compare myself to my friends. I popped this into my spreadsheet and now I can easily track my progress, even as a lowly app rider.

Shout out to Brygs.com for these helpful blog posts on Watts to KJ Conversion and helping me understanding what the Peloton screen looks like for bike owners. Also, Google and DuckDuckGo have convenient conversion calculators built into search, just search something like 1 kj in kcal, and you will get your answer. Pretty handy.