Call for Paper - May 2023 Edition
IJCA solicits original research papers for the May 2023 Edition. Last date of manuscript submission is April 20, 2023. Read More

An Efficient Technique for Web Log Preprocessing using Microsoft Excel

International Journal of Computer Applications
© 2014 by IJCA Journal
Volume 90 - Number 12
Year of Publication: 2014
Chintan H. Makwana
Kirit R. Rathod

Chintan H Makwana and Kirit R Rathod. Article: An Efficient Technique for Web Log Preprocessing using Microsoft Excel. International Journal of Computer Applications 90(12):25-28, March 2014. Full text available. BibTeX

	author = {Chintan H. Makwana and Kirit R. Rathod},
	title = {Article: An Efficient Technique for Web Log Preprocessing using Microsoft Excel},
	journal = {International Journal of Computer Applications},
	year = {2014},
	volume = {90},
	number = {12},
	pages = {25-28},
	month = {March},
	note = {Full text available}


Web log file shows the behavior of user when they access the website. It is in text format and automatically generated by web server whenever user accesses the website. Entry of particular web page with date, time, cs-method, cs-uri-stem and other information is generated automatically in text file for every access of web page. Web Usage Mining is different mining technique apply on weblog file to discover the different pattern which is useful for efficient design of website, performance enhancement of server etc. Mining of web log file consist of three steps Data Preprocessing, Pattern Discovery and Pattern Analysis. Data preprocessing task convert the web log file in database by applying data extraction, data storage and data cleaning technique. In existing technique data extraction from the log file is perform line by line and store in multidimensional array and then extracted data field will be store in database and then data cleaning is performed. In this research paper, a new technique is being proposed for Data Preprocessing of web log using Microsoft Excel. The experimental results show that the proposed new technique using Microsoft excel file is an effective compare to existing technique.


  • P. Nithya and Dr. P. Sumathi, Novel Pre-Processing Technique for Web Log Mining by Removing Global Noise and Web Robots, IEEE National Conference on Computing and Communication Systems (NCCCS), 2012
  • S. Chitra and Dr. B. Kalpana, A Novel Preprocessing Mixed Ancestral Graph Technique for Session Construction, IEEE International Conference on Computer Communication and Informatics (ICCCI-2013), Jan. 04 – 06, 2013, Coimbatore, INDIA
  • Manisha Valera and Kirit Rathod, A Novel Approach of Mining Frequent Sequential Pattern from Customized Web Log Preprocessing, International Journal of Engineering Research and Applications, Vol. 3, Issue 1, February 2013, 269-380
  • Surbhi Anand and Rinkie Rani Aggarwal, An Efficient Algorithm for Data Cleaning of Log File using File Extenstions, International Journal of Computer Applications, 48(8), June 2012, 13-18
  • V. Chitraa and Dr. Antony Selvadoss Thanamani, A Novel Techniques for Sessions Identification in Web Usage Mining Preprocessing, International Journal of Computer Applications, 34(9), November 2011, 23-27
  • Margaret H. Dunham, Data Mining Introductory and Advanced Topics, 8th Impression, Person, 2012, 193-218.
  • Ms. Dipa Dixit and Ms. M Kiruthika, PREPROCESSING OF LOG FILES, International Journal on Computer Science and Engineering(IJCSE), Vol. 02, No. 07, 2010, 2447-2452.
  • Vijayashri Losarwar, Dr. Madhuri Joshi, "Data Preprocessing in Web Usage Mining", International Conference on Artificial Intelligence and Embedded Systems (ICAIES'2012) July 15-16, 2012 Singapore.