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 ...
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 ...
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 ...
Remove Table Format in Excel
Convert a table back into a regular set of cells.  This removes any automated table features and I'll show you how ...
Remove Gridlines from Only Part of a Worksheet in Excel
How to remove gridlines from a part of a worksheet in Excel instead of the entire worksheet or workbook. This is i ...
Make Y Axis Start at 0 in Charts in Excel
How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue. Select the Chart and go to ...

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


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 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 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.

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?


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???

I have been trying to determine the format Excel 2002 uses when you save a file there as unicode (I am on XP). When selecting save as "unicode," is it saving in UTF-8 format or UTF-16 format? I have been told I must provide a unicode file in UTF-8 for use by another program.
Any guidance provided would be appreciated.

Hi all,

I have been searching all over to resolve this problem and cannot find any help.

I have creates an Excel Object in VFP to access a Excel file but VFP dose only reads Excel 5.0 format. So I then save the excel file to the new format.

This works well I get a popup which the user has to select "No" for the Excel to save in the required format.

This is the message:
Saving this workbook's VBA project in Excel 5.0/95 file format requires a component that is not currently installed. Do you want to save in the latest Excel format? ...etc

As I said, the answer will be "No" but what parameter would I use to do this.


x=GETFILE("xlsm","Select Agent excel file","Select")



oExcel.WorkBooks(1).SaveAs(NewXLS,39) &&& Save the excel file in a Microsoft Excel 5.0/95 Workbook format

Thanks very much for your help in advance.

I have a file in .xlsm format that I have emailed to several recipients. A few people get the error "Excel cannot open the file "filename.xlsm" because the fie format or file extension is not valid".

Most of the recipients can open the file, and so can I, so I know it's not corrupt.

I have tried saving as .xlsb and .xlsx and they can't open either of those files either.

I can't save it as an .xls extension (which has worked int he past) because this file uses too many developer tools, macros, hyperlinks, and conditional formatting, which are incompatible with the .xls format.

I have tried placing the file on a shared drive and they are not able to open that either. So I know it's not an email issue.

Also, they have sent me a screenshot of the error message, and it is clear they are using Excel 2007.

How can I fix/alter/whatever the file so it can be opened by everyone?

I've been working in an excel file and saving periodically and I input new information. Now, when I try to save, I receive an error "Errors were detected while saving c:/user........
Microsoft excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click continue. To cancel saving, click cancel.

I did the continue, I entered the file name, and it comes back document not saved. This is when I try to replace the existing file OR when I try to save the file in a different location or as a new file in a different location.

I am using sparklines in the spreedsheet but don't know if that matters. Any help would be great.

I have a macro that automates the saving of a master file with a new version with today's date.

Sub SaveFileAs()

Dim file As String

file = "ClientData_" & Format(Now, "ddmmmyy") & ".xls"
ActiveWorkbook.SaveAs file

End Sub

If there is already an existing file I get the standard Windows warning asking if I want to overwrite the existing file - which is great.

However ....

If a file with the same name is already open the macro comes up with a Run-time error '1004'

"You cannot save this workbook with the same name as another open workbook or add-in. Choose a different name etc."

Apart from the confusion caused to the user seeing the macro error message. As this also means that the master file is still open with all the changes - which risks being overwritten (if the user clicks to save this file). Is there a way of the file being saved with an alternative filename e.g. Version1 etc - if another copy of the file is already open?

The other option would be if there was a macro that checked for a file already being open with the same name and if so asked them to close it, before they clicked the final save file macro.

Many thanks for any assistance provided - thanks

For some reason my .xla add-in file containing forms and code (saved as an .xla when created) has now saved itself as a .xls file. I cannot open it as a .xls file via Excel and re-convert to a .xla file format and I cannot save it as a .xla in the VB editor. I cannot seem to change the file extension to .xla in explorer either... Anyone know why this is happening and how I can get it back to an .xla file format?

When I make changes to the .CSV file and save, it show some alert message and changes the format by adding additional commas to the data.( This I can find out by opening the .csv file in notepad. How can I prevent this happening and save the .CSV in the same format after making the changes.

Thanks in advance


In a custom application of Excel 2003, I wish to use a special file
format. It's based on XML, but too complicated for Excel's native XML
support. The idea is to open files of this kind in Excel, make use of
Excel's nice editing capabilities, and then save back into the same format.

The ideal would be to add this file format to the others in the Open and
Save As dialogs, but I'm not sure if this is possible. Next best would
be to add two special menu items for import and export on the File menu,
or on a custom menu.

In short, my question is: can I add my file format to the others in the
Open and Save As dialogs?



At times i get this error message on excel when i am saving any file.

1. Error were detected while saving c:\.... 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. To Cancel Saving the file, click cancel...

2. Click Continue.. it gives another message " Excel encountered errors during save. However excel was able to minimally save your file to c:\ path.. file.xlsb.

3. Clikc ok and get a message in a box "Damage to the file was so extensive that repairs were not possible. Excel attempted to save your formulas and values, but some data may have been lost or corrupted."

But it does not save even if i change the file name.. Im not sure why this is happening on an irregular basis whatever the size of file.. the only formula that i have in that spread sheet is Sumifs and sum...

Can anyone help or seen such similar problem n has been able to rectify.



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.


How do I export a range of cells in a column as tab-delimited into a text file?

Of course, I am aware that the File > Save As... has an option to save the entire file into a tab-delimited text file.
But, that's not what I need to do.

I have a list of people's names and email addresses, among others, in an Excel file.
One column contains the email addresses. I want to export these email addresses as tab-delimited into a text file.

I appreciate any suggestion from members.

I have a file that I save in xlText
The problem is that the file loose the data format from 01/01/2008 to 1/1/2008

When I save the same file not in the macro I have a questions

one is about " the file format contain features that are not compatible ....
to keep this format .....
to preserve ....
to see ....

and then I choose yes no or help
Whe I save the file I choose yes but the macro don't! so i loose the data foemat

How to answer yes to that box ?

Thank you

Hi Everyone...

I have found some posts about "Auto Saving" and Dave pretty much frowns upon that. But the program I use (via ODBC), for some reason doesn't see the changes I make unless the file is saved. I have it auto-saving right now, but was thinking, maybe it is better to export a copy.

Is that possible? I guess using the Save-Copy function?

What I would need, is the ability to take my current workbook and export it to a new file (overwriting that same file each time), and do this based on time or (even better) on a change in the data. My current workbook is set to pull from other CSV files, scraping our website, etc., and then I use Excel to format the data the way I want.

It would be cool, if I could export two versions each time too... one that would be like a archive of what the file was like when it changed, the other would be the one that just gets overwritten each time.

Love this site...tons of info...but dang am I not smart at this stuff. Half the time, I don't even get where to put the code...worksheet, module, workbook?

Anyway, happy holidays all you Ozgrid'ers!


I have a workbook that is used in a mixed Excel 2002, 2003, 2007 and probably 2010 environment. About a month ago, all the VBA code 'disappeared' from the workbook. I presume that one of the users with 2007 did a 'save as' and accepted the default .xlsx format and then later on a 2003 user saved it back to .xls format since that was the extension when I was called about the problem.

I need a way to force the workbook to be saved only as .xls (format 56). I have some questions about this:

I would like to allow all users to be able to save, not 'save as' the file as they work on it in case some disaster happens. If a 2007 or 2010 user opens an .xls file (format 56), and saves it, is the file saved with it's original file format (.xls), or as a file of the default file format of 2007/2010 ? I think that the answer is .xls.

I would like to allow certain users password protected access to 'save as' across all platforms. What is the best way to accomplish this ? I was thinking that I could put password prompting/checking code in Workbook.BeforeSave and check that SaveAsUI is true and be done but I am not sure that this would be sufficient. Any ideas about this ?

Lastly, I am not sure about how to use Application.DefaultSaveFormat. I have played around with this by putting this in the beginning of my code, but when I go to 'save as' the suggested default format is not the one that I specified with Application.DefaultSaveFormat. Does Application.DefaultSaveFormat only apply to 'save' and not 'save as' since the user can always override the suggested format in 'save as' ?

I am not proud. If anyone knows of code that will accomplish what I want, i.e force the saving of a workbook with a certain format, please point me in that direction.


I have one user in the office when they save there excel document it creates
a *.tmp file in the current file folder.

Now I checked - Select Tools|General Option and put a check against the
Always Create Backup box before you save the file. But that is not it.

The file created is something like this. dhti4345$0buget200243~.tmp

IF anyone could help that would be greatly appreciated.

I also looked into editing the registry and increasing the cache size but I
would prefer not to do that.

thanks again

Is it possible to attach files?

I need to export specific cells from a row in a specific format into a notepad file and then save it as nameoffile.uai

Each row is a different entry in the notepad file.

All details are attached, with a further explanation.

The format.uai file gives an example of the format in which the export is to be made in.

Im very unfamiliar with VB so all i can really do is copy and paste code.

Any help at all would be appreciated.


This morning we started having problems with an Excel file. It can be opened and edited, but when we go to save it it says the file is already in use and to try again later. I know for a fact no one is opening the file, so no physical user here is opening the file. Is it possible the file is being tagged by Windows or Excel as already being opened and not alowing me to save the file even though the only session using the file is me? This is Excel 2007, any help is appreciated!!

I am using a web based trade application to export to a CSV file. When I click export and save as, I enter the file name. When I open Excel I can't see the file. I re-open the trade app, hit save-as and the file is there. I click over write, reopen excel and it is still not there. I have tried to search for the file and it can't be found. I have verified there are no hidden files and that it was saved with csv extension.
Any suggestions.

I'm running Excel 2007 on a WinXP (SP2) machine (dual core, 4GB RAM, 8GB free HDD space).

I keep getting a strange error message frequently when I try to save large files (> 2MB) with lots of sheets. Excel seems to save okay (the save progress bar at the bottom finishes), but then a dialog box pops up saying:

Your change could not be saved to filename.xls because of a sharing violation. Trying saving to a different file.

Once I hit Ok on that dialog box, it immediately gives another dialog:

The file you are trying to open, '56C2F10', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? Y/N

I hit Yes, and it then opens another version of the same file and gives me the Save As... dialog box. Once I enter a different name, it saves that file and closes it, leaving me with the original file that I was trying to save (but could not). I then close that original file and open the new/renamed file and it contains all my changes.

As I mentioned, this happens usually with large files (>2MB), usually ones which have many sheets (>10). It has happened with .xls, .xlsx, and .xlsm formats. I am saving only to my local hard drive, and the file is not shared with/on any other user/server/machine.

It is very annoying, since I have to interrupt my work to close the "corrupted" file and open the newly renamed one, not to mention that I end up with multiple copies of the files.

Any insight as to what's causing this problem, and how to fix it?