Export to CSV produces different results than to Excel with NULL values

[bradstruss]

Issue Type: Bug

1. Create a query that pulls data that includes NULL values.
2. Export results to Excel. Null values are blank.
3. Export results to CSV. Null values are text "Null"

Is there a way to make the CSV export have blanks instead of text?

Azure Data Studio version: azuredatastudio 1.13.1 (d08d07fe39c7fe74f9265db02cb963c38d048299, 2019-11-14T23:00:55.976Z) OS version: Darwin x64 18.6.0

System Info

|Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-8210Y CPU @ 1.60GHz (4 x 1600)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: enabled
oop_rasterization: disabled_off
protected_video_decode: unavailable_off
rasterization: enabled
skia_deferred_display_list: disabled_off
skia_renderer: disabled_off
surface_synchronization: enabled_on
video_decode: enabled
viz_display_compositor: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|3, 4, 8| |Memory (System)|8.00GB (0.05GB free)| |Process Argv|-psn_0_94231| |Screen Reader|no| |VM|0%|

Extensions (1)

Extension|Author (truncated)|Version ---|---|--- import|Mic|0.12.0

[camerondm9]

I just ran into this. Somewhat annoying, but can be worked around by saving as an Excel file and then saving that as a CSV from within Excel.