Too many comma's in CSV file from Excel.

Posted on 2012-09-13
Last Modified: 2012-09-13
Hey Experts,

When I export a CSV file from Excel 2007, the headers plus about 12 extra comma's are exported.

I only need the column names from the first row, not those extra comma's.

Screenshot attached...

Any advice?
Question by:Modifier1000
    LVL 31

    Expert Comment

    by:Rob Henson
    I would say the Export is recognising the columns to the right of the last column as within the Used Range.

    If you press Ctrl + End or End + Home, the cursor should go to the bottom right of the used range. Is this the actual bottom right? I suspect it will be 12 columns too far right.

    Rob H
    LVL 31

    Accepted Solution

    To get rid of the surplus columns, highlight the surplus column headers and a couple of extra for good measure and delete the column.

    The surplus data could just be a stray space or apostrophe that you won't see when scanning down the columns or it could be just formatting.

    Rob H

    Author Comment

    I have not seen this in Excel, but is there a way to only export selected data?

    I have to go thru a long process to get to the computer with the data and I won't have internet or phone access once I in that lab, so I'm trying to gain as much info before having to go thru the long process of entering that lab.

    Author Closing Comment

    Thanks, worked perfectly!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    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 …
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now