The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 10-08-2014, 07:38 PM
PBGVCAone's Avatar
PBGVCAone is offline
 
Join Date: Jul 2014
Posts: 1
Default

Export Sales CSV and Excel 2013


Apparently, when sales report is exported into CSV file, it does not include the following info on the first line: sep=; Without this text, Excel 2013 will not handle properly. FYI. older versions of Excel treat the file as delimited. I hope Ecwid can address this issue. PBGVCA
  #2  
Old 10-22-2014, 08:50 AM
Axiom
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by PBGVCAone View Post
Apparently, when sales report is exported into CSV file, it does not include the following info on the first line: sep=; Without this text, Excel 2013 will not handle properly. FYI. older versions of Excel treat the file as delimited. I hope Ecwid can address this issue. PBGVCA
Hello,

Sorry for keeping you waiting!
If I have understood you correctly, when you open an exported CSV file in Excel the file is displayed unorganized, with incorrect delimiter. Right?
Basically, when you’re doing an export, there’s a setting to choose a delimiter out of three, the one you need. (http://take.ms/1EVWw)
After you’ve downloaded the CSV and open it, Excel shows a preview with the file settings where you can select the delimiter used in the file.
Thus, as a result you’ll get a spreadsheet shown rightly.

This article also explains how to open CSV files in Excel: http://help.ecwid.com/customer/portal/articles/1182228

Alternatively you may want to use OpenOffice (a free program similar to Microsoft Office), or any text editor because technically CSV is a text format which is perfectly recognized in text editors.

If I got your question wrongly, please let me know.
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:53 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.