Yes, that works.
If you set up a report with the data table(s) you want, then print to .pdf, you can then select and copy/paste easily.
I did a test with file F8:0. The first time, it used the default data table view with five columns, and the labels along the left like this:
Offset 0 1 2 3 4
F8:0 0 0 10.8 0 1080
F8:5 20 40.4 10.803 371.5 461.5
F8:10 19.5 0.2465 53.9 90 220
F8:15 273 450 23.99 90.05041 91
So, I opened the data table in RSLogix and changed Columns to 1, and did it again. Sure enough, I got this:
Offset 0 (Symbol) Description
F8:0 0 Water Accumlated total last interval
F8:1 0 Accumulated Water Flow Divided by 1000
F8:2 10.8 From RSView Final 1 Water Qty Setpoint
F8:3 0 Water Accumlated total
F8:4 1080 Water Qty Final 1
F8:5 20 FINAL 1 NEXT TGT LV IN %
F8:6 40.4 FINAL 1 NEXT TGT LV IN %
F8:7 10.803 To/From RSView Accumulated Water Flow Last Cycle
So, changing the data table settings in RSLogix will affect how your report ends up looking, and may make copying and pasting into excel easier.
To go from the above to excel, I did a select all, then paste into Notepad, then save as a txt file, then import into excel and chose Delimited with space as a deliminiting character.