4-13
All subsequent list operations are applied to the lists contained in the file you select (List File 3
in the above example).
5. Using CSV Files
You can import the contents of a CSV file stored with this calculator or transferred from a
computer into the List Editor. You also can save the contents of all the list data in the List
Editor as a CSV file. These operations are performed using the CSV function menu, which
appears when you press
6
(
g
)
6
(
g
)
1
(CSV) while the List Editor is on the display.
k
Import CSV File Requirements
A CSV file that has been output from the List Editor, Matrix Editor (page 3-35), or Spreadsheet
(page 7-1), or a CSV file transferred from a computer to storage memory can be used for
import. The following types of CSV files are supported for import.
• A CSV file that uses the comma ( , ) or semi-colon ( ; ) as its delimiter, and the period ( . ) or
comma ( , ) as its decimal point. A CSV file that uses the tab as its delimiter is not supported.
• CR, LF and CRLF are supported for the line break code.
• When importing a CSV file to the calculator, if the data in Line 1 of each column of the file
(or Line 1 of Column 1 of the file) contains double quotation marks ( " ) or a single quotation
mark ( ' ), Line 1 of all of the columns of the CSV file will be ignored, and data will be input
starting from Line 2.
For information about transferring files from a computer to the calculator, see “Chapter 10
Data Communication”.
k
Transferring Data between Lists and CSV Files
u
To import the contents of a CSV file to the List Editor
1. Prepare the CSV file you want to import.
• See “Import CSV File Requirements” described above.
2. While the List Editor is on the display, press
6
(
g
)
6
(
g
)
1
(CSV) to display the CSV
function menu.
3. What you should do next depends on the type of CSV file import operation you want to
perform.
To start import from a specific row:
To overwrite the entire contents
of the List Editor:
Use the cursor keys to move the highlighting to the
row from which you want to start importing data and
then press
1
(LOAD)
1
(LIST).
Press
1
(LOAD)
2
(FILE).
• This will display a dialog box for specifying whether a CSV file should be imported from
storage memory or the SD card.
