Exporting data, Exporting table data – Measurement Computing USB-5100 Series User Manual

Page 47

Advertising
background image

USB-5100 Series Software Help

Modifying a Plot

After the plot is displayed, you can apply minimum, maximum, and average filters to the scaled series as you
would for any sensor data series.

Exporting Data

While USB-5100 Series offers many tools for analyzing data, there may be instances where you need to export
data for use in other software. Refer to the following for exporting data and other related topics:

Exporting Table Data
Exporting Details
Copying Points Data into Another Application
Formatting the Date/Time Column in Excel

Exporting Table Data

You can export the data shown in the points table to a Microsoft Excel file or to a text file (.

csv

or

.txt

) for

importing into other applications.

To export data, complete the following steps:

1. From USB-5100 Series files: Open a data or project file. Make sure the points table includes the series you

want to export. This might include series pasted from other data files or series derived through filters .
Make any changes as necessary.

2. Select

File»Export Table Data

or click the Export icon

on the toolbar.

Figure 29. Export Dialog Box

3. To change the export settings, click the Preferences button

. Make any changes to the settings and then

click

OK

in the

Preferences

dialog box to return to the

Export

dialog box.

Note

Changes to the

Use export ordering rules

preference are not automatically displayed in the

Export

dialog box;

they does take effect the next time you open the

Export

dialog box.

4. Select the series you wish to include in the exported file. Use the All and None buttons or the checkboxes

in the Select column to make your changes.

Note

Only the series that are listed in the points table in a plotted data file are available to export from this dialog
box. To make additional series appear in this dialog box, click

Cancel

and go back to step 1.

5. The data is exported in the order displayed in the

Export

dialog box. To change this sort order, click a

column header in the Export dialog box. You can sort the

Measurement

,

Units

,

S/N

, and

Label

columns in

both ascending and descending order. Or, click a row to drag that series to a different position in the list.

47

Advertising