The Ping Scrubber Workbook is a macro-enabled Excel workbook designed as a disposable document for human review and correction of Ping-structured data. It continuously evolves to make the scrubbing process more efficient and precise. Since it's built in Excel rather than a dedicated software platform, it doesn't follow standard software concepts like backwards compatibility, interfaces, or formal standards. As a result, it's not suitable as an archival data format, and we discourage writing custom parsers for it.

Recommended ways to access scrubbing results:

<aside>

1. Access the Ping API to download structured JSON through the "Get or Create SOV Output" endpoint or the Activity & Historical APIs. More information and client libraries are available here: Ping API Documentation
2. Export JSON directly from the scrubber using the "Export to JSON" macro.
3. Access data through a Snowflake Data Share. Contact [email protected] for setup details. </aside>

If these options don't work for you, there are specific parsing methods for the Ping Scrubber Workbook that minimize compatibility issues. For .NET users, we offer an open-source client library that provides the most reliable implementation.

<aside>

See https://github.com/pingintel/ping-excel-reader-dotnet for details.

</aside>

If you're using another programming language, contact [email protected] for alternative options or guidance on best practices for parsing these files.