EDIT .CSV file and SAVE as .CSV file

Vijay Babu

Hi there

We are working on an .CSV file which has got spl. characters,so we need to correct the data in file and again save it back to .CSV, could not see .csv file format in drop down.

can someone please help on this?? so that i can save the file back to CSV.

Thanks in Advance!

Thanks & regards
Vijay

Claudia Frank

@Vijay-Babu

if you opened it as csv - just press save - done.

Cheers
Claudia

Vijay Babu

Hi Claudia

Yeah i open it as csv,but when i edit and save the file it prompts a popup with message " file will change the original format" - click yes/no.i have clicked yes unfortunately for unknown reasons still content in file is messed up/format is changed.

Hence we can around Notepad++ ,but here cant see the option to save the file as CSV.

Thanks
Vijay

Claudia Frank

@Vijay-Babu

could you please provide the debug info?
Available via menu ?->debug-info

Cheers
Claudia

Vijay Babu

Could not locate this,can you please confirm where this path is ?? is it in Notepad++ or MSExcel.

Thanks
Vijay

Claudia Frank

Hi Vijay,

see screenshot

Cheers
Claudia

Vijay Babu

Hi Claudia

Thanks for the revert.Please refer below details.

Notepad++ v7.2 (64-bit)
Build time : Nov 2 2016 - 11:27:56
Path : C:\Program Files\Notepad++\notepad++.exe
Admin mode : OFF
Local Conf mode : OFF
OS : Windows 10
Plugins : mimeTools.dll NppConverter.dll

Thanks
Vijay

Claudia Frank

Hi Vijay,

I’m confused because I thought it might be related to one of the 3rd party plugins you’ve installed
but you haven’t installed any.
So if the file is really a csv I don’t see why it shouldn’t work.
Could it be that you renamed a xlsx or any other excel format to csv instead of exporting it?
Could you do me a favor and make a screenshot with this message?
Maybe upload to imgur.com, it’s free - no registration needed.

Cheers
Claudia

Vijay Babu

Hi Claudia

Appreciate your Quick turnaround.
i am just trying to understand which screen shot do you need?
is it Procedure 1: Open Original CSV file–> make required changes–>Save.
2: Open CSV File in Notepad++ --> Edit required chhanges --> Save AS?

And answer for below Q is
Could it be that you renamed a xlsx or any other excel format to csv instead of exporting it?
ANS: i am working on Orignal file only its a file that is converted from XLSX to CSV

Thanks again for the support.

Thanks
Vijay

Claudia Frank

Hi Vijay,

I was looking for a screenshot with the popup message “file will change…”
It doesn’t matter if you use file-save or file-saveas - as long as it shows this popup.

Cheers
Claudia

Vijay Babu

Hi Claudia

how do i attach snaps here.imgur does not work.
it shows up blank screen.

Thanks!
Vijay

Claudia Frank

Hi Vijay,

you can only embed links to images.
The syntax is

![](www.whatever.my_image.png)

If imgur doesn’t work for you maybe you can use another image hoster.
I have to leave now, so I can’t respond for the next 8-10 hours.

Cheers
Claudia

Vijay Babu

Hi Claudia

Sorry could not understand this syntax,how ever i am typing below the text in popup on saving the excel.
…
Some features in your workbook might be lost if you save it as CSV(Comma delimited).
Do you want keep using this format?

YES NO HELP (Buttons)
…
Hope this helps.
Thanks in Advance!

Thanks
Vijay

AdrianHHH

The message “Some features in your workbook might be lost if you save it as CSV(Comma delimited)” is produced by Excel, not by Notepad++. You appear to be editing your CSV in Excel and then trying to save it.

Find the CSV file in Windows Explorer. Use the context (right click) menu and select “Edit with Notepad++”. Then you can edit and save the file.

Look at the top of the screenshot that Claudia posted. Note that it includes the text “Notepad++”.

Claudia Frank

Hi Vijay,

that’s what i feared.
As AdrianHHH already pointed out (btw. thanks for jumping in) Excel is producing
this message. The reason is simple, when you have a normal Excel file the file
contants formatting informations as well as the text which you see in Excel.
When converting this format to csv all the formatting stuff gets deleted because
a csv is a plain text file format.
So you have to decide either using the Excel format, but then you cannot
edit it by notepad++ safely or converting to csv and loosing all formatted stuff.

Cheers
Claudia