Opening .csv files in a default template in Excel 03/07

Posted on 2009-12-17
Last Modified: 2012-05-08
I have a 3rd party software that exports reports to a .csv format.  I want to be able to open the .csv file in Excel using a default .csv template?  Is this possible with Excel 2003 or 2007?
Question by:cpitzaferro
    LVL 4

    Expert Comment

    Offcourse, just name the extension of the file .csv and click open with microsoft excel.

    As simple as that :)

    Author Comment

    I want to be able to create a default .csv tempalte in Excel and have the file open with that template.  So that i can set the margins, font, page setup, etc.
    LVL 4

    Expert Comment

    Thats impossible.
    LVL 3

    Accepted Solution

    As a cumbersome work around, you could set up an excel file with one sheet for reading/importing your CSV file, and a second sheet that is linked to the various columns on your import sheet.  You format that second sheet to meet your default needs.  Program a little macro button to open a csv file and you simply navigate to where you file is.  I did something along these lines for some graphs, and sorting of data for some experimental data in csb format of variable length.
    LVL 4

    Expert Comment

    Hey man,

    Please close the question and give us the points we earned, its should be closed, its been 3 months.

    Thanks a lot :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    779 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

    9 Experts available now in Live!

    Get 1:1 Help Now