How to Export SQL Results to CSV and Excel (Without Wrecking the Data)

Export a query result to CSV or Excel with the zip codes, accents and dates intact. Why double-clicking the file is what breaks it, the one-flag fix, and the checks to run after every export.