I would like to create an export of pages and their visible to settings. Can someone point me in the right direction to get this information.
FilterForVisitor might be the one you're looking for
It's available in the database table tblContentAccessDetails: https://www.gulla.net/no/blog/locate-episerver-content-with-restricted-access-rights/
Depending on your use case, that might - or might not - be the easiest solution.
Give admin => tools => export data a shot.
Rename the file to .zip after export and open it. It contains information about the content, properties and the access rights you are interested in, in the <ACL> element of the epix.xml.