Using the app

Import data from a spreadsheet into your lists

Bring numbers from a CSV, TSV, text file or spreadsheet (.xlsx) into the list memory of your calculator.

Open in Trident

Typing fifty numbers by hand is slow and easy to get wrong. If your data is already in a spreadsheet, you can paste it or open the file and the app will drop each column into a list.

This works on models that have data lists: Classic Graphing 84, Classic Scientific 30, Classic Financial II, Classic CAS and Natural Scientific 991.

1. Tap the Share button on the top edge of the calculator screen and choose "Import data…". (The item is missing on models without lists, and it is switched off during exam practice.)
2. Either paste your numbers into the box labelled "Paste numbers from a spreadsheet, CSV or list", or tap Open file and pick a CSV, TSV, TXT or spreadsheet (.xlsx) file. For a workbook with several sheets, choose one under Sheet.
3. Check the preview. Leave Separator on Automatic, or pick Comma, Tab, Semicolon or Space if the columns look wrong. Tick "Decimal comma (3,14)" if your numbers use a comma as the decimal point. Tick or untick "First row is column names".
4. Under each column, choose which list it should go into, or choose Skip to leave that column out. Two columns cannot go to the same list.
5. Check the counts under each column ("12 values"). A note such as "2 cells are not numbers and will be skipped" tells you some cells were text.
6. Tap "Import into" followed by your model name. A message says how many lists were imported. Now open the statistics editor on the calculator to see the numbers.

Tips

• Importing replaces what was in the lists you chose, so export first if you want to keep the old numbers.
• Only numbers are imported. Names and labels in a column are skipped.
• To work with the data on the calculator, see the enter data lists guide.

Related guides

• Export your lists or table as a CSV fileSave your list data, or the table currently on screen, as a CSV file for a spreadsheet, or copy it as CSV text.
• Enter data into a listType a set of numbers into a list so you can summarise, plot or fit them.
• Find the mean and spread of one listGet the count, sum, mean and standard deviation of a list of numbers in one go.