How to convert csv files to excel

  • Posts: 3
  • Thank you received: 0
11 years 6 months ago #102467

I want to export my order files to excel for accounting purposes, but I can seem to convert the files.

Would appreciate any help.
Thanks

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 6 months ago #102480

There is no need to convert them.
CSV files can directly be opened by Excel.

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

  • Posts: 3
  • Thank you received: 0
11 years 6 months ago #102481

That is what I thought, but when I exported the file and opened it in Excel 2007 it kept the csv file format. I then saved the file and tried to open it under Date, Text as a delimited file and it still saved the csv format.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 6 months ago #102521

Hi,

You can use "save as" in Excel 2007.
At this moment, you will create a new file and choose the format "xls".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.062 seconds
Powered by Kunena Forum