Choose what deserves to move forward
Start with the purpose of the new working edition. Select active candidates that still support that purpose rather than copying every historical row automatically. An item may remain interesting while no longer needing an active comparison. Move such references to an archive or a separate later list. The new edition should make your current work easier to see, not hide it beneath years of accumulated browsing.
For each carried candidate, retain the original URL, source name, and intended option. Add a short reason for keeping it active. That reason helps you decide which details need attention next. If you no longer remember why a row mattered, revisit its notes before assigning it a fresh status. A rollover is a good time to reduce ambiguity, but it should not erase the history that explains the candidate. Keep the earlier edition intact so you can compare changes without reconstructing the original from memory.
Preserve the age of existing observations
Copy observation dates with the observations they describe. Do not replace all dates with the day you create the next file. An exported measurement remains the same old observation until you obtain new evidence. The new edition date belongs to the document, while the measurement check date belongs to that particular field. Keeping both meanings visible is the central discipline of a useful rollover.
If your old sheet has only one ambiguous date column, add a note explaining what it was originally intended to record. Where you cannot establish that meaning, leave it uncertain and plan a fresh check for any fact that matters. Avoid making a precise history from guesses. You can improve the structure going forward without pretending the earlier records were more detailed than they were. This lets the new edition be clearer while preserving an honest account of which information was carried from the old one and which was newly observed.
Review destinations before transferring conclusions
Open the reference when a candidate returns to active use. Compare the visible listing and option with the saved row. If the destination has changed, preserve the old address and describe the new result. Do not transfer an old measurement, image note, or recommendation to a different listing merely because the product looks similar. The connection between evidence and subject matters more than a neat annual table.
If a replacement reference is relevant, give it its own row or a clear relationship note. Identify what you actually compared before deciding whether any old observation remains useful. A shared title or category is not enough to establish that all details are interchangeable. This is particularly important when a candidate has several options. The correct listing with a different intended size can still require a new comparison. A careful rollover carries useful context forward while keeping the boundaries of earlier observations visible, instead of treating an old conclusion as a property of every similar item you encounter later.
Keep a concise change log between editions
A change log should explain meaningful differences: a new candidate, a corrected identifier, a revised option, or a resolved measurement question. Keep cosmetic edits separate from these changes. If you reorganized columns without rechecking destinations, say so. A document that looks different may contain exactly the same underlying observations. Readers should not have to infer the extent of the update from its visual design.
Use a simple format with date, reference, change, and reason. One or two sentences may be enough for a significant row update. Keep links to the relevant source or evidence where appropriate. The log is useful when you revisit an earlier decision or ask another person to help maintain the sheet. They can see which information moved forward unchanged and which was deliberately revised. Avoid a log so detailed that nobody can maintain it. Focus on changes that alter how a candidate should be interpreted or what action remains to be taken.
Publish or share only the intended working view
Before sharing the new edition, review its scope and privacy. A personal working file may include private preferences or transaction-related notes that do not belong in a public reference collection. Export only the fields needed for the audience. Keep full public product URLs and clear option labels, and remove unrelated private information. Preserve a separate private copy if the omitted notes remain useful to you.
Add a brief introduction explaining the edition label, the purpose of the list, and what the dates represent. Do not claim that a rollover means every detail was refreshed. Test a few links in the exported view and read one row without the original formatting. The recipient should understand the reference and the next question from the data itself. A careful handover gives the next edition continuity without false freshness: the old observations retain their history, the new checks have clear dates, and active candidates remain connected with the decisions the sheet is meant to support.
A practical exercise
Create a rollover copy containing only two active candidates. Preserve their original reference fields and observation dates. Add a new edition label and a brief reason for keeping each row active. Revisit one relevant detail and date only that new check. Compare the old and new files to confirm that unchanged observations did not acquire a fresh date. This exercise produces continuity without false freshness and gives you a small, understandable model to follow before carrying a larger shortlist into another edition.