I tried to export my subscribers list using the export function, to export my chosen preference to excel.
The export function did not tabulate the fields according to the profiles. Excel did not recognize any columns.
I used all the 3 separators (semicolon, comma and tabulation), excel did not recognize the columns still.
Here is an example below of how excel shows the exported list, the same way for the 3 separators:
What can be done about this problem ?
I request that you kindly resolve this problem of the export function, because it does not tabulate lists properly to excel, excel does not recognize all the 3 separators.
Thank you for responding.
Unfortunately excel is unable to separate the fields.
I have tried to convert to a “table”, I also tried the ‘text to data” feature but could not make the
required changes. Excel could not separate the fields into different columns and rows.
So the only option for me now is to select the fields and copy them to a text doc.
Since excel does not recognise the fields, I like to suggest creating an “export to text doc” function in the export tool, during the next update.