Most verified spreadsheets require you to "File > Make a Copy" to your own Google Drive so you can edit the numbers.
You don’t need a spreadsheet to enjoy Idle Planet Miner. But if you’re tired of guessing which planet to upgrade next or whether to smelt or sell, this verified tool will save you hours.
Big thanks to the Discord users @DrMiner, @PlanetCrafter, and @MathIsFun for sanity-checking the formulas.
Now go optimize that galaxy. 🪨🚀
Found an error in the sheet? Let me know in the comments or ping me on Discord. Verification is an ongoing process.
, a community-driven Google Sheet widely considered the gold standard for maximizing efficiency The Idle Planet Miner Mastersheet The most widely used version is Kaphor's Mastersheet v1.7
, which is maintained and updated by veteran players on Reddit and the official Discord. It serves as a comprehensive "ROI" (Return on Investment) calculator to help you determine exactly where to spend your money. Primary Purpose
: Tells you the most cost-effective way to distribute levels across your available planets to maximize mining rates and profit. Key Features Planet ROI Table idle planet miner spreadsheet verified
: Ranks every planet and upgrade (mining, speed, cargo) by how quickly it will pay for itself. Crafting & Smelting Calculator
: Inputs your current boosts (Forge, Workshop, Managers) to show the fastest path to high-value items. Recipe Toggles
: Allows you to check off recipes you've unlocked so the sheet ignores items you can't build yet. "Step" Input
: You enter a "step number" (representing your total mining levels), and the sheet outputs the ideal level for every planet. How to Use It Do Not Edit Lock-Cells : Only edit cells highlighted in neon green Input Your Stats
: Enter your Mothership room levels, Manager bonuses, and Star bonuses. Follow the Steps
: Rather than manually entering planet levels, you increase the "Step" number in the sheet. It will then highlight which planet needs an upgrade next to stay perfectly balanced. Where to Find the Verified Links
While various versions exist, the most current and "verified" versions are always hosted on the Idle Planet Miner Discord or updated in the Mastersheet thread on Reddit Mastersheet v1.7 : The classic foundation for early-to-mid game players. Smelting/Crafting Profit Calculator Most verified spreadsheets require you to "File >
: A specialized update focused on optimizing alloy and item production. Limitations Late-Game Utility
: Many veteran players find that they "outgrow" the basic Mastersheet once they reach high-tier items like (Subspace Relay) or
(Advanced Robot), as the math becomes more about long-term project planning than raw mining ROI. Static vs. Dynamic : It does not account for temporary Market Bonuses
in real-time, which can significantly shift which item is most profitable to craft. for early-game players?
Smelting/Crafting Update - Profit Calculator (has been renamed)
Optimizing your progress in Idle Planet Miner (IPM) often requires more than just in-game stats. While the game provides basic data, community-verified spreadsheets are essential for calculating Return on Investment (ROI), managing complex crafting recipes, and determining the most profitable planets based on your specific multipliers. Popular Verified Community Spreadsheets Spreadsheet Name
The most powerful use of a spreadsheet is deciding when to Prestige. Found an error in the sheet
Not all ore is created equal, and market fluctuations change the hierarchy daily.
I’ve hosted the latest verified read-only version here:
👉 [Download / Make a Copy of the Verified Idle Planet Miner Spreadsheet]
(Link placeholder – replace with your actual Google Sheets link)
How to use: Click the link → File → Make a copy → Save to your own Drive. Then edit the green input cells only.
A truly useful verified spreadsheet for IPM will contain the following five tabs. If your spreadsheet lacks these, it is obsolete.
Since you searched for "idle planet miner spreadsheet verified," you will likely click on the first Google result. Do not. Run this checklist first: