|
crier-eventapp
|
June 21, 2017 at 5:02 am
Hello,
I want to export an enty list from one Event.
But iv i do this with the “Export to CSV” button the list isn’t really shapely. What can I do that the list i get there looks nicer an is orderd in more than one column?
|
|
Tony
|
June 21, 2017 at 5:18 am
Hi there,
What can I do that the list i get there looks nicer an is orderd in more than one column?
How are you opening the CSV currently?
The CSV should look something like this – http://take.ms/CFkoa
|
|
crier-eventapp
|
June 21, 2017 at 6:06 am
If I open that CSV with Microsoft Excel there is only one column in it and there are all Information behind each other.
|
|
Tony
|
June 21, 2017 at 6:44 am
Excel has problems with not opening CSV files using UTF8.
In excel go to ‘Data -> Import -> From Text’ – http://take.ms/q7COA
Select the CSV you downloaded from your site.
Set the original data tye as Delimited and the File origin as Unicode (UTF-8) – http://take.ms/5G6MI
On the next step make sure only ‘Comma’ is selected for the delimiters – http://take.ms/GQszg
Then finish, does the data display correctly then?
|
|
crier-eventapp
|
June 21, 2017 at 9:09 am
Thanks a lot. It works well.
|
|
Tony
|
June 21, 2017 at 9:11 am
You’re most welcome 🙂
|
