Jul 2010
1 / 5
Jul 2010
Feb 2012
mdgbv
Jul '10

I have never had an issues dowloading my transaction reports and opeing them with Excel. When I ran it for June, the report has a number of fields all together. That is to say, not in their own column. I have run and rerun the reports and every time the same thing.



HELP



Thanks

  • created

    Jul '10

  • last reply

    Feb '12
  • 4

    replies

  • 1.2k

    views

  • 3

    users

  • 2

    links

E-junkie_GuruWebmaster & Support Guru
Jul '10

After you download the log view, when you unzip the file to open in Excel, make sure you are specifying "tab-delimited values" if Excel asks for the data format (rather than comma-separated or anything else).

1 year later
sassy
Feb '12

I am having this same problem. I have downloaded my log in the past with no problem. But suddenly the logs are not tab delineated. And I have specified this in Excel.



Any ideas on how to get it to separate the info?



Thank you! :slight_smile:

E-junkie_GuruWebmaster & Support Guru
Feb '12

I tested a log download just now, unzipped that and found the resulting file is tab-delimited. I found this help page explaining how to import a delimited file into Excel (select "tab" as the delimiter in Step 3):

http://www.ehow.com/how14449036_import-delimited-file-excel.html

sassy
Feb '12

Well, that worked beautifully. :)



Thank you so much, Tyson. I really appreciate your time.



By the way, if anyone else out there need this tutelage as well, when you go to save your new delimited Excel file, be sure to click SAVE AS and choose Excel Workbook THEN rename the file; meaning, don't just click SAVE AS to rename the file. It's a sure fire way to go crazy. :wink: