how to convert multiples csv files to excel format in batch mode

Posted on 2012-08-11
Last Modified: 2012-08-15
Please recommend me some software tools (free or payment) to convert multiples csv files to excel format in batch mode using command line.

Question by:jmanzo20
    LVL 3

    Assisted Solution

    by:John Smith
    Best way is to copy all .csv files into one and open it. You can do that using:

    copy *.csv merged.csv

    Go into Excel and open merged.csv.
    LVL 76

    Assisted Solution

    Not sure copy is the correct command
    more *.csv > merged.csv

    Alternatively, you can use the tools within excel to import a csv at a time and then copying and pasting the data from the importing sheet, into the data sheet.

    Author Comment

    I appreciate your answer but that requires my intervention. what I am looking for is a tool that let me do the conversion from csv to xls in batch mode from a command line that may be run using task scheduler.

    LVL 76

    Accepted Solution

    A csv is a format that excel can load. Given that you are not requesting functions, formatting
    There does not appear to be any distinction on whether the the file is merged.csv or .xls.
    You would need to use vba to handle the csv file import and the saving of the results in excel formatted file.

    You could look at a ref

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
    The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
    Video by: Tony
    This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now