Making wordle really flexible

[Mike Parrott]

Here's a trick to make Wordle include exactly the words you want and
the size you want. Assumes basic knowledge of a spreadsheet
application.

1. Produce a normal wordle by pasting data into the box in create
2. From the language menu choose "show word count". Cut and paste the
data into a spreadsheet (eg Excel)
3. You should now have a column of text (eg column A) and a column of
number (eg column B). Delete the words you dont want by deleting that
row. Change the weighting by editing the number. You could manually
combine by word stem as well if you want to as Wordle doesn't
currently do that automatically
4. Insert a column between the word and the count and fill it with
colons :
5. Use the concatenate function (at least that is what its called in
excel) to combine the three columns of text into a single column of
text (eg in cell D1 type =CONCATENATE(A1,B1,C1))
6. Copy your new column into the advancd section of wordle

Your done!

[Jack]

That's great thanks Mike. In fact I find you can just create a three
column excel file (text/colon/number ) and copy and paste the whole
thing into advanced!

[Mike Parrott]

Brilliant! Hadn't even considered that it could be that simple!
Thanks.

> > Your done!- Hide quoted text -
>
> - Show quoted text -

[Salsalicious]

Hi,

I am having trouble with wordle advance.

Once I copy and past my excel list to advance and click go, it doesnt
creat my cloud. I get a blank screen with an X on the top left corner.
I am using a mix of words and phrases about 55 total. Any
Suggestions?

On Oct 2, 12:48 am, Mike Parrott <mikeparrott2...@googlemail.com>
wrote:

> > - Show quoted text -- Hide quoted text -

[Mike Parrott]

The advanced function is not at all forgiving. If just one line is
wrong (eg missing a number) it will just give you an error message. I
would double check that each line of the the spreadsheet is correct ie
word:number

You could try pasting into a simple text editor like notepad to check
it all looks ok befiore pasting into Wordle. If you paste it directly
from excel it puts a tab character between each columns text, but
wordle then ignores this character and reads it normally.

It is certainly working for me now (4:46 pm UK time, 2nd Oct)

You could try pasting this text and see if it works for you (it does
for me)

tera : 100
giga : 81
mega : 64
kilo : 49
milli : 36
micro : 25
nano : 16
pico : 9
femto : 4
atto : 1