Free Microsoft Excel 2013 Quick Reference

export excel file as csv with text delimiter of "

Does anyone know how to export data from an .xls file to a csv, and encode
all text fields with double quotes > ""?
I can use "save as" to get a csv file, but then the text does not have
double quotes.
any ideas?


Does anyone know how to export data from an .xls file to a csv, and encode
all text fields with double quotes > ""?
I can use "save as" to get a csv file, but then the text does not have
double quotes.
any ideas?

Has anyone found a way of coercing Excel 2000 to export .csv files with
delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck"
not Mickey Mouse,Minnie Mouse,Donald Duck

Thanks

Caroline

--
CarolineP
------------------------------------------------------------------------
CarolineP's Profile: http://www.excelforum.com/member.php...o&userid=20007
View this thread: http://www.excelforum.com/showthread...hreadid=345941

I am new to this group, so have some patience with my stupidity regarding
Excel. I have read much about converting Excel files to other formats, but
can't seem to find the answer I'm looking for. ? - How (or is it possible)
to save an Excel data file as an ASCII text file without any delimiters at
all. I.E. I want my Excel data file to be represented as a pure text file
with rows to be continuous/contiguous data fields and the row ending with a
carriage return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

I am new to this group, so have some patience with my stupidity regarding
Excel. I have read much about converting Excel files to other formats, but
can't seem to find the answer I'm looking for. ? - How (or is it possible)
to save an Excel data file as an ASCII text file without any delimiters at
all. I.E. I want my Excel data file to be represented as a pure text file
with rows to be continuous/contiguous data fields and the row ending with a
carriage return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

I am using Excel 2007. I want to save the file as txt with delimiters of , and " and of course a CR.

I have tried every choice possible with Save As and when I open in notepad it only will put a tab between each field. Does anyone know how to change the delimiter to a , and a " ?

Thanks for any help.

I can't import into my other application without the proper delimiters.

I am using Office 2003 on Windows XP.

Saving an Excel file as an HTML works great - the only thing is, it doesn't
include the headers and footers in the spreadsheet.

Does anyone know how to include them when a file is "saved-as" an HTML? Or
is there an alternative solution other than "save-as" (within Excel)?

I need a VBA or VB-script solution. Can someone please post some example
code or otherwise enlighten me? Thanks much in advance for your assistance.

EXCEL: When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ? how i configure EXCEL to export as
FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';'
FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY '''
LINES TERMINATED BY 'n'

When I save as xxx.csv I have any choice over:

FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';'
FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY '''
LINES TERMINATED BY 'n'

???

can you export an excell spreadsheat or the data contained within as csv file? and if so how do you do that?????????????

Hanks

If somebody knows, please help me.
I really appreciate your help.

The previous programmer created an excel template file(.xlt) in lower version.

If we save this template file as [CSV (Comma delimited)(*.csv)] format in
(Excel 97-2003), the delimited comma will be until the last column that has
the data.

But if we save this template file as [CSV (Comma delimited)(*.csv)] format
in (Excel 2007), the delimited comma will be until the column at the end of
the sheet.

How can I do to be exactly the same as the lower versions (Excel 97-2003)
without changing the template file?(To be compactable with the older versions
of our product, we are not able to recreate the template and we want to use
the same template file.)

Please see the attached files.

http://www.4shared.com/file/32023208/2dc0346d/Data.html

Thanking you in advance,

Khayae
S'pore

i'm using the following script to save the excel file as tab delimited text.
although the file it produces and the manually saved file seems to be
similar they are slightly different when i compare them by fc.exe even their
sizes equal. i am using office 2002 English, there is an issue reported for
office 2000 in microsoft site but nothing about this one. is it really an
issue or what should i do to get the similar effect for programmatic save?

Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
'
' open file
'
objXL.Workbooks.Open("C:d.xls")
'objXL.Visible = true

'close workbook AFTER saving
objXL.DisplayAlerts = False 'disable the overwrite? prompt, JUST DO IT
objXL.ActiveWorkbook.SaveAs "C:d.txt", -4158
objXL.Workbooks.Close
objXL.DisplayAlerts = True 'reenable prompts

I need to generate a csv file that encloses every text field with a double
quote like this - "abc", "def","ghi", etc.
Currently, excel will do this ONLY with fields that contain a comma like
this - "word1, word2", def, ghi

Any help would be much appreciated!

How do I save and excel file as an .exp file, or as they requested an
ASCII: expanded comma delimited text (.exp)

Hi,
I am trying to edit a csv file in excel,
but after opening a csv file in excel and saving it as a new csv file (without editing),
certain spaces disappear.
for example:

The original CSV file contains:
20, 201, , , , , , 120," ,0, 1,10

After save as csv in Excel:
20,201, , , , , ,120,""" ",0,1,10

In the above example the space before the number 20 doesn't exist,
also the spaces before the number 201..
Please help me with this.
Thanks

It is possible to save an excel file as csv or tabbed; but how to save an excel file as text file with | separator

I am having a problem doing the following:

Save a mobile telephone number in a spreadsheet
Cell is formatted as text so the zero appears ie 0423 176 323

Then save as CSV. Close the CSV and then reopen and the 0 disappears.

I have tried using Excel 2000 and Excel 2003 and both doing the same thing.

Does anyone know how I can get the CSV file to retain the leading zero?

Cheers!

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 everybody, i have a good deal 4 U which is driving me crazy!!! I have to save a xls file in csv format, but i need to use ";" as separators instead of ",". I use the ActiveWorkbook.SaveAs method. I found that I can set the list separator properly in the regional settings. The crazy thing is that if i do it via menu, by hand, it is ok. If i use VBA that does NOT work, I got commas!!!
I register a macro doing that: when i register it, it works; when i run, it does not!!! I can't believe I can't save in the ****ed desired format... I am using NT 4 with SP6, and Office 97.
Thank you everybody in advance

Hi,

I am trying to create a macro which saves an XLS file as a CSV file.

The file name needs to be made up of cells E2, B2, and F2 with no gaps and saved to say the desktop.

Is this possible?

Also before the save I need all data held in columns DA and DB to be deleted.

I have absolutely no idea where to start, can anyone help?

Thanks

I believe this is a bug in Excel 2003. I get an error when saving as
CSV with VBA password protection turned on. If I turn off password
protection, the same code runs without error.

To reproduce the problem...

1. Open a new Excel file.
2. Type "Test" in Sheet1 cell A1
3. using Excel's Control Toolbox toolbar, draw a button on the
worksheet
4. right click on the button and select "view code"
5. enter the following line of code in the button click event (be sure
to enter a path that exists on your system -- I used "c:temp" which
did exist on my system):
ThisWorkbook.SaveAs "c:temptest.csv", xlCSVWindows
6. save your Excel file
7. click the button and observe that the VBA code runs without error
8. close the CSV file that you saved in step 7
9. re-open your Excel file that you saved in step 6
10. open the Visual Basic editor and select ToolsVBAProject Properties
from the menu
11. click the Protection tab, check the "Lock project for viewing"
checkbox, enter a password and click OK (this protects your VBA code).
12. close the Excel file
13. re-open the Excel file
14. click on the button you added in step 3 and notice the error.
"Run-time error '1004':
Method 'SaveAs' of object '_Workbook' failed
15. open the Visual Basic editor and attempt to view your code
16. when prompted for your password, enter it
17. click on the button you added in step 3 notice now the code runs
without error.

So it's clear that the same code runs fine when VBA password protection
is turned on or the password has been entered, or produces an error
when VBA password protection is turned off or the password has been
entered.

Any ideas how to correct this issue or work around it?

Thanks!

I know that Excel allows me to save my file as an HTML file. I have a spreadsheet with data pulled from MS Query (datawarehouse tables). In cell A1 I have a parameter input value where the user can input the value and the query will refresh automatically pulling the correct data.

Is it possible to save the file as HTML, then for cell A1 to still be an variable user input value, and the data to update on the page? I know it's possibly using tools like SQL Server, etc, but I'm hoping to create reports that I can publish to our intranet website that users can use, plus by me creating these it's much faster than submitting a request to our programmers as they are backed up with so many requests as it is.

I've tried publishing the Excel file to HTML and I see the data, but that's it - I can only see the hard-coded data and it's not a dynamic report any more.

I have got a Spreadsheet that has 2310 entries down Column A. I need to run something that will split it into groups of 100 and export it to separate .csvs or text files. Can anyone help please before I lose all of my hair.

I believe this is a bug in Excel 2003. I get an error when saving as
CSV with VBA password protection turned on. If I turn off password
protection, the same code runs without error.

To reproduce the problem...

1. Open a new Excel file.
2. Type "Test" in Sheet1 cell A1
3. using Excel's Control Toolbox toolbar, draw a button on the
worksheet
4. right click on the button and select "view code"
5. enter the following line of code in the button click event (be sure
to enter a path that exists on your system -- I used "c:temp" which
did exist on my system):
ThisWorkbook.SaveAs "c:temptest.csv", xlCSVWindows
6. save your Excel file
7. click the button and observe that the VBA code runs without error
8. close the CSV file that you saved in step 7
9. re-open your Excel file that you saved in step 6
10. open the Visual Basic editor and select ToolsVBAProject Properties
from the menu
11. click the Protection tab, check the "Lock project for viewing"
checkbox, enter a password and click OK (this protects your VBA code).
12. close the Excel file
13. re-open the Excel file
14. click on the button you added in step 3 and notice the error.
"Run-time error '1004':
Method 'SaveAs' of object '_Workbook' failed
15. open the Visual Basic editor and attempt to view your code
16. when prompted for your password, enter it
17. click on the button you added in step 3 notice now the code runs
without error.

So it's clear that the same code runs fine when VBA password protection
is turned on or the password has been entered, or produces an error
when VBA password protection is turned off or the password has been
entered.

Any ideas how to correct this issue or work around it?

Thanks!

Hi there,

I searched through alot of threads about converting excel files to .csv but found they were all doing something a bit more complex than I need.

All I want is a Macro that will save the file as .csv, with the same filename and location as the original (just in csv format). A hotkey would be quite handy for this.

I tried using the macro recorder and fiddled around with the code a bit but my programming knowledge is quite limited and I ended up with something that doesn't quite work as i'd like.

I'm sure this would only take a few seconds to code for an experienced user, which is why I post here.

I would post my attempt at doing it myself but i'm on a computer that doesn't have excel at the moment.

Thanks in advance for your help,
Rob

I need to convert an excel file to a flat text file with no decimals, commas,
slashes or dashes