Scientists persistently share diverse digital assets, including analytical data and scientific methods, many of which comply with increasing mandates for open science. As scientists share investigations, the potential to transform methods and data into discoveries expands. But the potential impact of shared digital assets is restricted by limited, ambiguous, and inaccessible information about how physical materials were generated and processed, known as provenance. Scientists often share critical details of provenance in spreadsheets and many digital platforms solicit essential information via spreadsheets. Yet, scientists and scientific software engineers struggle to share accurate and sufficient provenance in spreadsheets. In this work, I first highlight concepts and challenges in sharing the provenance of biological material, regardless of the application used. Then, I identify motifs for sharing provenance in spreadsheets by evaluating diverse resources, ranging digital ecosystems to bespoke metadata management systems. I highlight efforts, ranging from frameworks to spreadsheet-based features, that target known challenges for sharing complex information like provenance. Across diverse disciplines, the scientific community has made advances to improve the presence of provenance in digital resources, which gives insight into opportunities to both advance shared science and propel new investigations.