AutoFit columns in CSV file

[Tadas (Tadas cirklys)]

Hi,
I am using data scrape>write to CSV, and what I need is to autofit columns in this CSV file and format the data as Table. Is this at all possible in CSV? I tried looking for solutions, but the only way I found so far is to use VBA which is not available for CSV files as I understand.
Is there any alternative solution for this?
To make it more clear, this is the current outcome:

and this is the desired outcome:

[T0Bi]

May I ask why you want to write your data in csv but then continue to show us Excel (.xlsx) files?

I think you want formatted Excel files, not csv. Because a csv is something like this:

So I suggest using the excel/workbook activities, e.g. write range.

Write Range

and then use the create table activity to create your table:

Create Table

If this has helped you, please mark this answer as the solution.

[Tadas (Tadas cirklys)]

Thank you I did just that, works perfectly now!