See all Unresolved Comments and filter them

[Paul_Danyliuk]

I just made a drop-in solution that extracts all comments (both open and resolved) into a table, so that you can inspect them all in one place:

MEGA TRICK: Extract Comments into a table! (again)

Extracting doc comments into a regular table that one can sort through has been a pretty common request since circa 2020. It’s 2026 already and there’s still neither an API nor a formula to access those document comments. A while ago I made an attempt at creating a solution for this. However, the way it worked back then was extremely cumbersome and hacky. It would require you to share your doc with me, and then my server would read its raw binary data, decode it, and extract comments from that.…