You can show hidden files in an open dialog by hitting "Cmd-Shift-period". It unfortunately doesn't work in finder though.