# Glide skipping rows when importing CSV file

**URL:** https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004
**Category:** Report a Bug
**Created:** [August 30, 2024, 8:11pm UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004 "2024-08-30T20:11:15Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)
#### Post date: [August 30, 2024, 8:11pm UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/1 "2024-08-30T20:11:15Z")

</div>

I have a csv with 87 rows, I tried importing it all at once to a regular table (not a big table) and some rows are missing.

It’s not the first time that it happens, so I put an ID to identify which ones it skips:

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

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/4568abbeac7e7e77bd076b5b833f001bc7bfee71.png)

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [August 31, 2024, 2:05am UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/2 "2024-08-31T02:05:22Z")

</div>

Hola Valeria!

Do you have any link to download your CSV file and test it?

Chao

---

<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: [August 31, 2024, 3:29am UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/3 "2024-08-31T03:29:43Z")

</div>

Does your CSV file include a RowID column?  
If yes, what happens if you remove that column before importing the data?

---

<div class="post-metadata">

### Author: ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)
#### Post date: [September 1, 2024, 4:45pm UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/4 "2024-09-01T16:45:41Z")

</div>

it’s information of my company so I can’t share it. However, it’s not the first time it happens, it has happened to me with other CSV files as well

---

<div class="post-metadata">

### Author: ![Valeria](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valeria/32/66818_2.png) [@Valeria](https://community.glideapps.com/u/Valeria)
#### Post date: [September 1, 2024, 4:46pm UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/5 "2024-09-01T16:46:05Z")

</div>

No, it just has ID\_BO as stated

---

<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: [September 2, 2024, 12:14am UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/6 "2024-09-02T00:14:37Z")

</div>

I don’t know if it makes a difference, but can you try converting the CSV file to ODS before importing to see if it makes a difference?

---

<div class="post-metadata">

### Author: ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)
#### Post date: [September 2, 2024, 9:37am UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/7 "2024-09-02T09:37:50Z")

</div>

Oh man… a while ago we skipped using Glide Big Tables due to this. To be honest i thought this has been fixed.

How many columns are there in each row? and what types of columns

Did you check if several rows were being joined by mistake into one field…?

Try exporting the CSV.  
Delete the row id column completely.  
Delete all rows except the first one with column names.  
Add the new rows you want to import and import it again.

---

<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: [March 1, 2025, 9:38am UTC](https://community.glideapps.com/t/glide-skipping-rows-when-importing-csv-file/76004/8 "2025-03-01T09:38:04Z")

</div>

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