If you are working in projects dealing with disparate data sources, like in a Data warehouse and/or Business intelligence, you are bound to encounter some Spreadsheets. After all, spreadsheets are an excellent tool for adhoc data analysis, reporting, data storage and transmission. Come to think of it Microsoft Excel makes it very easy to handle structured data by making it user friendly; and all most everyone who dealt with any amount of data probably knows how to use Excel or a similar spreadsheet type of document.

        Due to its prevalence, you will always end up with Excel files becoming your data source. Automatically dealing with excel files, albeit possible, is not simple. On the other hand, working with CSV files is quite easy and I can't imagine and ETL tool that can't handle CSV files for bulk data import. Automation of data import jobs from a CSV file is much straight forward than an Excel file. At least that is my opinion.

Excel2CSV 1.0 - SOFTPEDIA "100% FREE" AWARD

This product was last tested in the Softpedia Labs on 13th of March 2013 by Olivian Puha Softpedia guarantees that Excel2CSV 1.0 is 100% Free, which means it does not contain any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

This software product was tested thoroughly and was found absolutely clean; therefore, it can be installed with no concern by any computer user. However, it should be noted that this product will be retested periodically and the award may be withdrawn, so you should check back occasionally and pay attention to the date of testing shown above.

        Personally, I am working with a certain ETL tool, which is very good in several other ways but can not necessarily deal with Excel files the way I'd like it. It looks at each file as an individual database and each sheet/tab as a table. This is the most logical way to think of a spreadsheet when you ae dealing with simple file with all the data in it. But this approach doesn't help when you have to deal with several files for a data import process. In my case, ideally, they all should have been CSV files.


        So came the need for an Excel to CSV converter. And I did search the internet for a converter tool, but I didn't see anything that I liked. The best part about Excel 2 CSV converter is that you can create a batch job to convert several Excel files at the same time and schedule it [in Windows Scheduled Tasks (Control Panel\Scheduled Task) on desktop and Windows task Scheduler (Server Manager\Configuration\Task Scheduler) on server].


This tool is coded in c# using Microsoft Visual C# 2008 Express Edition on a Windows XP machine.