Import CSV to Glide Table Not Working

I have a CSV that I’ve downloaded from Google Sheets. When I try importing the CSV file into a Glide Table using the Import link by going to the Data tab, then clicking the + sign, then clicking on Import, it only imports 97 rows of data, when there are 2884 rows in the CSV file. The file size for this CSV file is only 450kb. I tried deleting that CSV import Glide table, and then trying again, but getting the same issue…it only imports 97 rows.

Appreciate the help. Seems like a bug because it’s not importing the entire CSV.

Check if the line 98-99 are ok. If the CSV has an invalid row, some systems trigger EOF.

In the Glide Table or the CSV? In the CSV, there is just normal data that resides in 98-99. In the imported Glide Table, it only goes up to 97, unless I click on New Row.

Try putting your file in here:
https://csvlint.io/

What plan are you on at the moment? Can you record a video of the issue?

Are there RowID values included in the CSV file?

If there are, that’s most likely the cause of the issue. Try removing them.

1 Like

There are no row ID columns in the CSV.

I’m on the free plan currently, which correct me if I’m wrong, allows for 25,000 rows of data. I’m currently at 399 rows, and if I add the 2844 rows in the CSV, that doesn’t push more over the limit.

When I put the CSV file in there, it returned 3 errors, not sure why though. I’m guessing that maybe it’s because I had 3 column on the far right with very little data in? Not sure. But, I deleted those columns, and was able to validate the new CSV using the link that you provided, and it came back with no errors. So, I tried uploading the newly created CSV as an import in Glide, but it still only returns 97 rows.

Can you provide you csv header and line 90 to 100? Anonymise it if needed!

To make sure I understand what you’re asking, are you wanting me to essentially create a new tab in Google Sheets, copy the data from rows 90 to 100 along with the header, download that as a CSV, and provide the link to it? Or, are you asking for me to simply create a new tab in Google Sheets, copy the header and data from rows 90 to 100, and then copy and paste that data here in a reply?

Just copy paste the CSV header (first line) and line 95 to 100

Here’s a video screencast

Nothing really jumps out in that video, so we might have to check what your CSV contains in line 98 onwards to see if there’s a special character that breaks it.

1 Like

Exact. Could be something so small like CRLF not matching.

1 Like