Download data as CSV table ignores the table column order

App Building
, ,
1

Like the title says, when I download my table into a CSV format file. Retool doesn't format it the same way it is formatted in the table. I moved a few columns in my table to the left or right, but I don't see this in the downloaded CSV file.

Download CSV downloads the query data without looking at the table column order.

2

Welcome.

I know I've seen other threads about this. I don't recall if this was intentional or not.

Anyways, you can solve this with a transformer on your query to reorder the data however you want before it is displayed in your table. The downloaded CSV will then be in that order.

Something like:

let newData = [];

for (let i = 0; i < data.length; i++) {

  let newObject = {
    uniqueId: data[i].uniqueId,
    title: data[i].title,
    description: data[i].description,
  };
  newData.push(newObject);
}

return newData

Screen Shot 2022-12-02 at 9.36.41 AM
Screen Shot 2022-12-02 at 9.36.41 AM2142×770 66.8 KB

3

We have a feature request here for doing exactly this! Thanks for letting us know more people are looking for it :slightly_smiling_face:

4

Hey folks! Just want to mention here that the new table should respect column order when downloading data, if you're finding this to not be the case please let us know!

1 Like