# Saving sorted data from spreadsheet

**URL:** https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516
**Category:** ParaView Support
**Created:** [October 14, 2022, 6:54am UTC](https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516 "2022-10-14T06:54:21Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![MAGAN\_SINGH](https://discourse.paraview.org/user_avatar/discourse.paraview.org/magan_singh/32/1978_2.png) [@MAGAN\_SINGH](https://discourse.paraview.org/u/MAGAN_SINGH)
#### Post date: [October 14, 2022, 6:54am UTC](https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516/1 "2022-10-14T06:54:21Z")

</div>

Hello  
I want to save sorted data from the spreadsheet for all time steps.

By default, data is saved in the following format where block numbers are in ascending order for all time steps.  
I used the option: File \> Save Data

 ![Screenshot from 2022-10-14 12-13-19](https://discourse.paraview.org/uploads/default/original/2X/a/a42d0307046990e05d6cc6fa0f2880b3ca195086.png)

But I want to save data in the following order where block numbers are in descending order. I can save data manually in this order but the time steps are huge.

 ![Screenshot from 2022-10-14 12-13-32](https://discourse.paraview.org/uploads/default/original/2X/f/f0477c4f355eb96d808fd3848f04a7d22bdab34f.png)

I am using Paraview-5.10.0.

Thank you  
Magan

---

<div class="post-metadata">

### Author: ![mwestphal](https://discourse.paraview.org/user_avatar/discourse.paraview.org/mwestphal/32/17_2.png) [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [October 14, 2022, 8:02am UTC](https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516/2 "2022-10-14T08:02:53Z")

</div>

Hi @MAGAN_SINGH ,

Use the SaveSpreadsheet button, here:  
 ![a](https://discourse.paraview.org/uploads/default/original/2X/1/17dd938bd4e2b6e30955796ebcb74c8f64e633c3.png)

Best,

---

<div class="post-metadata">

### Author: ![MAGAN\_SINGH](https://discourse.paraview.org/user_avatar/discourse.paraview.org/magan_singh/32/1978_2.png) [@MAGAN\_SINGH](https://discourse.paraview.org/u/MAGAN_SINGH)
#### Post date: [October 14, 2022, 10:16am UTC](https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516/3 "2022-10-14T10:16:50Z")

</div>

Hi @mwestphal  
I think this option is used for the current time step.  
I have total 500 time steps and if I use this option for each time one by one; this will take huge time.

Is there any other way?  
Thank you  
Magan

---

<div class="post-metadata">

### Author: ![mwestphal](https://discourse.paraview.org/user_avatar/discourse.paraview.org/mwestphal/32/17_2.png) [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [October 17, 2022, 1:42am UTC](https://discourse.paraview.org/t/saving-sorted-data-from-spreadsheet/10516/4 "2022-10-17T01:42:00Z")

</div>

I’m afraid ParaView is not a table editor. You may want to do the final step in excel or something similar.