+ Reply to Thread
Results 1 to 8 of 8

Turning an Excel file into CSV

Hybrid View

  1. #1
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,070

    Re: Turning an Excel file into CSV

    When you create a CSV file, each row of data will become one record in the CSV file. The data in the cells will appear in the row separated by commas. If you have empty cells, you'll get two commas.

    Have a look at the attached examples. One is a sample from another thread, the second is the same file saved as a CSV file. View it in NotePad.
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Turning an excel file into a csv.txt file
    By Kevin P in forum Excel General
    Replies: 0
    Last Post: 10-18-2012, 08:29 AM
  2. Turning off AutoFilter via VBA does not seem to work for this file.
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-16-2012, 11:38 AM
  3. Help with turning off auto numbering once a excel file is saved
    By mkeehn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2011, 07:22 PM
  4. turning off save file prompt
    By cmoral1266 in forum Excel General
    Replies: 0
    Last Post: 08-30-2011, 11:01 AM
  5. Replies: 1
    Last Post: 01-26-2006, 01:00 AM
  6. Turning off automatic calculation when opening a CSV file
    By Will in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2005, 06:05 AM
  7. [SOLVED] Disabling formulas and turning file into text only
    By Christine in forum Excel General
    Replies: 3
    Last Post: 04-01-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1