Showing results for 
Search instead for 
Did you mean: 

Import/Export Data between Excel and Testlab

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

(view in My Videos)

Have data in Simcenter Testlab (formerly called LMS Test.Lab) that you want to export to Excel? Have data in Excel that you want to import to Simcenter Testlab? Luckily, it’s easy!


Export to Excel:


To export data to Excel, right click on a curve, select “Copy Values” and then select “All”.


1.pngFigure 1: Copy the values directly from the plot.

Open Excel and paste the data. The first few dozen rows that are pasted contain header information: details like timestamps, weighting, and datatype etc. This is to preserve information about the data even if it is moved into Excel. 


2.pngFigure 2: Paste the data into Excel.

Below the header is the numerical data.


3.pngFigure 3: Below the header is the numerical data.

It is also possible to copy multiple curves from a display. Select multiple curves, right click, “Copy Values”, and select “All”.


4.pngFigure 4: Copy multiple curves from a display.

To copy just a subset of the data instead of the entire curve, zoom in on a narrower frequency range, right click, “Copy Values”, and select “Between X Limits”.


5.pngFigure 5: Copy range of values instead of the whole curve.

You can also copy legend data that is calculated from a double X cursor.


6.pngFigure 6: Copy values from a cursor legend.

Import Data to Simcenter Testlab


To import Excel data into Simcenter Testlab, make sure the Excel Data Driver add in is turned on. This add-in is included with the desktop and does not require any additional tokens.


7.pngFigure 7: Tools -> Add-ins -> Excel Data Driver.

Once the add-in is turned on, browse to the data in the navigator tree on the left side of the Navigator workbook. Select the Excel sheet and the data block should populate in the middle pane. Drag the data block to the display to plot it.


8.pngFigure 8: Import the Excel data into Test.Lab.

NOTE: It is important that the Excel data you are importing has a header. The header has critical information about amplitude format, weighting, and more.


Without the proper header information, the Excel data will not import into Testlab.


If you aren’t sure how to create the header, try using the Data Block Editor instead.


Data Block Editor


The data block editor is another add-in that is included in the Desktop: no additional tokens are necessary.


9.pngFigure 9: Tools -> Add-ins -> Data Block Editor.

Go to the Data Block Editor workbook. Here, the user can set the appropriate information necessary when importing to Test.Lab from Excel.


10.pngFigure 10: Data Block Editor Workbook.

In the Data Block Editor, it is possible to set the function type, format, amplitude scaling, x-axis increment information, Point ID, point direction, y axis unit, and weighting.


After setting these parameters the user can simply paste their data into the table on the right side of the screen and the picture filling the bottom half of the screen will populate with data.


To save this to your project, select “Add to Workspace” and then “Save workspace in active project” (both buttons on the right side of workbook).


Select the folder in which to save the data (or create a new folder) and select “OK”.


11.pngFigure 11: Saving the imported data to the project.

The data will be saved into the project in the specified folder.


12.pngFigure 12: The data was saved into the project and can be plotted / processed as necessary.

Enjoy the ease of importing and exporting data between Excel and Testlab!


Questions? Email or contact Siemens PLM GTAC support.


Related Links:

Siemens Phenom Siemens Phenom
Siemens Phenom

Want to put a list of modes, frequencies, and damping into Excel? Do the following:


1.  Highlight the list of modes (hold down shift and select first and last in list), right click, and choose "Properties".




2. In the Properties dialog, scroll over to the right, and highlight the columns “Frequency” and “Damping”.  Right click and pick "Copy".




3. Copy and paste into Excel.  You will have to add the mode number (and rearrange the order of the frequency and damping columns).


4. Note: You could also highlight the first column (called "Name") and paste it into Excel, and then do a “Text to Columns” operation, with Space as a delimiter.  There will be more columns than wanted, but maybe this would be more preferable.



Hello @Jacklyn

I am copyng several octaves curves from one Test.Lab graph to Excel but the order of rows on heades is not the same to all curves.

About the curves, all data was captured using the same Project, same Section and same Channels list.


Do you know what is changing the order of rows?

Siemens Phenom Siemens Phenom
Siemens Phenom

I assume the data has a different number of data properties.  If you right click on the data in a list or in a display and view its data properties, are those rows different?


It probably depends on if it was measured and processed the same way.

Feel free to reach out to the local support team and they can Skype with you to take a look.


Hello @Kevin_Grenier !

The data was the same, from same project acquired at same way (including online processing).

It happened twice, and stoped.

Unfortunately I dont know what happened and i cant reproduce this issue again.

Please disregard my question and sorry to take your time.