Planning to migrate to the new rules

[hushcoden]

I'm reading a post about migrating to the new OPNsense rules, and I noticed that the downloaded CSV contains multiple rows but only a single column. I was expecting each rule to occupy a row with multiple columns (one for each field). Is this expected, or is there something wrong with the export? I tried a few times, but the export looks always the same...

Tia.

[Bob.Dig]

So you never worked with a csv-file... Open it in Excel, LibreOffice or something similar. It is separated by ;. 

[meyergru]

Yes, it is a strange thing that opening CSV files without the specific CSV dialogue in Excel shows each row as being one text column only. To fix this, you need to import the file properly. In the English version of Excel, use the following menu path: Data > From Text/CSV (located in the Get & Transform Data group)