Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Csv File Format: Iso-8859-1 Charset ?

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

I am looking for information regarding how to save a file from Excel w/ these paramters:
CSV with the ISO-8859-1 Charset

Here is what my web developer wrote me-
Since you have some fancy quotes and other characters
in your descriptions, you need to save you CSV file that you export
from excel in the ISO-8859-1 Charset

When saving my file to the CSV file format, never have I seen this option before, nor can I locate it now.

Any info on this?



View Answers     

Similar Excel Tutorials

Easily Enter Fractions into Excel
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you ...
Export an Excel File to a CSV File
How to export an Excel file to a CSV file (comma separated values file). This allows you to turn any Excel spread ...
How to import Text Files (CSV) into Excel
Text files in CSV format are one of the easiest ways to store and transfer data as it is one of the most compatible ...
Display Numbers, Dates, & Times in the Correct Format in Excel
In this tutorial I am going to look at Number formatting. Number formatting allows you to change how numbers are di ...

Helpful Excel Macros

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
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
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Save the Current Worksheet as a New File in the Current Folder
- This Excel Macro saves the currently visible worksheet into the SAME folder as the current file. It is different from
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

Similar Topics

Hi everyone,

I 'd like to save a XLS file as CSV file. My XLS file is a polish file with polish charset and i want to keep this charset in the CSV file.

I use a computer with XP. The language used to install it is French. But i use polish language to open the files.

When i open the file i can read it properly without any change. After saving my XLS file as CSV file, i open it in my favorite text editor and i can see that some characters change.

I tryed to save the file with a unicode font, with a polish font and i have the same problem again.

i need help

Hi all,

I need to save data from XLS format as XML.
I need to keep all text formatting and foreign characters.
It all looks fine when opening exported XML file with Excel. However when it's opened in text editor all foreign chars are read incorrectly. I guess that's because Excel sets encoding for each cell separately.

Is there any way to save as XML file but using UTF-8 encoding?
Or export all foreign characters as HTML entities somehow?
Or last solution - can anyone explain how the separate encoding is stored? I found something like x:charset=238. Is this some track?


When you save a file from Excel as a Text (.txt) file, it uses the Tab character as the delimiter. Is there a way to save it with a comma delimeter and enclose non numeric fields in quotes. I am aware of the .csv option, but it doesn't enclose the field in quotes.

Here's my problem. I'm using Excel output to feed Access input. I have more than 100,000 records, so I'm forced to cut and paste two outputs from Excel into one big text file, which will be used as import file into Access. When I combine the two text files from my text editor, it remembers the tabs and Access rejects the imported file (saying not in expected format).

Its odd, because when you export a .txt file FROM Access, the data looks like:

"field one","field two"

But when you save a file as .txt in Excel, it looks like

field one[tab]field two

Any suggestions would be appreciated.


I am trying to use VBA to import data from an online web service into Excel (using winhttp).

The returned result is encoded in XML so I use Win XML to manage it. So far so good.

My problem is that the returned XML data (text) is encoded in ISO-8859-1 meaning I get weird things like "&" in the text. So my question is, how can I convert the encoded characters into plain text (UTF-8?) before I write it into the cells in excel?

The returned xml string has a header like this <?xml version="1.0" encoding="utf-16" standalone="yes"?>, one "bright" idea I had was to convert the "utf-16" into "ISO-8859-1" before passing it into "xml_doc.Loadxml (xmlString)" - but that did not help. Any ideas?


I have a sheet in Excel which I want to save as a UTF8 format text file. I previously thought it couldn't be done but I found the below and it definitely works in saving a text string as one:



'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut(cText As String, file As String) As Integer
On Error GoTo errHandler
Dim fsT, tFilePath As String

tFilePath = file + ".txt"

'Create Stream object
Set fsT = CreateObject("ADODB.Stream")

'Specify stream type – we want To save text/string data.
fsT.Type = 2

'Specify charset For the source text data.
fsT.Charset = "utf-8"

'Open the stream And write binary data To the object
fsT.writetext cText

'Save binary data To disk
fsT.SaveToFile tFilePath, 2

GoTo finish

MsgBox (Err.Description)
writeOut = 0
Exit Function

writeOut = 1
End Function

What I need to do is adapt the references to cText to save an entire named Excel worksheet in UTF8 format, instead of that single string of text. I would like to think this is quite straight forward, but my initial attempts haven't been successful.

Thank you greatly, as always, in advance.

I am trying to prompt the user to save an Excel 2007 file as an '03 file. Here is my code:

file_name = Application.GetSaveAsFilename(FileFilter:="Microsoft Excel file (*.xls), *.xls")
ActiveWorkbook.SaveAs Filename:=file_name
MsgBox "File Saved!"

However, when I close the file and then try to open the .xls file after running the macro, it says:

"The file you are trying to open, ... , is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source..." (Excel 07)

"This file is not in a recognizable format." (Excel 03)

It does look suspect when I run the macro, because when it asks me to save, it brings up the files name automatically with a .xlsm extension and quotes around the file name. How can I fix this so it will automatically save as an 03 file?

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.


Hi all,
I have managed to get to some extend with vba and internet explorer automation, but despite doing further research I am just not sure how do I go about clicking and image button to submit with ******* option. Please see below:


	 HTML Code:

<form name="form1" method="post" accept-charset="iso-8859-1" acceptcharset="iso-8859-1" ACTION="/JP" onSubmit="return LockPayButton()">
[b]<input type="hidden" name="submitOption" value="">[/b]
<input type="hidden" name="o" value="mpce">
<input type="hidden" name="p" value="mpcr">
<input type="hidden" name="motoId" value="0">
<input type="image" [b]*******="javascript:document.form1.submitOption.value='purchase'"[/b] src="aac.gif" border="0">

I am not particularly sure how do I go about manipulating this button to click. Any help is much appreciated. Thanks!!


J'ai le problème suivant.
En exécutant une fonction mathématique sur une cellule contenant un nombre,
que ce soit directement "=5+6" ou "=5*6" ou indirectement SOMME(C3:C7)
me renvoie un zéro. Les cellules n'ont pas de texte en guise de nombre (vérifié).

Avez vous une idée de l'option qui est incorrectement paramétrée ?


I need to save an excel spreadsheet with approximately 20 columns of info to a txt file. the problem is that i need the information in the file to be saved without tabs autmoatically being inserted into the text file. I need the information to run continuously.

for ex:
i have on my spreadsheet:
123 xyw text abc

i need it to be saved to a text file and when i open the text file the info must appear as

Is there any format i can save the sheet to to get these results or is there any other way around it?


Is it possible to restrict the file format options available to a user when saving an Excel file? I have an Excel file which needs to be filled in and saved as only a CSV file. Is there anyway I can force this option.

Thank You in Advance


In my excel file I have chinese and some other special characters and many cells have text with commas.

My problem starts when I try to save my file as a Text.
When I Save As with the Unicode option I can see the chinese characters in my text file but also I see a lot of quotes """ because I have commas in my xls file.
When I Save As with Tab Delimited option to solve the comma problem, the chinese characters become ????

It seems that cannot be possible to do it manually cause there is no option to Save As with Unicode and Tab option together.

So I would deeply appreciate someone could give me a solution with VBA code to save my file as Text with Unicode and Tab Delimited option.

thanks in advance for your kind help.

PS. I searched the forum but I haven't found a situation similar to mine.

I'm trying to use a macro to take a .txt file, re-format it and save as .xls. The .xls already exists and I want to copy over it. I also want to close the macro excel file, without saving, so that it can be reused. The code below appears to do just that, but when I try to open the newly created .xls file, I recieve the following prompt "This File you are trying to open, 'CompanyConvert.xls', is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now?". This is causing issues downstream. There has to be something screwy with how I'm saving this file. Thoughts?

Please Login or Register  to view this content.

Thanks in advance,


i am not sure why this is so complicated, what I am after seems so elementary. In any other software, when I save a copy, or export to a different format the original file remains unaffected but in an excel it seems to work differently...and I end up having to save my file back to the xslx format. this extra time wasted when I am regularly exporting but it also makes me a bit nervous that I might accidentally not save back to the format with all my worksheets etc etc...

is there a way to simply export?


I have a range of data which I'm trying to save into a comma separated .txt file. Excel only allows one to save to a comma separated .csv file. Unfortunately the program I am trying to upload to requires comma separated .txt file.

I tried save to .csv file then opening in wordpad and saving as .txt file but unfortunately this means some of the blank fields are lost.

Please see attached file where the range of data I wish to export to comma separated .csv file is cells B1 : CI36. Further column T (Date) needs to be saved to .txt file in text format ddmmyyyy (i.e.: no "/").

When opening the .txt file the first line of the attached file would read:
,PYMNT12MAY11,,01,,RIV001,,,,,,,56001811149035,,,GBP,8640,,12052011,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Is the best way to write a macro to export the data?

Kind regards,

I am having dificulty finding a way of saving a file in the format I need
for another application.
I have a file which has a number of fields enclosed in quotes and seperated
by commas. Some of these fields are text and some numeric though treated as
text, eg phone numbers. I can open the file with Excel, make changes I need
to but when it comes to saving I cannot figure out how to get the same
format again. It has to be comma seperated with each field in quotes and
carriage return at the end of a record.

Thanks for any help.


I think (hope) this is the proper place for this particular question. I have created a macro that does a lot of fancy things eventually opening a "Save As" window to save the results as a CSV text file. This should be a nice clean text file to be uploaded to a "LMS" Learning Management System (Blackboard). The catch is the instructor only uses a Macintosh (OS-X). When he attempts to upload the file the "LMS" says it isn't in the correct format. I think it's a CR/LF issue, because when I open the file in a pure text editor, I see a bunch of unprintable characters. Any suggestions as to how to export a nice clean (PC compatible) file from Excel Macintosh?


I am creating a comma delimited (text) file for upload to another
application. The file is a tab in Excel (2000). No matter what (.txt) file
format I select to save as, each line of the output file is in quotes (which
are not present in the excel source file. As a result, the upload
application doe not recognize the data.

Is there a way I can open an xlsx file and save it as a xlt file without playing around with the string I use to save the file. i.e. can you specifiy the file format when saving the file (using SaveAs) to xlt?


When i use the Pl/sql developer function 'copy to excel', it creates/opens
an excel file for me in the "c.\...\temp" directory".
Now when I am in this file and I use the file/open and file/save commands excel defaults to the "c.\...\temp" directory".

I was wondering if anyone knows how to change the path of the file/open file/save as commands.
I would like to be able to save the file right at the "c:\" directory.

I am using excel2000 and windowxp.
If you need any more info, just ask. I am not very computer literate.


I'm doing my file save like this:
ActiveWorkbook.SaveAs Filename:="C:\MyFile.txt"
and I get all kinds of stuff I don't want to see. It looks like Excel is saving my file as an xls that just happens to have a txt file extension. Can someone tell me (a VBA idiot) how to do this save in txt format?


Hello all,

I regulary receive from a client a data transfer file that I must open in Excel to edit and then save as a Tab-delimited file for importing into a database. If a field has a comma in it, such as

123 45th St., Apt. 18

then Excel saves the field in the Tab-delimited file as:

"123 45th St., Apt. 18" (surrounded by quotes) This causes my database import process to error out.

The source file is comma-delimited. We have tried using a pipe | delimited file, but the same error still occurs. For reasons beyond my control, the client cannot feasibly save the source data as a tab-delimited file. Help?

The current procedu

- The client sends me the file as a comma-delimited .txt file in the format
"M","Smith ","Mary","J"," ","19591106"...etc for several dozen more columns
- I open the file in Excel via the Text Import Wizard, with a comma as the delimiter and all fields set to Text value
- I make the necessary edits
- I save the file as type Text (Tab Delimited)
- I then open the newly saved Tab Delimited file in Notepad to verify that everything is correct. All fields export correctly EXCEPT for those that contain a comma. They are export in quotes "texthere" as shown above.

How can I work around this problem? I have tried everything and can find no feasible solution.

I am trying to created test data files. The data is currently in Excel and the widths of the columns have been set to that of the fields within a database. I want to save the Excel file so that the widths of the columns remain. I have tried saving as .prn and this works for some files however .prn is limited to 240 characters per line so any files which have more than this automatically wrap the columns. This is no good as when the file is read the columns are counted therefore the load gets confused.
I have tried saving as .csv and getting rid of the commas however this does not save the column widths.

How can I save the file so that the widths are saved to some sort of text file?
Other info - ultimately I need to change the file so that it is .dat and this is simple enough by changing the file extension.

Thanks in advance

This very basic excel file (no macros, no formulas) is saved on a network drive and is Shared.
It seems every other day or so, a message pops up when trying to open it that says, "The file is locked. To save changes to the file, you can either close the file before making any changes and open it again, use the Save As command to save the file with another name, or turn off Shared Workbooks and save the file."

The first option doesn't work, the second option works, but is a pain to do it every day, and when doing the third option, a message pops up that says, "Errors were detected while saving 'File Name'. Microsoft Office Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue."

When clicking Continue, it saves the file as a new name, but then comes up with the message, "No errors were detected in 'New File Name'. No repairs were necessary."

...then, when opening the New starts all over with the first message so we have to save it as a new file name then delete the old file, then change the name back to what the old one was......

.....Any ideas out there???