# Blank CSV file when Exporting Results

**URL:** https://community.dremio.com/t/blank-csv-file-when-exporting-results/10808
**Category:** Dremio Cloud
**Created:** [July 14, 2023, 8:58pm UTC](https://community.dremio.com/t/blank-csv-file-when-exporting-results/10808 "2023-07-14T20:58:06Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![nikki.myers](https://avatars.discourse-cdn.com/v4/letter/n/71e660/32.png) [@nikki.myers](https://community.dremio.com/u/nikki.myers)
#### Post date: [July 14, 2023, 8:58pm UTC](https://community.dremio.com/t/blank-csv-file-when-exporting-results/10808/1 "2023-07-14T20:58:06Z")

</div>

I have a couple of queries I am running in Dremio where the query returns results. However, when I click CSV to export the file, the exported file is blank. This is only happening on a couple of queries, not all. The queries are using views we created in Dremio and the views themselves export the data results correctly. It also doesn’t matter if the dataset is small (\<100) or large (\>10,000).

Anyone know what the issue might be?

---

<div class="post-metadata">

### Author: ![cindy.la](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/cindy.la/32/6730_2.png) [@cindy.la](https://community.dremio.com/u/cindy.la)
#### Post date: [July 14, 2023, 9:15pm UTC](https://community.dremio.com/t/blank-csv-file-when-exporting-results/10808/2 "2023-07-14T21:15:00Z")

</div>

Hi @nikki.myers ,

Can you confirm if you are using Dremio Cloud or Dremio Software? Additionally, are there any null values in the CSV?

Cindy

---

<div class="post-metadata">

### Author: ![nikki.myers](https://avatars.discourse-cdn.com/v4/letter/n/71e660/32.png) [@nikki.myers](https://community.dremio.com/u/nikki.myers)
#### Post date: [July 14, 2023, 9:26pm UTC](https://community.dremio.com/t/blank-csv-file-when-exporting-results/10808/3 "2023-07-14T21:26:50Z")

</div>

Actually i just figured it out. Dremio doesn’t like NULL as field\_name in the select statement. It has to be ‘’ as field\_name if you want to return a blank row.
