Failure to upload CSV

I tried to upload CSV file using these series of strings

一起,in the same place; together; with; altogether (in total),一起,yì qǐ
丈夫,husband; CL:個|个[ge4],丈夫,zhàng fu
上班,to go to work; to be on duty; to start work; to go to the office,上班,shàng bān
两,both; two; ounce; some; a few; tael; weight equal to 50 grams,两,liǎng
为什么,why?; for what reason?,为什么,weì shén me
也,also; too; (in classical Chinese) final particle serving as copula,也,yě
介绍,to present; to introduce; to recommend; to suggest; to let know; to brief,介绍,jiè shào
件,item; component; classifier for events, things, clothes etc,件,jiàn
休息,rest; to rest,休息,xiū xi
但是,but; however,但是,dàn shì
便宜,small advantages; to let sb off lightly; cheap; inexpensive,便宜,pián yi
公共汽车,bus; CL:輛|辆[liang4],班[ban1],公共汽车,gōng gòng qì chē
公司,(business) company; company; firm; corporation; incorporated; CL:家[jia1],公司,gōng sī
公斤,kilogram (kg),公斤,gōng jīn
再,again; once more; re-; second; another; then (after sth, and not until then),再,zài
准备,preparation; prepare,准备,zhǔn beì
出,to go out; to come out; to occur; to produce; to go beyond; to rise; to put forth; to happen; classifier for dramas, plays, operas etc,出,chū
别,to leave; to depart; to separate; to distinguish; to classify; other; another; do not; must not; to pin,别,bié
到,to (a place); until (a time); up to; to go; to arrive,到,dào
千,thousand,千,qiān
卖,to sell; to betray; to spare no effort; to show off or flaunt,卖,mài
去年,last year,去年,qù nián
可以,can; may; possible; able to,可以,kě yǐ
可能,might (happen); possible; probable; possibility; probability; maybe; perhaps; CL:個|个[ge4],可能,kě néng
右边,right side; right, to the right,右边,yòu bian
号,day of a month; (suffix used after) name of a ship; (ordinal) number,号,hào
吧,(modal particle indicating polite suggestion); …right?; …OK?,吧,ba
告诉,to tell; to inform; to let know,告诉,gào su
咖啡,coffee; CL:杯[bei1],咖啡,kā fēi
哥哥,older brother; CL:個|个[ge4],位[wei4],哥哥,gē ge
唱歌,to sing a song,唱歌,chàng gē
回答,to reply; to answer; the answer; CL:個|个[ge4],回答,huí dá
因为,because; owing to; on account of,因为,yīn weì
圆,circle; round; circular; spherical; (of the moon) full; unit of Chinese currency (Yuan); tactful; to justify,圆,yuán
外,outside; in addition; foreign; external,外,wài
大家,authority; everyone,大家,dà jiā
女人,woman,女人,nǚ rén
好吃,tasty; delicious,好吃,hǎo chī
妹妹,younger sister; fig. younger woman (esp. girl friend or rival); CL:個|个[ge4],妹妹,meì mei
妻子,wife; CL:個|个[ge4],妻子,qī zi
姐姐,older sister; CL:個|个[ge4],姐姐,jiě jie
姓,family name; surname; name; CL:個|个[ge4],姓,xìng
孩子,child,孩子,hái zi
它,it,它,tā
完,to finish; to be over; whole; complete; entire,完,wán
对,for; to,对,duì
对,right,对,duì
小时,hour; CL:個|个[ge4],小时,xiǎo shí
就,at once; right away; only; just (emphasis); as early as; already; as soon as; then; in that case; as many as; even if; to approach; to move towards; to undertake; to engage in; to suffer; subjected to; to accomplish; to take advantage of; to go with (of foods); with regard to; concerning,就,jiù
左边,left; the left side; to the left of,左边,zuǒ bian
已经,already,已经,yǐ jīng
希望,to wish for; to desire; hope CL:個|个[ge4],希望,xī wàng
帮助,assistance; aid; to help; to assist,帮助,bāng zhù
开始,to begin; beginning; to start; initial; CL:個|个[ge4],开始,kāi shǐ
弟弟,younger brother; CL:個|个[ge4],位[wei4],弟弟,dì di
张,to open up; to spread; sheet of paper; classifier for flat objects, sheet; classifier for votes,张,zhāng
得,structural particle: used after a verb (or adjective as main verb), linking it to following phrase indicating effect, degree, possibility etc,得,de
忙,busy; hurriedly,忙,máng
快,rapid; quick; speed; rate; soon; almost; to make haste; clever; sharp (of knives or wits); forthright; plain-spoken; gratified; pleased; pleasant,快,kuài
快乐,happy; merry,快乐,kuài lè
您,you (polite, as opposed to informal 你[ni3]),您,nín
意思,idea; opinion; meaning; wish; desire; CL:個|个[ge4],意思,yì si
慢,slow,慢,màn
懂,to understand; to know,懂,dǒng
房间,room; CL:間|间[jian1],房间,fáng jiān
所以,therefore; as a result; so,所以,suǒ yǐ
手机,cell phone; cellular phone; mobile phone; CL:部[bu4],手机,shǒu jī
手表,wrist watch; CL:塊|块[kuai4],隻|只[zhi1],個|个[ge4],手表,shǒu biǎo
打篮球,play basketball,打篮球,dǎ lán qiú
找,to try to find; to look for; to call on sb; to find; to seek; to return; to give change,找,zhǎo
报纸,newspaper; newsprint; CL:份[fen4],期[qi1],張|张[zhang1],报纸,bào zhǐ
教室,classroom; CL:間|间[jian1],教室,jiào shì
新,new; newly; meso- (chemistry),新,xīn
旁边,lateral; side; to the side; beside,旁边,páng biān
旅游,trip; journey; tourism; travel; tour,旅游,lǚ yóu
早上,early morning; CL:個|个[ge4]; Good morning!,早上,zǎo shang
时间,time; period; CL:段[duan4],时间,shí jiān
晚上,in the evening; CL:個|个[ge4],晚上,wǎn shang
晴,clear; fine (weather),晴,qíng
最,most; the most; -est,最,zuì
服务员,waiter; waitress; attendant; customer service personnel; CL:個|个[ge4],服务员,fú wù yuán
机场,airport; airfield; CL:家[jia1],處|处[chu4],机场,jī chǎng
次,next in sequence; second; the second (day, time etc); secondary; vice-; sub-; infra-; inferior quality; substandard; order; sequence; hypo- (chemistry); classifier for enumerated events: time,次,cì
欢迎,to welcome; welcome,欢迎,huān yíng
正在,in the process of (doing something or happening); while (doing),正在,zhèng zài
每,each; every,每,měi
比,(particle used for comparison and “-er than”); to compare; to contrast; to gesture (with hands); ratio,比,bǐ
水果,fruit; CL:個|个[ge4],水果,shuǐ guǒ
洗,to wash; to bathe,洗,xǐ
游泳,swim,游泳,yóu yǒng
牛奶,cow’s milk; CL:瓶[ping2],杯[bei1],牛奶,niú nǎi
玩,toy; sth used for amusement; curio or antique (Taiwan pr. wan4); to play; to have fun; to trifle with; to keep sth for entertainment,玩,wán
生日,birthday; CL:個|个[ge4],生日,shēng rì
生病,to fall ill; to sicken,生病,shēng bìng
男人,a man; a male; men; CL:個|个[ge4],男人,nán rén
白,white; snowy; pure; bright; empty; blank; plain; clear; to make clear; in vain; gratuitous; free of charge; reactionary; anti-communist; funeral; to stare coldly; to write wrong character; to state; to explain; vernacular; spoken lines in opera; surname Bai,白,bái
百,hundred; numerous; all kinds of; surname Bai,百,bǎi
真,really; truly; indeed; real; true; genuine,真,zhēn
眼睛,eye; CL:隻|只[zhi1],雙|双[shuang1],眼睛,yǎn jing
着,particle attached after verb to indicate action in progress, like -ing ending,着,zhe
票,ticket; ballot; bank note; CL:張|张[zhang1]; person held for ransom; amateur performance of Chinese opera; classifier for shipments and business transactions (topolect),票,piào
离,to leave; to part from; to be away from; (in giving distances) from; without (sth); independent of; one of the eight trigrams of the Book of Changes representing fire (old),离,lí
穿,to bore through; pierce; perforate; penetrate; pass through; to dress; to wear; to put on; to thread,穿,chuān
笑,laugh; smile; CL:個|个[ge4],笑,xiào
第一,first; number one,第一,dì yī
等,to wait for; to await,等,děng
红,bonus; popular; red; revolutionary,红,hóng
给,to; for; for the benefit of; to give; to allow; to do sth (for sb); (passive particle),给,gěi
羊肉,mutton,羊肉,yáng ròu
考试,exam; CL:次[ci4],考试,kǎo shì
自行车,bicycle; bike; CL:輛|辆[liang4],自行车,zì xíng chē
船,a boat; vessel; ship; CL:條|条[tiao2],艘[sou1],隻|只[zhi1],船,chuán
药,medicine; drug; cure; CL:種|种[zhong3],服[fu4],药,yào
西瓜,watermelon; CL:條|条[tiao2],西瓜,xī guā
要,important; vital; to want; will; going to (as future auxiliary); may; must,要,yào
觉得,to think; to feel,觉得,jué de
让,to yield; to permit; to let sb do sth; to have sb do sth,让,ràng
课,subject; course; class; lesson; CL:堂[tang2],节|節[jie2],門|门[men2],课,kè
贵,expensive; noble; your (name); precious,贵,guì
走,to walk; to go; to run; to move (of vehicle); to visit; to leave; to go away; to die (euph.); from; through; away (in compound verbs, such as 撤走); to change (shape, form, meaning),走,zǒu
起床,to get up,起床,qǐ chuáng
跑步,to walk quickly; to march; to run,跑步,pǎo bù
路,road; path; way; CL:條|条[tiao2],路,lù
跳舞,to dance,跳舞,tiào wǔ
踢足球,play soccer(football),踢足球,tī zú qiú
身体,(human) body; health; CL:個|个[ge4],身体,shēn tǐ
过,to pass (time); to celebrate (a holiday); to live; to get along,过,guò
运动,movement; campaign; CL: 場|场[chang3]; sports,运动,yùn dòng
还,still; still in progress; still more; yet; even more; in addition; fairly; passably (good); as early as; even; also; else,还,hái
进,to advance; to enter; to come (or go) into; to receive or admit; to eat or drink; to submit or present; (used after a verb) into, in; to score a goal,进,jìn
远,far; distant; remote,远,yuǎn
送,to deliver; to carry; to give (as a present); to present (with); to see off; to send,送,sòng
错,mistake; error; blunder; fault; cross; uneven; wrong; CL:個|个[ge4],错,cuò
长,length; long; forever; always; constantly,长,cháng
门,gate; door; CL:扇[shan4]; gateway; doorway; CL:個|个[ge4]; opening; valve; switch; way to do something; knack; family; house; (religious) sect; school (of thought); class; category; phylum or division (taxonomy); classifier for large guns; classifier for lessons, subjects, branches of technology,门,mén
问,to ask,问,wèn
问题,question; problem; issue; topic; CL:個|个[ge4],问题,wèn tí
阴,overcast (weather); cloudy; shady; Yin (the negative principle of Yin and Yang); negative (electric.); feminine; moon; implicit; hidden; genitalia,阴,yīn
雪,snow; snowfall; CL:場|场[chang2]; to have the appearance of snow; to wipe away, off or out; to clean,雪,xuě
非常,unusual; extraordinary; extreme; very; exceptional,非常,fēi cháng
题,topic; problem for discussion; exam question; subject; to inscribe; to mention; surname Ti; CL:個|个[ge4],道[dao4],题,tí
颜色,color; CL:個|个[ge4],颜色,yán sè
马上,at once, right away, immediately; lit. on horseback,马上,mǎ shàng
高,high; tall; above average; loud; your (honorific); surname Gao,高,gāo
鱼,fish; CL:條|条[tiao2],尾[wei3],鱼,yú
鸡蛋,(chicken) egg; hen’s egg; CL:個|个[ge4],打[da2],鸡蛋,jī dàn
黑,black; dark; abbr. for Heilongjiang 黑龍江|黑龙江 province in northeast China,黑,hēi

And this is the result

As you can see, only the very first row succeeds while the rest failed. I cannot see any difference in format between the first row and the rest of them, so how come they yield different results? Anybody has an answer to this problem? Thanks in advance.

Sorry, I can’t see anything obvious. However, my general experience with comma-separated files is that they are a bother to work with. Maybe you can convert your file to a tab-separated format instead? It should then have the TSV extension.

Which operating system are you working on, and what process are you using to produce the file? Are you sure that the file is encoded in UTF-8? Do you know what kind of line endings are being added? Are you able to look at the file in a text editor with hex mode or at least the option to show whitespace characters, and if so, could you post a screenshot of the file in that text editor (ideally just showing the first few lines, since we probably don’t need to see the whole file)?

If only the first line is being read in and the remaining ones are being ignored, then you probably only need to work with a file of at most three lines to determine what’s going on. For instance, try making a file that consists only of two lines, namely the second and third line of your original file. If both lines are read, then there’s something wrong with the content of the second line of your file. If the first of the lines is read but the second isn’t, it’s probably a problem with the format in general.

I will try this once I have time. Thanks.

I use a probably very outdated windows 7. I just used save as option then save as csv on an originally xlsx file using WPS spreadsheet (don’t have license on Excel). I’m pretty sure it’s already in UTF-8 because I had that error before and managed to make it not appear anymore. I haven’t tried any of those so I will try them once I have some free time. Thank you for the help.

1 Like