Use Wine (free) or CrossOver (paid) to run the Windows .exe on macOS.
~/Library/Application Support/Climate Consultant/Climate Data Opening Files : Launch the app, and at the "Select Units" screen, click Open EPW Weather File to load your data. Society of Building Science Educators Key Features Visualizations Climate Consultant Download For Mac
In the Climate Consultant interface: