# Google Sheets Skipping Rows

**URL:** <https://community.glideapps.com/t/google-sheets-skipping-rows/73970>\
**Category:** Ask for Help\
**Created:** [June 7, 2024, 8:52pm UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970 "2024-06-07T20:52:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shayan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shayan/32/60726_2.png) [@Shayan](https://community.glideapps.com/u/Shayan)\
**Post date:** [June 7, 2024, 8:52pm UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970/1 "2024-06-07T20:52:28Z")

</div>

Original data:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6ae0eab5b7873c798cd5feefce06421263c27de.png)

Ok I hope the image appears but I realised this was an issue when i tried importing the data onto another sheet, but it didn’t let me override existing data.

Then I realised, all rows I had deleted appeared onto the new sheet (which I imported data to). I think it’s not letting me override data because for example on the new sheet, position D4, might be position H3 on the original, meaning overriding it will cause an error.

My question is how do I get re-order the rows so it goes down 1 by 1?  
And also when I import the data, how are the rows I’ve deleted re-appearing?

Imported data:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/10a33f7814f4bbcb6c21295d8facaf9d85e6902d.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 8, 2024, 12:08am UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970/2 "2024-06-08T00:08:42Z")

</div>

Are you deleting rows or just hiding them? Based on the image, it doesn’t look like you actually deleted rows. Otherwise the row numbers would have resequenced.

 ![Screenshot_20240607-190359](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/467f73bec1e97bddfa56a23362c26749b428d56d.png)

Not sure I completely follow your issue, but importing, it’s important that column names match. Not sure about positions, but it would help if you have a sheet or CSV file in the same order.

---

<div class="post-metadata">

**Author:** ![Shayan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shayan/32/60726_2.png) [@Shayan](https://community.glideapps.com/u/Shayan)\
**Post date:** [June 8, 2024, 11:47am UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970/3 "2024-06-08T11:47:54Z")

</div>

Turns out I wasn’t hiding anything - I had accidentally added 2 filters, and when I right clicked and pressed ‘remove filters’ it was all good. That’s why the left and the top (y and x axis) was slightly green and not white.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 8, 2024, 1:40pm UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970/4 "2024-06-08T13:40:46Z")

</div>

So has your issue been solved?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 4, 2024, 6:32pm UTC](https://community.glideapps.com/t/google-sheets-skipping-rows/73970/5 "2024-09-04T18:32:00Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.