# Glide skipping random rows when importing CSV file

**URL:** https://community.glideapps.com/t/glide-skipping-random-rows-when-importing-csv-file/87118
**Category:** Report a Bug
**Created:** [May 18, 2026, 6:13am UTC](https://community.glideapps.com/t/glide-skipping-random-rows-when-importing-csv-file/87118 "2026-05-18T06:13:36Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![peterlk3460](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peterlk3460/32/92071_2.png) [@peterlk3460](https://community.glideapps.com/u/peterlk3460)
#### Post date: [May 18, 2026, 6:13am UTC](https://community.glideapps.com/t/glide-skipping-random-rows-when-importing-csv-file/87118/1 "2026-05-18T06:13:36Z")

</div>

Hi

I am a happy Glide developer but I am getting very nervous when using the import feature.

I have a .csv file with 6988 rows and 10 colums. Everytime I get different number of rows imported when I import the file. It’s not the same rows that is left out.

The table is very simpel:

 ![Screenshot 2026-05-18 080850](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/597e61a6151cbadb240c2ae52f610d0e2ecb7825.png)  
 ![Screenshot 2026-05-18 080909](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6fe9cc5cef585700c64705d6f33b659e83c62290.png)

What to do ?

Kind regards

Peter

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [May 19, 2026, 1:19pm UTC](https://community.glideapps.com/t/glide-skipping-random-rows-when-importing-csv-file/87118/2 "2026-05-19T13:19:13Z")

</div>

Hi Peter, ideas to help you troubleshoot:

1. Go the the table you want to import to.
2. Export that table.
3. Open that table in Excel or Google Sheets. You now have your template spreadsheet.
4. Remove the data from that spreadsheet starting row 2. Leave row 1 with the columns headers.
5. Without changing anything (don’t change the order of the column), put the data you want to import inside this sheet. If need be, duplicate the sheet and work on the duplicate. At the end of the day, the template sheet is the one you want to stick with.
6. Make sure you don’t have empty rows of data in the middle of your data.
7. Make sure you don’t have tons of empty rows of data at the end (below) the data.
8. Once all the data is in this template sheet, remove any other sheets in the spreadsheet.
9. Save to csv.
10. Import to the table in question in the data editor.

Is this what you did?