What is Answerbag?

Ask questions and share your knowledge with the world here on Answerbag. Get the best answers where there are no duplicate questions and questions are always open - our community of over 1,142,000 will find your answer!

Join For Free!
 

How to Create a Lottery Spreadsheet in Excel

Thursday, February 19, 2009
Related Tags: lottery | data | spreadsheet | delimited | file
 

Instructions

  • Step 1:
    Go to the official website of the lottery you play. Download the lottery numbers as a text file.
  • Step 2:
    Open Microsoft Excel and import the data. Go to "File>Open" and change the file type to "Text Files."
  • Step 3:
    Open the text file you downloaded in Step 1. Choose "Delimited or Fixed Width." Delimited is when commas or tabs separate data. Fixed Width is used if there are columns with spaces between them. You can preview the file in the window below the choices.
  • Step 4:
    Choose "Next." Complete the wizard. You will need to choose the format of your data. Since the data will encompass a variety of dates and numbers, choose "General."
  • Step 5:
    Sort the data by going to "Data>Sort." Sort by any column heading you wish.
  • Step 6:
    Create a spreadsheet, or tab, for each type of lottery. Also create a spreadsheet with the same headings for your own picks.

Tips & Warnings

  • Keep a list of lottery websites in your bookmarks or Favorites list for greater accessibility.After the first download, you may find it quicker to type in the winning numbers each week.
  • Create a backup of your lottery spreadsheet each time you import new data, in case data is overwritten by accident.

Resources


Related Content
How to Convert a PDF File Into an Excel File
Portable Document Format, or PDF, files are extremely popular due to their ease of use and ability to be viewed on a variety of platforms without losing formatting or data. One of the drawbacks to...
How to Convert a Word Document into an Excel Document
Converting the data in a Word document into an Excel spreadsheet allows users to sort, search and format data, tasks which cannot be performed in a document file. Copying and pasting each entry...
How to Create Tab Delimited Files
Creating tab delimited files, that is, files where individual records are indicated by the tab character, depends on what the current form of your data is. In Microsoft Word or another word...
How to Create a Comma Delimited Text File
Comma delimited text files are like mini-data bases. They are packed with information ready to be imported and sorted as needed to analyze and hypothesize. The beauty of a file is in its...
What Is the File Extension CSA?
Unidentified.CSA files on your computer might be data files, parts of a game or video player, or components of an obscure proprietary software package.