Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to create a CSV with double quotes around all fields

  1. #1


    I need to create a CSV with double quotes, i can do it by putting a comma in each cell but that seems rather rash just to receive a comma delimited file. I need this for import purposes to a third party data base.

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Denver, Colorado USA
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    It is quite easy to write a csv file with double quotes using VBA I/O rather than saving the file as a csv file type. If you have some familiarity with writing VBA macros you could probably figure out how to do this fairly easily. Look up the keywords Open, Print #, Write #, and Close in the VBA helps.

    If you are not familiar with VBA but would like to investigate this, respond back and I will post a bit of code that will write a worksheet in csv file format with the values enclosed in double quotes.
    Keep Excelling.


    VBAexpert Excel Consulting
    LinkedIn Profile
    AllExperts Profile

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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