# Importing Data into Glide Tables issue Row ID - Leading Space in fields **URL:** \ **Category:** Ask for Help\ **Created:** [March 28, 2023, 2:35am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770 "2023-03-28T02:35:39Z")\ **Posts on this page:** 7\ **Page:** 1
**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:** [March 28, 2023, 2:35am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/1 "2023-03-28T02:35:39Z")
I’ve imported data into Glide Tables but the import broke probably due to leading spaces. It treats most cells with no issues but then it breaks at a cell and continues writing into that cell instead of the next column. is there any way in Google Sheets to clear leading white spaces other than trimming the entire cell space? the cell data looks like this with an empty line at the top and at the bottom 🛵 FAST PICKUP Rayan Bakeries 📅 26/03/2023, 10:27 - Hussain 📦 SORTED FAST 📅 3/26/2023, 12:20 PM - Bader Whats worse is if I delete this data which I did in order to import a fixed csv… I can no longer import the RowID as it seems Glide recognizes the RowID and blocks the import of that row… although its been deleted from my end. I guess there is no fix to this but to completely create a new table? ---
**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:** [March 29, 2023, 12:39am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/2 "2023-03-29T00:39:35Z")
> [@abdo](#): > > is there any way in Google Sheets to clear leading white spaces other than trimming the entire cell space? So you don’t want to do a full trim on, let’s say, only this column? ---
**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:** [March 29, 2023, 9:37am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/3 "2023-03-29T09:37:20Z")
No, but its fine I’ve added a text at beginning & text at end. I just found out a new issue though, import csv is skipping entire rows ! and i didn’t import many, only 300 rows. ---
**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:** [March 30, 2023, 12:51am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/4 "2023-03-30T00:51:40Z")
> [@abdo](#): > > No, but its fine I’ve added a text at beginning & text at end. I’m not sure I understand the fix. Also, I’m not sure why leading spaces should be the cause. If you can go into further details so people who come in later can debug themselves that would be great. ---
**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:** [March 30, 2023, 8:08am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/5 "2023-03-30T08:08:44Z")
i can’t fully understand whats happening… seems like Glide Import is having some issues. I’m surprised not many have mentioned this. Have you tried it? and when you did, did you take a row count to confirm all the rows were imported correctly? ---
**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:** [March 31, 2023, 12:18am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/6 "2023-03-31T00:18:05Z")
Sorry, I don’t have a use case with this recently. If you believe there is a persistent bug, please get support from within Glide while the app is open by selecting the “?” button at the bottom right. That will bring you to a support page, which currently has an “Open Support Ticket” link. ---
**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:** [March 31, 2023, 3:31am UTC](https://community.glideapps.com/t/importing-data-into-glide-tables-issue-row-id-leading-space-in-fields/59770/7 "2023-03-31T03:31:11Z")
I have already. They have recognized the issue and are looking into it.