Exporting to an Excel worksheet

[DougB]

When I export a Caspio table or view to an Excel worksheet, the record order in Excel is random. So I have to re-sort in Excel. Why isn't it using the autonumber unique field I set up in Caspio to sort the records?

[SinJunYoung]

Hi, @DougB, how are you trying to do the export? In most cases, there may be some configurations before you export the data, creating those random order Excel file. But you can always resort them from the Excel part.

 

Quick reference: https://howto.caspio.com/tables-and-views/exporting-data/, have you tried using custom export?