export list to excel

If you need help on how to use the program
Post Reply
taz506man
Posts: 2
Joined: 2004-04-14 23:24:01

export list to excel

Post by taz506man »

I recently downloaded your progam and was seeing what the info would look like in excel your main page says you can use the program. when i open the list in excell it puts all the info into one field, how can i move the info to excel so it is separated into the different columns.

original title media type year
in the cut dvd 2003
intolerable cruelty dvd 2003
swimming pool dvd 2003

Export to other formats: HTML (based on a template that you can modify or create yourself), SQL commands (to re-import data in a DBMS such as MySQL), CSV (text files, can be used as tables with Microsft Excel for example), Origons.com


help if you can please
antp
Site Admin
Posts: 9668
Joined: 2002-05-30 10:13:07
Location: Brussels
Contact:

Post by antp »

you have to change the value of the "separator" and "replace separator by" fields.
By default it is ";" and "," I think. Just try to exchange them. Depending of Windows configuration Excel wants ";" or "," to separate fields.
Post Reply