AutoFit columns in CSV file

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:

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.

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

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

Thank you I did just that, works perfectly now!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.