change separator for Export in CSV/Excel
I 'd need to export my contacts from the marketing list. I prefer to export as Excel, but the file is generated in CSV.
Yes I know, CSV can be converted to Excel.
The point is that CSV is separated by a dash ',' In some text fields is this a part of the text. Therefore my Excel sheet is messed.
- How can I create a readable Excel file instead of CSV? (If Excel-format is selected the can only be saved als CSV)
- (Alternative) How can I predefine another separator in ActOn for Export purposes?
------------------------------
Arie den Draak
Marketing & Communication, Pirtek Benelux BV
------------------------------
Get in touch
Comments
2 comments
Are you referring to Marketing lists that you want to export?
If so, you should be able to click the drop-down arrow next to the list > Import/Export > Download to Excel - this will generate a .xls file for you.
I hope this helps.
Have a great day and Happy Marketing!
------------------------------
Robert Kohnke
Marketing Operations Strategist, Act-On Software, Inc.
------------------------------
-------------------------------------------
Original Message:
Sent: 01-11-2019 09:24
From: Arie den Draak
Subject: change separator for Export in CSV/Excel
Hi there!
I 'd need to export my contacts from the marketing list. I prefer to export as Excel, but the file is generated in CSV.
Yes I know, CSV can be converted to Excel.
The point is that CSV is separated by a dash ',' In some text fields is this a part of the text. Therefore my Excel sheet is messed.
- How can I create a readable Excel file instead of CSV? (If Excel-format is selected the can only be saved als CSV)
- (Alternative) How can I predefine another separator in ActOn for Export purposes?
Thank you very much!------------------------------
Arie den Draak
Marketing & Communication, Pirtek Benelux BV
------------------------------
For us, for a long time, the 'Export to Excel' function always exported CSV files too. I checked it today and it indeed exports an .xls file now. Was this fixed recently?
------------------------------
Thijs Krijger
Binarytree SA
------------------------------
-------------------------------------------
Original Message:
Sent: 01-11-2019 12:27
From: Robert Kohnke
Subject: change separator for Export in CSV/Excel
Hi @Arie den Draak,
Are you referring to Marketing lists that you want to export?
If so, you should be able to click the drop-down arrow next to the list > Import/Export > Download to Excel - this will generate a .xls file for you.
I hope this helps.
Have a great day and Happy Marketing!
------------------------------
Robert Kohnke
Marketing Operations Strategist, Act-On Software, Inc.
------------------------------
Original Message:
Sent: 01-11-2019 09:24
From: Arie den Draak
Subject: change separator for Export in CSV/Excel
Hi there!
I 'd need to export my contacts from the marketing list. I prefer to export as Excel, but the file is generated in CSV.
Yes I know, CSV can be converted to Excel.
The point is that CSV is separated by a dash ',' In some text fields is this a part of the text. Therefore my Excel sheet is messed.
- How can I create a readable Excel file instead of CSV? (If Excel-format is selected the can only be saved als CSV)
- (Alternative) How can I predefine another separator in ActOn for Export purposes?
Thank you very much!------------------------------
Arie den Draak
Marketing & Communication, Pirtek Benelux BV
------------------------------
Please sign in to leave a comment.