Transferring Spreadsheets Between Microsoft Excel and your TI-83+, TI-84+, TI-89, TI-92+, or Voyage 200

Filed under Difficulty: Easy, Microsoft Excel, Statistics, TI-83 Plus, TI-84 Plus, TI-89, TI-92 Plus, Voyage 200.

Using these steps are useful when you want to put large amounts of data on your TI-83 Plus, TI-84 Plus, TI-89, TI-92+, or Voyage 200 calculator for statistical analysis. Afterwards you can also transfer data back from your calculator to Excel. If you aren’t sure how to connect your calculator to a computer, you can read our article on installing TI-Connect here.


Screen1 Transferring Spreadsheets Between Microsoft Excel and your TI 83+, TI 84+, TI 89, TI 92+, or Voyage 200

1. First, create your spreadsheet in Excel. The spreadsheet must contain only numeric data, so do not add column headings.
Screen2 Transferring Spreadsheets Between Microsoft Excel and your TI 83+, TI 84+, TI 89, TI 92+, or Voyage 200
2. In Excel, select “Save As,” name your file, and under the dropbox labeled “Save as type:” select “CSV (Comma Delimited) (*.csv).” Press the “Save” button.
3. Close your spreadsheet in Excel. Otherwise, Excel will prevent TI Connect from opening the file.
4. Open up TI Connect and select TI DataEditor.
Screen3 Transferring Spreadsheets Between Microsoft Excel and your TI 83+, TI 84+, TI 89, TI 92+, or Voyage 200
5. In TI DataEditor, select File -> Import, and find your spreadsheet file you just saved. Be sure to select “Files of type:” as “Excel Comma Separated Files (*.csv).”
6. Select your file and press “Open.” Your data will appear on the screen. Note that if your data has multiple columns, it will be imported as a matrix, whereas if it has only a single column, it is imported as a list. In some cases, it may be better to break up your spreadsheet into individual columns separately in order to generate multiple lists so you can use your calculator’s built-in list functions.
Screen4 Transferring Spreadsheets Between Microsoft Excel and your TI 83+, TI 84+, TI 89, TI 92+, or Voyage 200
7. Select Actions->Send Selected Items and select your calculator to send the data file to your calculator.
Screen5 Transferring Spreadsheets Between Microsoft Excel and your TI 83+, TI 84+, TI 89, TI 92+, or Voyage 200

Now your data is stored on your calculator and can be accessed using all of your calculator’s data analysis and editing functions.

2 Responses to Transferring Spreadsheets Between Microsoft Excel and your TI-83+, TI-84+, TI-89, TI-92+, or Voyage 200

  1. Julie Reakes

    This is very helpful. Could you please tell me how I then get my data from a matrix into my stats lists? Thanks.

    Julie

  2. Jay

    There are two ways. I did it in the DataEditor. When I did “import” it automatically made it a matrix (because of multiple columns as OP stated). You can tell it did this by seeing the “[*]Matrix” tab is selected at the bottom. Select the “{..} List” tab, and then “file”, “new”, “list”, and create as many new lists as you have columns of data. Double click the top (header) of each list, and give it a custom name if you wish. Then go back to the “Matrix” tab and select a column of data, copy it, and go back to the “List” tab and past it in the list you want it in. Repeat for all your columns of data.

    Or you could send to your calculator as a matrix, then use the “Matr>list(” command on your calculator. This will allow you to store a matrix of data into a set of lists.

Leave a Reply to Julie Reakes Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>