How to style a CSV 'external link'?

Hello, I added an external link to a csv file and enabled the update every 60 seconds option.

Then I applied some styles in the table view.

But every time the link updates I loose the formating. How to fix that?

[Example] Loading CSV into preformatted spreadsheets

One way I found is:

  • import CSV as ‘External Link’ into a sheet (sheet1)
  • create a second sheet (sheet2) that reads values from sheet1
    formula: =IF(ISBLANK($sheet1.A1);"";$sheet1.A1)
  • add styles in sheet2


  • hide sheet1

In this way, it looks like the External link was styled (workaround way), and after sheet1 refreshes, sheet2 styles are kept.