Download Help Green Eclipse

Importing a word list from Microsoft Excel

If you have a list of words and clues in a Microsoft Excel spreadsheet, you may be able to open it in EclipseCrossword with some modification.

Note: The instructions in this article are for Microsoft Excel.  Instructions for other spreadsheet software will be similar, but there will be minor differences.

Preparing your spreadsheet

First, delete columns and rows as necessary so that you have just two columns left: words in the left, and clues in the right.  Your spreadsheet should look something like this:

Excel screenshot

Now, right-click on the B column header, and click Insert.  Your spreadsheet will now look like this:

Excel screenshot

You're almost done.  Now, you need to add a colon ( : ) between each word and clue.  To easily do this, type a colon in cell B1, between your first word and your first clue.

Tip: You don't have to capitalize your words; EclipseCrossword will do it for you if you don't.

Excel screenshot

Then, hold down the Shift key and click on the last cell in column B that's between a word and a clue.

Excel screenshot

Finally, press Ctrl+D to fill down.  (Or, in Excel 2007 or 2010, on the Home tab, click Fill, then Down.)

Excel screenshot

Now that you have a colon between each of your words and clues, you're ready to save this spreadsheet as an EclipseCrossword word list.

Tip  It's fine if there are extra empty rows or columns.  Those are always present in Excel and can't be removed.

Saving your word list

Now, click the File menu and then Save As.  (In older versions of Excel, click the Office Button, and then Save As.)

Screenshot of Save As in Excel

Now, click the Save as Type list, and look for Text (tab delimited).  Choose this option.  Now, choose a name for your word list, and click Save.

Tip: If you save your word list with .ewl on the end, it will get an EclipseCrossword word list icon, and when you double-click on it, EclipseCrossword will automatically start.  For example, when saving the file, you can enter a filename like this, including the quotes:

 "My crossword.ewl"

You'll receive a warning that your word list may contain features that aren't compatible with this type of file.  This is fine; EclipseCrossword will be able to use the file, so click Yes.

Screenshot of Excel text file warning

Opening your word list

You can now use this word list in EclipseCrossword just like a word list that you actually created in EclipseCrossword.  (Exception: if you didn't save it with .ewl on the end as suggested in the tip above, it won't automatically open in EclipseCrossword when you double-click on it.)


* Return to the help center.
* I want to contact Green Eclipse for personal support.

Keywords: How can I use my Microsoft Office Excel (XLS XLSX CSV) spreadsheet file containing existing words and clues as a word list?