# Imported Row ID not recognized as Row ID **URL:** \ **Category:** Ask for Help\ **Created:** [September 30, 2022, 1:17pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537 "2022-09-30T13:17:35Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [September 30, 2022, 1:17pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/1 "2022-09-30T13:17:35Z")
I have a problem. I need to convert an existing Google Sheet Tab to a Glide table. There’s been no mention of a timetable for Google Sheets to be convertible in the same way the Excel and Airtable tables are convertible now. When I export the data to a .CSV and re-import it in to a Glide Table, the Row ID column is _not_ recognized as a Row ID. If I _add_ a Row ID column _ALL_ my relationships will break in all my other tables! I have a _lot_ of data. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b8f51a02cdc4f505fb2ed3bbf1b551c42530a79b.png) Is there any way to make the Row ID column recognized as a Row ID, Or change the values in the added Row ID column to the values in the _old_ Row ID column? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e829df8aa3b04aa21f8b1f0ca132fe3dc0b8b105.png) ---
**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:** [October 1, 2022, 12:34am UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/2 "2022-10-01T00:34:06Z")
> [@David\_Gabler](#): > > Is there any way to make the Row ID column recognized as a Row ID, Or change the values in the added Row ID column to the values in the _old_ Row ID column? I assume it’s a no. It has never worked that way since the import function was introduced. ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [October 1, 2022, 11:00pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/3 "2022-10-01T23:00:22Z")
Thanks for responding @ThinhDinh . After giving the problem some thought, I was able to resolve the issue by changing the field in the related table instead of trying to change it in the main table. Fortunately for me, I only had one related table, but the solution would have been the same with more than one table; it just would have taken longer. Since I had the old Row ID and the new Row ID in the main table, I made a relation in my second table to the old Row ID. Then I made a Lookup Column to the new Row ID (from the main table). Then I made an empty column in the second table called “new Row ID”. Then I cut-and-pasted the data from the Lookup Column to the new Row ID column. After that, I simply needed to do “Find Uses” of the old Row ID column in the second table, and move all references from that column to the new Row ID column. After that, and confirming proper operation of the relations, I was able to safely delete the old Row ID column from the new table and the old Row ID column, the relation and the lookup column from the secondary table. 3000+ records. I had another table I unfortunately had to scrap because it was a historical data table and had records in it from multiple other tables. I could have found the relations, but in this case, the work required was not offset by any benefit of keeping the data. It was more-or-less a log anyway. ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [February 18, 2023, 2:46pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/4 "2023-02-18T14:46:41Z")
I ran into that problem this morning and here’s what I figured out for moving Row IDs from a Sheet to a Glide table. When I exported the Sheet from a different Glide app, I wasn’t able to bring along the Row ID, so I exported it directly from the Sheet. Create new empty Glide table **Edit new empty Glide table by adding Row ID column and deleting Name column** **Then** import .csv file that includes Row ID ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 18, 2023, 8:39pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/5 "2023-02-18T20:39:34Z")
Interesting. Did not work for me when I tried it just now. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00d78b8b913ec763dac38d4d600db1b7c1d3aacd.jpeg) ---
**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\ **Post date:** [February 19, 2023, 3:47pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/6 "2023-02-19T15:47:41Z")
So that’s your resulting table and neither of those Row ID columns are the one you were trying to import? Here’s a video of the process that worked for me. ---
**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:** [February 19, 2023, 4:06pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/7 "2023-02-19T16:06:34Z")
> [@David\_Gabler](#): > > Interesting. Did not work for me when I tried it just now. My guess would be because the RowID column name did not match: ![CleanShot 2023-02-20 at 00.05.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/1246e70fdc11d0c89be46c0123408bc8c5330017.png) ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 19, 2023, 10:36pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/8 "2023-02-19T22:36:40Z")
Well, no, that was not it… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8172e097833d10ce8fa195a451590b68b9db740d.png) ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 19, 2023, 10:39pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/9 "2023-02-19T22:39:45Z")
Ooof. Well I thought “don’t delete the first row”, but that did not work either. Only difference I can see is that you are on the pro plan. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b01b9ad55ac7ec784ece247fc064c800eacc5f42.png) ---
**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:** [February 19, 2023, 11:24pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/10 "2023-02-19T23:24:05Z")
Don’t forget the lock emoji 🔒. That’s still a character and part of the header name. ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 20, 2023, 2:29pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/11 "2023-02-20T14:29:52Z")
Well, even copying the column name to my spreadsheet did not work. Spreadsheet: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf11c81c2813e4a1c47dcf102f114e5a89a27c85.png) Glide: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32547346a832282e544c9ff77f4f321e0aa4d231.jpeg) Glide after creating a new table and deleting even the first row… And I got the bonus “O! Sheet! There was an error publishing your app!” ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/14bee72c1989096ed8c1ffca966193f6f79d654c.png) ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 20, 2023, 2:35pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/12 "2023-02-20T14:35:41Z")
OK, finally got it to work. The CSV must be saved in the UTF-8 format. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18b8a2e6b14a34e8525263181d8f3f8a4d1717d6.jpeg) ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [February 20, 2023, 2:44pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/13 "2023-02-20T14:44:53Z")
But since my starter plan does not support more than 5000 rows, I will not be able to import all that history anyway. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22160c4540eb1b866e30c3d5b95f905788d56091.png) ---
**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:** [February 21, 2023, 2:45pm UTC](https://community.glideapps.com/t/imported-row-id-not-recognized-as-row-id/50537/14 "2023-02-21T14:45:53Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.