Retaining Leading Zeros in CSV Output

To prevent Excel’s automated type detection, you must modify your SQL to explicitly format the column as text by prefixing it with an equal sign and enclosing it in double quotes: ‘=”‘ || column_name || ‘”‘ column_alias.

If the report runs in XLSX output format, Blitz Report automatically removes the =” and ” characters from the data, ensuring the data displays correctly without the formatting characters.