Skip to main content

CSV import to respect sort order

  • February 25, 2020
  • 2 replies
  • 43 views

Forum|alt.badge.img+10

Hi!

I’m importing a table using the CSV import block. My table is laid out in a specific order I’d like to keep.

When I import the CSV file and sort the table by Date Created, the rows get all over the place. Now, I understand that by importing the CSV all the rows are created at the exact same time and maybe that’s causing Airtable to sort it wrongly.

So I’m looking for a work around to be able to import the CSV and keep my table sorted by Date Created to keep subsequent new entries always at the top.

Thank you!

This topic has been closed for replies.

2 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Gustavo_VD,

The only work around I can think of is if you add a Field to the CSV file and call it (Date Created) and change it before importing then sort by it.

BR,
Mo


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • March 1, 2020

Hi @Gustavo_VD,

The only work around I can think of is if you add a Field to the CSV file and call it (Date Created) and change it before importing then sort by it.

BR,
Mo


Yes, I’d end up with 2 Date Created fields. One from the imported CSV and another one auto-generated based on the new entries.

I couldn’t find a better solution.