# Google Sheets: Column headers not loading

**URL:** <https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931>\
**Category:** Ask for Help\
**Created:** [May 13, 2022, 12:40pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931 "2022-05-13T12:40:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ric\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ric_1/32/22052_2.png) [@Ric\_1](https://community.glideapps.com/u/Ric_1)\
**Post date:** [May 13, 2022, 12:40pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931/1 "2022-05-13T12:40:11Z")

</div>

Hello Gliders,

I’m using Google Sheets as my data source.

- The Glide doesn’t show column headers but labels them column1/2/3.
- The row data is displayed OK, only the headers are missing.
- The Google Sheet shows all column headers OK.
- A reload doesn’t fix the issues.
- I checked that there are no empty column headers already.

What could be causing this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 13, 2022, 12:48pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931/2 "2022-05-13T12:48:03Z")

</div>

- Are the column headers static, or dynamic? (ie. generated from formulas?)
- Are the column headers the very first row in each sheet?

---

<div class="post-metadata">

**Author:** ![Ric\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ric_1/32/22052_2.png) [@Ric\_1](https://community.glideapps.com/u/Ric_1)\
**Post date:** [May 13, 2022, 1:00pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931/3 "2022-05-13T13:00:44Z")

</div>

Thanks Darren

1. All are dynamic formula columns (array, importrange). This worked fine so far and is still working on other sheets with similar formula.
2. Yes, all column header are in the first row of the sheet and there are no empty ones.

Edit: Removed some newly added columns and added a Row ID, now the row content has vanished, too. ☹

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 13, 2022, 1:16pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931/4 "2022-05-13T13:16:00Z")

</div>

> [@Ric\_1](#):
>
> All are dynamic formula columns (array, importrange). This worked fine so far and is still working on other sheets with similar formula.

My guess would be that this is the source of the problem, and most likely the importrange. If the source temporarily “disappears” - for whatever reason - and Glide happens to sync at that time, then you’ll wind up with what you’re seeing.

When using importrange, the safest thing is to use static column headers, and then start the importrange at row 2.

---

<div class="post-metadata">

**Author:** ![Ric\_1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ric_1/32/22052_2.png) [@Ric\_1](https://community.glideapps.com/u/Ric_1)\
**Post date:** [May 13, 2022, 1:33pm UTC](https://community.glideapps.com/t/google-sheets-column-headers-not-loading/41931/5 "2022-05-13T13:33:26Z")

</div>

Will try to do so and report in.