Jump to content
Sign in to follow this  

Convert .xls to .csv

Recommended Posts

Hi guys,

I have this job nowadays where I need to download some attachment from my email to a specfic folder on my desktop. Then from there I need to unzip a zip file which contains a lot of excel files that is needed to be converted to csv files so that it can be imported into my database.

Due to having these lots of files, I thought of writing a script to automate this. The main issue is that I need the excel files to be converted to .CSV files.

Please advice.

If @error = me Then $sorry
   Until $meClear
MsgBox(0,"Special Message!","Special Thanks to " & $allHadReplied,$Forever)

Share this post

Link to post
Share on other sites

No, its different formats. I would suggest opening each file, one at a time, and just do a File->Save As...There's no easy way to just do file manipulation. Make it easy and let Excel do it for you.

Writing AutoIt scripts since
_DateAdd("d", -2, _NowCalcDate())

Share this post

Link to post
Share on other sites

You can make an Excel macro which runs automatically whenever a file is opened. The conversion can thus be done in Excel macro; all you need to do is send the xls files to Excel.


PS Thanks Cyclops (see below). That's actually what I was looking for to suggest.

Edited by jdickens

If I am too verbose, just say so. You don't need to run on and on.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...