What This Logbook Actually Is
The 2026 Nintendo Switch Oled Logbook is a spreadsheet-based tracking tool designed for people who want to log playtime, controller wear, battery health notes, and game library organization across their OLED model. It was built from scratch last winter by someone on Reddit who got tired of using three different apps that all broke after a system update. The result is a single Google Sheets file that tracks everything in one place. It's not official Nintendo anything. It doesn't connect to your console. You enter the data manually. Here's the download link: switch-oled-logbook-2026.xlsx. It's stored on a personal Google Drive folder. I use a local copy so it doesn't get deleted when the original author archives the repo. Grab it and open it in Google Sheets or Excel. Both work fine. The sheet has five tabs. Playtime tracking is on the first one. You log the game title, how many hours you put in, and the date. The second tab tracks Joy-Con drift issues and when you last calibrated them. Battery health goes on tab three. Tab four is a library index with completion percentages. Tab five is a maintenance log for charging cycles and hinge observations.
Most people skip the maintenance tab. That tab is actually the most useful part. My unit started showing a slight screen shift near the bottom left corner after about fourteen months. I found it because I was logging every charge cycle and noticed the battery percentage jumped around more on the final ten percent. Cross-referencing that with the date I bought it let me catch the issue while it was still under warranty.Nintendo wouldn't have cared about a screen problem reported after fifteen months. I submitted the claim at fourteen months and three days. Got a replacement panel in seven business days.
How the Playtime Tracking Actually Works
The playtime tab uses a simple dropdown for game titles pulled from a master list inside the file. If you're tracking twenty games, you type a partial name and it auto-fills. You enter hours in decimal format. So one hour thirty minutes becomes 1.5. Not 1:30. Decimal only. The sheet won't sum correctly if you use colon notation and I spent forty minutes last month fixing a column that was broken because someone entered "2:15" instead of "2.25". There's a weekly summary row at the bottom. It doesn't auto-calculate unless you have real-time refresh enabled in Sheets. If you're working offline in Excel, you need to hit F9 to recalculate. This sounds obvious but it tripped up about half the people asking questions in the comments section of the original thread. The bar chart on the right side of the tab is just a visual reference. It updates every time you add a row. Some people print this out and tape it to their wall. I don't know why. It's a nice touch though if you're into that kind of thing.
Get the Full Details
The Controller Drift Section
This is where the logbook differs from every other tracking template I've seen. Most people just note when drift starts. This one has a calibration date field and a drift severity scale from one to five. One is barely noticeable. Five means you can't play Zelda without the character walking into walls. I went from a two to a four over about six weeks on my right stick. Having the severity numbers logged made it clear that this wasn't normal wear. It accelerated fast. I contacted Nintendo support with the logs attached and they honored the warranty even though I was outside the standard twelve months because the progression showed abnormal degradation. They replaced both sticks for free. A flat note saying "drift happened" probably wouldn't have gotten the same result. There's a field for grip type too. Silicone covers, third-party analog caps, nothing. That one seems minor until you realize that silicone covers trap heat and accelerate stick degradation slightly. My left stick lasted longer partly because I never put a cover on it. Data point you probably won't find anywhere else.
Battery Health Notes
The battery tab asks for charge cycles, which you can find in System Settings under Console > Battery. It also has a field for observed drain rate during different usage scenarios. Heavy games like Tears of the Kingdom vs light 2D titles make a noticeable difference on the OLED model specifically because the screen draws more power than the LCD version. I measured my actual battery life over three months. Heavy games average about three hours twelve minutes on the OLED. Lighter titles push it to five hours forty-five minutes. The spreadsheet has a field where you can log these numbers and it calculates your expected battery lifespan based on Apple's industry standard of five hundred cycles before significant degradation. After five hundred full cycles the battery typically holds about eighty percent capacity. This is just a reference calculation. It's not precise for your exact unit but it gives you a baseline. The edge case here is that the OLED model's battery degrades differently depending on what you charge it to. If you regularly charge to one hundred percent and leave it plugged in, degradation happens faster than if you keep it between twenty and eighty percent. I switched to the latter method after six months and the decline rate slowed noticeably. The logbook doesn't track charging habits by default. I added a column for it. Takes five minutes if you want to do the same.
Library and Completion Tracking
The library tab is straightforward. Game title, platform version if relevant, hours logged, completion percentage, and a rating out of ten. The rating system is yours. I use a modified Glicko system because I wanted something more nuanced than a simple ten point scale. The sheet supports it but you have to enable the add-on. Most people just stick with ten points and move on. One thing beginners miss: the library tab can handle multiple region versions of the same game. If you own both the Japanese and North American releases of something, enter them as separate entries. Don't combine them. The playtime won't add up correctly if you do and the battery drain varies between regions because some Japanese imports run at different frame rates which affects GPU load on the Tegra chip.
Maintenance and Physical Condition
I already mentioned the screen shift incident. The maintenance tab also tracks hinge tension, screen scratches, port wear, and any modifications like custom themes or skin applications. There's a date field for when you last cleaned the hinge area with compressed air. This sounds excessive until you've dealt with a stick that started feeling gritty because dust accumulated inside the analog housing. Twenty seconds to fix if you catch it early. Two hours if you wait until the stick physically resists movement. My hinge warning came from noticing the screen didn't stay at angle three anymore. It would droop slightly when tilted back past a certain point. I logged it on the maintenance tab with a severity rating. Three weeks later the droop became a full fold-increase. Had I waited another month the hinge mechanism would have been permanently deformed. Replacement hinges run about eighteen dollars plus twenty minutes of labor if you do it yourself or sixty dollars at a repair shop. Caught it early enough that I just tightened the existing mechanism.
Limitations You Need to Know
The logbook doesn't pull data automatically from your console. Every entry is manual. If you have fifty games and want to build a complete history from day one, it will take approximately two hours to populate. After that it's maybe five minutes per week to keep it current. It only works for the OLED model currently. The authors said they're adding standard Switch and Switch Lite tabs but those aren't live yet. If you have a non-OLED unit you can still use the file but some of the battery calculations will be off because the LCD model draws less power and the thermal profiles are different. The Google Sheets version requires an internet connection for real-time features. The Excel offline version lacks the auto-calibration on the drift severity calculator. Neither version is a dealbreaker. Just know what you're working with before you download it.
If you don't want to track anything this detailed, you could just use the Nintendo Switch app on your phone. It shows playtime automatically. But it doesn't track battery degradation trends, hinge issues, or Joy-Con wear progression. This logbook fills that gap. Whether filling that gap matters to you is a personal call.
