edit csv files with excel

Microsoft Excel 2003 (full product)
June 8, 2010 at 04:43:20
Specs: Windows XP
When I export data from a database program to a csv. file, I get an 'excel' version of the same. When I open this file with a text editor such as Notepad, every field item is enclosed in double 'quotation' marks. If I make changes to any of the data in the csv. file and then save it, when I open it again in Notepad, all the 'quotation' marks have disappeared and I cannot then import the changed csv. file back into my database program......please help !!

See More: edit csv files with excel

Report •


#1
June 8, 2010 at 05:00:05
Have you tried editing them using Excel (or OpenOffice if you
haven't got M$Office), rather than notepad? this should retaining
any formatting - I'd have thought that notepad is too basic for
what you want.

"I've always been mad, I know I've been mad, like the most of us..."


Report •

#2
June 8, 2010 at 05:19:54
Sorry, I'll try to explain a bit more. I am exporting 'Supplier Costs' from an Accounting / Ordering program so that I can update the prices using Excel and then import them back into the Accounting Program. When I make changes to the csv. file using Excel and save the changes, it seems to change the format of the data in the csv. file. I only use Notepad to see how the data looks. As I mentioned before, after I have edited the csv. file using Excel and look at it again using Notebook, all the 'quotation marks' enclosing the the data in the exported file have disappeared, and I cannot import the file back into the original program. Is there some way of editing the csv. file data without changing the way it is 'formatted ???

Report •

#3
June 8, 2010 at 06:08:33
Some questions un-answered:
• Do you "open" the .csv file in Excel, or do you import the data?
• How do you the "save" the file in Excel? (what format)
• How do you "import" the saved Excel version into your Accounting/Ordering program?
• Does your Accounting program have more than one format it can import? (Tab-delimited, Comma-delimited, .dbf, etc).
• Can you perhaps mention what Accounting program you use?

Report •

Related Solutions

#4
June 8, 2010 at 22:50:19
You would get better help here:

http://www.computing.net/forum/offi...

.


Report •

#5
June 9, 2010 at 06:35:47
Thanks guys, but I got it sorted. The problem (if anybody is interested) is that when you use excel to edit csv files it tries to 'help' you by removing extra 'spaces', preceding & post '0's embedded in the data. This 'confuses' things when you want to re - import the data back into the program you exported it from. The fix is to copy / paste special - values from the csv into an xls. workbook. You then insert a new worksheet into that workbook and set up 'link' formulas to the first worksheet i.e...=TEXT(Sheet!1A1," 000.000")... or similar. This allows you to insert / remove any 'spaces', preceding & post '0's that have been removed. If you then do a copy / paste special - values from this sheet back into the original csv sheet, everything is sweet to import back into your original program.
Thanks.

Report •


Ask Question