[SOLVED]Exporting product and viewing in excel

  • Posts: 179
  • Thank you received: 17
12 years 5 months ago #50901

Hi there.

When I export products and import into excel (delimited with ;) I get the descriptions area going quite mad and breaking the formatting. Is there something I am missing on the import to keep all the description in one column ?

Thanks in advance for any guidance.

Last edit: 12 years 5 months ago by rikatos.

Please Log in or Create an account to join the conversation.

  • Posts: 82821
  • Thank you received: 13368
  • MODERATOR
12 years 5 months ago #51005

Maybe your version of excel doesn't handle well the multi lines.

Try to open the file with openoffice.

The following user(s) said Thank You: rikatos

Please Log in or Create an account to join the conversation.

  • Posts: 179
  • Thank you received: 17
12 years 5 months ago #51012

You are quite right ! I spent ages with my office 2007 trying to get it to work, and lo and behold it was as simple as using a decent spreadsheet package, good old openoffice once again. !

Thank you :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum