DS-2000 Frequently Asked Questions

This explains how to copy and paste the values displayed in the spectrum list into the spreadsheet software Excel.
(Operating Procedure - 1). Additionally, instructions on how to save the list display values as a text file (txt) are also included.
(Operating Procedure - 2).

In the text, the order of menu operations is indicated as [Data Display] → [List Settings].

■Operating Procedure - 1

To paste the power spectrum list data into Excel, please follow these steps:

As shown in the diagram in Step 2, switch to the list screen display. You can set the display method from the menu: [Data Display] → [List Display Settings]. Here, it is set to "Number of items in the list: 10, sorted by frequency".

Select [Edit] → [Copy Settings] from the menu to open the "Copy Condition Settings" dialog box.

In the "Copy Condition Settings" dialog box, configure each item, such as "TXT file format," as shown in the image below.

Click on the screen you want to copy to activate it. "CH1: Power Spectrum" will turn blue.

Select [Edit] → [Copy] from the menu. (Alternatively, you can right-click on the CH 1 screen and select [Copy] from the pull-up menu.)

Open Excel, select any cell in the Excel window with the copied list data, and paste it to insert the list data into the cell.
The following diagram shows an example of pasting list data into Excel using the steps outlined so far.

■Operating Procedure - 2

To save the list values as a text file (txt), please follow these steps:

From the menu, select [File] → [Save Display Data] to open the "Save Display Data" dialog box. As shown in the following figure, select File Type: TextFile (*.txt), then check the "Save ListText" option that appears and save.

As shown in the diagram below, sequential numbers are added to the filenames, and two files are created: one for spectral data and one for list data.