Transcript Exporting Data from Scope to Excel

Exporting Data from the
Analog Discovery to Excel
By David Fritz and Ellen Robertson
Financial support to develop this tutorial was provided by the Bradley Department of Electrical and Computer Engineering. Virginia
Tech and the National Science Foundation [Award # 0817102, Lab-in-a-Box: Development of Materials to Support Independent
Experimentation on Concepts from Circuits and Electronics]
Save DSO Data
After you have made measurements
using the Digilent Analog Discovery,
you can save the data as a .txt file
using the option File/Export.
A pop-up window will open to allow
you to name the text file and save it
in a folder that you specify. Make
sure that the Type is “Tab delineated
Values”. The default folder is Desktop.
D. Fritz and E. Robertson
Saving Measured Values
You can export the values of the measurements that you collected on your signals by
selecting Main Measurements at the Source. A list of the channel number (C1 or C2), the
signal parameters (Name) and each value will be displayed in the Data spreadsheet on the
right-side of the pop-up window.
Select any one of the types of files to be written. Tab Delimited Values is a reliable file
format to read into Excel.
D. Fritz and E. Robertson
Open the .txt file in Excel
• Launch Excel.
• Open the .txt file using File/Open.
– Since the file is not in the expected Excel format,
you have to specify how the data will be read into
Excel.
Make sure All Files is
chosen for the File
Type or the text file
will not be visible.
D. Fritz and E. Robertson
Formatting .txt File
Select Delimited, which
should be the default when
the first pop-up window
opens. Then click Next.
D. Fritz and E. Robertson
The Delimiters selected
must include Tab, but
can also include Space
if you want to have the
TIME STEP data in
separate columns.
Comma must be used
when opening a .csv
file.
Click Finish as there is nothing in the third pop-up window that must be changed.
D. Fritz and E. Robertson
You will have the voltage measurements as a function of time for Channel 1
and 2. You can use this data to complete your lab reports rather than read
data using the cursors with the scope program.
D. Fritz and E. Robertson