Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Add Smart Quotes To A Csv File

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

View Answers     

Similar Excel Tutorials

Mark an Excel File as Complete and Final Version
This feature allows you to make an Excel file that tells everyone that it is the final version, the completed vers ...
Password Protect Excel Files
How to keep an Excel workbook safe by encrypting it with a password. This will make it so that a user cannot open ...
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
I'll show you how to create a message box popup window in Excel that contains text on multiple lines.  This allows ...
Link to Cells on Other Worksheets in Excel
It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are listed below as well as p ...

Helpful Excel Macros

Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can only
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Output the File Path to and Name of a Workbook in Excel - UDF
- Free Excel UDF (user defined function) that displays the full file path and name of an Excel workbook. This function is

Similar Topics

I am using Excel 2003 and trying to put together a worksheet with stock
prices, using smart tags. The stock prices all update (I'm using MSN Money
Stock Quotes), but not every stock symbol displays a smart tag. The smart
tags are helpful as they carry a link back to news and other info on the

How can I get ALL the stocks to show smart tags? Incidentally, the stocks
I'm talking about are well known stocks like GM, Proctor & Gamble & Ford.

Thanks in advance.

I saved an Excle file containing text into a tab delimeted text file and all
the data is now in quotes. The file will be used as a input file to another
progarm and the quotes will not be accepted. How can the quotes be left off?

A Smart Tag is a pop-up menu that allows access to more commands that are relevant to the current task.

1. Select File -> Excel Options
-> Proofing -> AutoCorrect Options -> Smart Tags tab.
2. From Show smart tags as dropdown list, select None.


I have a very big import to do from Excel 2002 to a .txt file. I need
double quotes around all text fields, but I get everything but. Can
someone pleeeese tell me how to do this.

Do I need the format of the fields to be general or text? Do I start
with single quotes, double quotes, no quotes or maybe even two single
quotes? I've tried everything I can think of.

I even tried going through a .csv file, but then I get three double

Thanks a bunch,


This is an annoying problem. I have to import data into a program as a .txt file. The program has a bug and does not recognize quotes that protect values with commas from real quotes within values. So any value with a comma comes in with quotes and any value with quotes goes in with double quotes. They have acknowledged that this is a bug in their import utility and it may or may not get fixed in the next version

So in the meantime, I have to import several files containing information that may or may not have quotes and or commas that would cause "tricky" quotes. Is there a VB script I can run on the .txt file or any other ideas you may have for removing quotes that have soley been put in to preserve values containing commas? Here is an example of my data:

Primary Key Description
100 Man with dog, Mt. Tamalpais in background
101 "Titanic"
102 Originial, "Man with head dress, Inuit"

In the .txt file it appears (as it should)
Primary Key Description
100 "Man with dog, Mt. Tamalpais in background
101 ""Titanic""
102 "Original, ""Man with head dress, Inuit"""

So basically, I want to be able to save this file as a .txt file without the embedded delimited quotes but keep the original quotes originally in the values.

Any help or ideas would be greatly appreciated.


I am trying to open a text CSV file in Excel to edit the file, but require
certain fields to have double quotes around them. When I do this, I get the
message about not all features are supported and when I then look at the
file, the double quotes are gone. Is there a way to keep the double quotes
when making the changes and then saving the file as CSV.


I've got a good one here for you all.

A user of mine goes to a website and downloads a file to his PC (clicks on Save when prompted from the open/save dialog box), and for some reason, when he opens the file, each number in every cell appears with quotes surrounding them. The quotes SHOULD NOT be there.

Funny thing is that when he opens the file from the website (clicks Open from the open/save dialog box) and then saves the file through the usual File > Save As, closes and reopens the file, there are no quotes as it should be.

This one is baffling me . Has anyone else ran into this issue?

Any help would be appreciated.


When Smart Tags are turned on, Excel recognizes specific entries and will add
a smart tag where applicable. For example, if you enter MSFT, Excel will
recognize this as a stock symbol and add the smart tag. My question is how
do I get Excel to recognize an entry as a stock symbol and add the smart tag
if it doesn't do it automatically?

I have a file that was exported to a txt file from one of our systems and brought into excel. I need to get it in a sortable format. Is there a way to write a macro to move the invoice number and store name to the right of each column. Please let me know. Thanks.

Look Like: PERIOD 2009/10/01 TO 2009/10/30 INV: 1234-5678-9 Grocery Sto Smart Shopping One Volume InStore Delivery, LOCAL 1,000 IS 1 Credit, local 6 IS 10 RETURNS, LOCAL 11 IS 0 GOVERNMENT 0 ADDTL Freight 0 IS 12 OutStore Delivery, LOCAL 121 IS 1 CREDITS, LOCAL 2 IS 6 RETURNS, LOCAL 3 IS 9 GOVERNMENT 2 ADDTL Freight 11 IS 0 Need it to look at: PERIOD 2009/10/01 TO 2009/10/30 INV: 1234-5678-9 Grocery Sto Smart Shopping One Volume Grocery Sto Smart Shopping One INV: 1234-5678-9 InStore Grocery Sto Smart Shopping One INV: 1234-5678-10 Delivery, LOCAL 1,000 Grocery Sto Smart Shopping One INV: 1234-5678-11 IS 1 Grocery Sto Smart Shopping One INV: 1234-5678-12 Credit, local 6 Grocery Sto Smart Shopping One INV: 1234-5678-13 IS 10 Grocery Sto Smart Shopping One INV: 1234-5678-14 RETURNS, LOCAL 11 Grocery Sto Smart Shopping One INV: 1234-5678-15 IS 0 Grocery Sto Smart Shopping One INV: 1234-5678-16 GOVERNMENT 0 Grocery Sto Smart Shopping One INV: 1234-5678-17 ADDTL Freight 0 Grocery Sto Smart Shopping One INV: 1234-5678-18 IS 12 Grocery Sto Smart Shopping One INV: 1234-5678-20 OutStore Grocery Sto Smart Shopping One INV: 1234-5678-21 Delivery, LOCAL 121 Grocery Sto Smart Shopping One INV: 1234-5678-22 IS 1 Grocery Sto Smart Shopping One INV: 1234-5678-23 CREDITS, LOCAL 2 Grocery Sto Smart Shopping One INV: 1234-5678-24 IS 6 Grocery Sto Smart Shopping One INV: 1234-5678-25 RETURNS, LOCAL 3 Grocery Sto Smart Shopping One INV: 1234-5678-26 IS 9 Grocery Sto Smart Shopping One INV: 1234-5678-27 GOVERNMENT 2 Grocery Sto Smart Shopping One INV: 1234-5678-28 ADDTL Freight 11 Grocery Sto Smart Shopping One INV: 1234-5678-29 IS 0

I'm exporting a tab delimited file, but I notice that Excel wraps quotes around fields that have a comma, and fields that have quotes.

Is there a way to prevent this and just get the raw data. The reason I'm using a tab delim file is because I want the commas in the fields, but it's much easier to import into my DB if I can prevent this "" wrapping, and just get a raw tab delim file.

Hi there guys
If I have a xpreadsheet how can I save as a csv file with each column enclosed in quotes?? I can save the file as a csv but the fields are not enclosed in double quotes like below.


Hi Everyone. I have a tab-delimited file that I open with Excel, make a few tweaks to, then save as a comma-delimited file. However, the export file has to use quotes as a text qualifier as well, and I can't seem to find an option to add the quotes automatically when saving as a CSV file. Does anyone know how to achieve this. I must admit it has been many years since I have used Lotus 1-2-3, but I seem to remember it being quite easy to do in that program.

Since quotes are used quite commonly as a text qualifier in a delimited file, I find it hard to believe that Excel would not support this feature, but I can't find it if it does.

I don't have to do this that often, but often enough that I would really like to find a solution that doesn't involve me opening the CSV file and manually adding the quotes where necessary.

Any help would be much appreciated.


We are using Excel 2003. When we export a spreadsheet as a text file, using
the "File/Save as" menu item, we don't get quotes around the fields.

Unfortunately, we need them, because our mass mailer won't accept the data
unless the quotes are present.

Where did they go? How do I get them back? TIA, all.

Hello, I'm new to the forum. I have searched Google and this forum as well but it seems I'm either not that smart or no one was able to figure this out. I'm a complete VBA newbie so I apologize in advance. Here is what I'm hoping someone intelligent can help me with, I know this definitely needs to be accomplished with VBA.

I have an external data source importing real time stock quotes and the connection refreshes every one minute. Ok so far pretty easy to follow. What I would like is the most recent quote on top and the previous quotes get pushed down below that one. This should happen after each one minute refresh. Hopefully that was clear. I would like a history of each minute so I can apply some analysis on the minute by minute data. I would also like the data to delete itself after it's say 300 cells old because we don't need a million cells of data to slow the file down. *Just want to note that the data will only update from this site during US market hours (9:30-16:00 EST)

I have attached the Excel 2007 file as an example. It has the data connection already setup with descriptions and examples of what I'm looking to accomplish. I know there are some people looking for the same thing as me so hopefully you could edit my file and re-upload it for anyone to use. Thank you so much to anyone that can help me out.

I am trying to get quotes around a phrase but cannot get the beginning quotes to work. i can get the end quote to work but that's it. Can someone help me out? Here is what I am working with. I need the quotes starting at the BTS and ending at the ",B3,"

=CONCATENATE("set interface ",F3," description BTS_",A3,"_",B3,"")

I have this file test.txt which has this kind of data. i-e columns with quotes.

When I open it using ms excel and modify a column
e.g "test" to "test-new"

and save it, the quotes disappears.

How do I keep the quotes intact after saving in MS excel file?


I had to have all my Excel 2010 file moved from a destop to a portable and now when I try to put the double quotes into formulas they do not come as " but rather as single quotes but not until I press the double quote and then they only show up as single quotes. Can somebody explain why the double quotes are gone as they are rather important to writing formulas.

Last year I modified a template used for calculating project costs for a government agency. The agency was running Excel 2003 at the time, and the file format was .xlt. Some time ago they migrated over to Exel 2007, and the same template that worked fine under 2003 is now misbehaving by prompting for a "smart card". The smart card is prompted for both in .xlt- and .xlsm formats. We have tested dummy templates in all formats, with and without stored macros, and they all work fine.

So, my question is, what strange properties of the particular template might prompt the request for a smart card?

I have a CSV file that contains data in columns A-Q. Some cells may be blank.

I'm having trouble opening this CSV file because when I re-save it after editing it, Excel removes any quotes that were around the data.

Here is the criteria that the data must be formatted like:

If the value in column A = "H", the following columns need quotes around the cell - A-F, H-I, K-M, P-Q. The values in the rest of the columns do not need quotes.
If the value in column A = "D", the following columns need quotes around the cell - A-D, F, I-O, Q. The values in the rest of the columns do not need quotes. Data is only in columns A-Q.

Can somebody write a macro that will format the data as list above and save?


Fellow Forum Members,
I have a Concatenation problem that is due to using quotes within quotes for labels. The two examples below provide a visual of the problem. The top code EXCEL likes. The bottom code EXCEL does not like because the number 1 is wrapped within quotes which conflicts with the quotes for the Label itself.



So my question to anyone out there is how do I get EXCEL to like the QUOTES around the number "1" ? I need to display the Label with quotes and EXCEL does not like it. Any work around will be greatly appreciated.


OK, I'm at a complete loss on this one.

I need to export a worksheet/range to a text file, that part I'm sure I can figure out, but the problem is I have to export it in the following format:

intitle:"text string"

Notice that the quotes are " and not "", when I try this, even with a straight copy and paste, all I can get is:

"intitle:"""text string"""

Ultimately the contents of the csv/txt file needs to be loaded into google, and extra quotes here and there will completely change the results I get.

Any ideas?

I don't know much coding but if I want to add quotes in first column and no quotes in second column what changes do I need to make in module listed below. I have tried few things but it doesn't seem to work. I will kee trying but any help you can provide will be appriciated.

Found this module in following post in this forum

Thanks in advance for your help

Please Login or Register  to view this content.

I'm running the following to put quotes around data in a workbook:


Sub test()
    For Each s In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
        s.Value = """" & Format(s.Value, "00000000") & """"
For Each s In Range("B1:B" & Cells(Rows.Count, 1).End(xlUp).Row)
        s.Value = """" & Format(s.Value, "####") & """"
End Sub

And exporting as a CSV file for loading into another program. The problem is everything looks OK in Excel, but when I open the file in Notepad to check the output, the quotes are all triple. How can I get only single quotes around the data?


I need to create a csv text file with the fields acutally delimited by commas and with quotes around each field. I am starting from an excel file and saving the file as a csv. But this approach leaves me with out the quotes.

So if I start with this in an excel csv
M Blended_Mix P P S FKINX S 30 28 32

And even though I saved this as a csv, it seems like it is really a tab delimited file. So that if I simply copies and pasted the above into a text file, the fields are separated with a tab.

What I need, though I need to end with this in a text file.

"M","Blended_Mix"," ","P","P"

I am using Excel 2010.

I'm sure this has been asked before and I did use the search but can't find anything. Now that we have excel 2010, is smart rounding now available?

What I mean by smart rounding is, for example:


3.3748 Sum

but if you round and sum then you get


3.37 Sum

I hope there is a way around to adjust 2.13 down to 2.12 so that the sum is 3.37.

Thanks in advance.