This is a read-only archive of the old Scratch 1.x Forums.
Try searching the current Scratch discussion forums.

#1 2010-11-28 10:39:53

Kowalskz
New Scratcher
Registered: 2010-11-20
Posts: 20

How to import a list of words from Excel

Hi,

I am making a flashcard program,which randomly picks a word from a large list (100 words.

The program works fine. However I don't want to enter the whole list manually. Also I want to be able to change the words in the list quickly.

Is there a way to import a list from some other program such as Excel or Notepad?

Thanks.

Offline

 

#2 2010-11-28 12:11:25

-GizzardGulp-
Scratcher
Registered: 2010-03-05
Posts: 100+

Re: How to import a list of words from Excel

No, unless you can somehow create an image of the excel document; you can't. sorry


http://i1118.photobucket.com/albums/k607/Max_Levine/SnoutmolStudios.png

Offline

 

#3 2010-11-28 16:47:41

HD123
Scratcher
Registered: 2009-12-05
Posts: 500+

Re: How to import a list of words from Excel

Kowalskz wrote:

Hi,

I am making a flashcard program,which randomly picks a word from a large list (100 words.

The program works fine. However I don't want to enter the whole list manually. Also I want to be able to change the words in the list quickly.

Is there a way to import a list from some other program such as Excel or Notepad?

Thanks.

If it is a .txt file, and each word is on a different row, you should be able to import it in a list.

Note:
Here's an example of that kind of list:

Item 1
Item 2
Item 3

If you don't know how to import a list, just use the following steps:
1. Open Scratch and create a new list.
2. Right-click the new list and select "import...".
3. Find the .txt file and click "OK".
It may take a moment to import the list, since it has 100 items.

BTW, if it's in Excel, save it as "Unicode Text".  Then just use the instructions above.


~~HD123~~
Treat others as you want to be treated. |  big_smile  | http://i.imgur.com/OaNrY.gif | http://blocks.scratchr.org/libstatus.php?user=HD123&online=http://lemonfanatic.webs.com/ONLINE.png&offline=http://lemonfanatic.webs.com/OFFLINE.png

Offline

 

#4 2010-11-30 07:51:59

Kowalskz
New Scratcher
Registered: 2010-11-20
Posts: 20

Re: How to import a list of words from Excel

Thanks a lot folks.
HD123, that is a good idea.

Offline

 

#5 2010-12-01 19:51:23

Thehero
Scratcher
Registered: 2010-02-15
Posts: 93

Re: How to import a list of words from Excel

HD123 wrote:

Kowalskz wrote:

Hi,

I am making a flashcard program,which randomly picks a word from a large list (100 words.

The program works fine. However I don't want to enter the whole list manually. Also I want to be able to change the words in the list quickly.

Is there a way to import a list from some other program such as Excel or Notepad?

Thanks.

If it is a .txt file, and each word is on a different row, you should be able to import it in a list.

Note:
Here's an example of that kind of list:

Item 1
Item 2
Item 3

If you don't know how to import a list, just use the following steps:
1. Open Scratch and create a new list.
2. Right-click the new list and select "import...".
3. Find the .txt file and click "OK".
It may take a moment to import the list, since it has 100 items.

BTW, if it's in Excel, save it as "Unicode Text".  Then just use the instructions above.

Really, you can do that?

Offline

 

Board footer