aws2xls installation
The main features of the program, including several screen shots are presented in our main page about aws2xls, a Windows application that reads AWStats data files and converts their contents into the .xls file format used by Excel and OpenOffice.
Our program has been tested with several flavors of the popular Microsoft Windows operating systems. It is designed to be compatible with Microsoft Excel 97 and newer releases of Excel for Windows.
License terms
aws2xls and aws2xls/PRO are available from InternetOfficer SPRL. You may use these programs for the sole purpose of converting AWStats data files to files in the .xls format. You may not redistribute these programs.
These programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Free Trial
Please read the license terms above before you download the software. If you do not agree with these terms, do not download or use the software.
If you agree with these terms, you may download the evaluation version 0.05j of the software. This free evaluation version is time limited. It will expire on August 31, 2008.
Referrers must be enabled in your browser to download our program.
Purchase
Get your copy of aws2xls for only 14.99 euros (about US $ 23.20) ! aws2xls shows up to 1000 rows in each report, like AWStats does.
aws2xls/PRO shows up to 65000 rows in each report. It is priced at 99.00 euros. aws2xls/PRO is the best product to manage long lists of more than 1000 keywords, URL’s, referrers,…
Please read the license terms above before you order the software. If you do not agree with these terms, do not purchase or use the software.
If you agree with these terms, complete our order form.
Installation
aws2xls is extremely easy to install and use. After downloading the aws2xls.exe file to a convenient directory, the program is immediately ready to use.
Double click on the program name or icon to run it. This opens a DOS box that asks for the path to the AWStats data file that you want to export to Excel :
You can enter an absolute or a relative path to the selected AWStats data file.
The names of the AWStats data files are generally like this :
awstats022006.domain-name.com.txt
where 022006 shows the month and the year of the reported period and where domain-name.com is the domain name of the analyzed web site.
After you have entered the path, aws2xls will show the path to the Excel file it will create in the same directory as the AWStats data file and ask for a confirmation :
You have to enter “yes” or “y” to continue. aws2xls will read the AWStats data file and create the Excel file. When this is done, it will display a message confirming that the file has been created.
Press “Enter” to close the window.
The Excel file has been created.
Advanced Technical Details
The following limitations apply to this version :
- the number of lines of the AWStats data file may not exceed 2 000 000.
- the number of rows in a report is limited to 1000 in aws2xls and to 65000 in aws2xls/PRO. Note that all values in the AWStats data files are read and sorted, but only the 1000 (or 65000) most significant values are available in the report.
- aws2xls 0.05j is an evaluation version that will expire on August 31, 2008.
Tech Support
For technical assistance, suggestions and comments, send an e-mail to
awstats-support@internetofficer.com
April 13th, 2007 at 2:49 am
This looks like a great and useful program!
I downloaded it with no problem and copied it to a folder on my Desktop, and also copied a 100 line Awstats text file to the same folder.
It appeared to run OK and said it had created an Excel file, and, indeed, it did create a file with an xls extension.
However, Excel cannot open the file, and says that the file is corrupt.
I’m using Win XP2 on a Dell Inspiron 8600, Excel 2003, English version, that comes with Office 2003.
I am anxious to try it, and hope this is easily solved.
Thanks,
CJ
April 15th, 2007 at 4:34 pm
aws2xls does not convert the web server log files to Excel files. aws2xls converts AWStats data base files to Excel files. The AWStats data base files are generally called awstats042007.internetofficer.com.txt or something similar.
I hope this clarifies the matter.
August 6th, 2007 at 5:30 pm
where do you find the data base files?
August 6th, 2007 at 5:39 pm
The AWStats data base files are in the data directory. The data directory is defined by the DirData tag in AWStats config file.
August 23rd, 2007 at 6:44 pm
Do you need to have Excel installed on the server it is to convert rhe file? The program says it is unable to read the file. It is named awstats082007.www.rdiamondgroup.com.txt
August 23rd, 2007 at 8:20 pm
Excel is not needed to convert the files.
In most cases, this message means that aws2xls does not find the file, because the path to the file is not correct. When you only enter awstats082007.www.rdiamondgroup.com.txt, aws2xls looks for the file in its own directory.
Please try again with the full path to the file. Example:
d:\your_dir\subdirectory\awstats082007.www.rdiamondgroup.com.txt
August 23rd, 2007 at 8:48 pm
Thanks, it worked - wasn’t paying close enough attention to the example in the instructions
January 1st, 2008 at 9:33 pm
I found the site from google. It looks like I’m a day late. Is there a newer eval?
January 1st, 2008 at 9:55 pm
Update done. Happy New Year !
March 3rd, 2008 at 3:34 pm
Hi,
I tried to use the aws2xls evaluation version, but it has expired on Februar 29. Can you upload a valid version?
Thank You, Lars
March 3rd, 2008 at 7:05 pm
The new evaluation version is available now.
May 12th, 2008 at 9:47 am
This tool is really useful.
I wonder if there is the possibility to enter the path as a parameter from the command line…
Question moved to our aws2xls forum: path as command line parameter.