Hi, thanks for any help, I am new to WordCloud, but pulling my hair out trying to do a simple CSV file import. I have checked their Sample CSV file and ensured I have copied their format, written in each row of column A entries that follow the pattern of: a number (for weight);“word i want to appear”;“”;“”
like it is in Sample file as in: 10;“sed”;“”;“”
I have tried Save As in ALL the available CSV formats, but none of them will import, each time I get the error: Error on line 1 of CSV file: First field must be an integer (for word weight).
I try with or without: weight;“word”;“color”;“url” appearing in cell 1A…
even when I make some word change to the very sample file they provide, save it, and try to import again to the site i get the error…
Thanks alot Bram! One of the several CSV format options I used was definitely UTF-8, its not that. I saw in your nother posts about that and heeded it…
Does it matter which cells I use?
I trust the weight integer is not in quotes (well actually I tried both ways, both failed…)
Its really odd when I swap a word from your Sample file to something else, save again, then try to import again, that also fails…
I had the same issue, and it seems that WordCloud saves the .csv file using semi-colons (“;”) instead of commas to indicate fields. I don’t believe this is standard (I think WordCloud should save the data using commas, not semi-colons - “csv” literally means ‘comma separated values’…), but in any case excel doesn’t see any separate fields as a result of this, and puts all the data in one column (with different lines indicating data on different words). You can however get excel to read these semi-colons as separate fields by doing “text-to-columns” function (on macOS versions at least this is under the Data menu) on that (single) column, and indicating that the delimiter is “semicolon”. If you then save this file as csv, WordCloud seems to read it without errors (for me at least). Hope this helps!