Long list problem

I have a list of usernames and passwords for my classes to access their online homework. When importing the csv file I can't see past 231 entries. That only covers alphabetical surnames up to the letter L. Any suggestions for what the problem might be?

Thanks in advance,
Ben.

Hi Ben,
There shouldn't be a problem with that list ... other than taking a few seconds more than usual to render properly (you'd just have to wait a bit).
I'm guessing there might be some special character that tricks the app into thinking the CSV is actually shorter than it really is.
If you are on a PC or a MAC , I'd suggest you to use LibreOffice ( libreoffice.org ) to open the original CSV file , check that nothing is wrong around rows 230ish and export again to CSV with these settings:

• Character Set Unicode (UTF-8 )
• Field Delimiter , (comma)
• Text delimiter " (double quote)
• 'Save cell content as shown'

LibreOffice has an excellent CSV parser/generator and it should solve it. If it doesn't , let us know and we'll give it another thought.


PS: Around 300-350 rows, there is a limited number of columns you're allowed to add before the app runs out of memory, I guess you're using this "class" for reference only, and there will only be a few columns in it.