Let's work through some troubleshooting steps to ensure the program exports data lists in the correct .zip file format, Matthew.
Based on the steps you've described, it appears you’re utilizing QuickBooks in a web browser. When you export data using the Gear icon, the account lists are downloaded as an Excel file contained in a zip format.To rule out browser-specific issues, try using a different web browser to export these files. After switching browsers, you can download the lists again. This process can help ensure that the files are downloaded with the correct extensions and without corrupted metadata.
For any further concerns or queries, get back to us anytime on this thread.