All notes -> export to CSV problem

MDeen · Post by **MDeen** » Wed Oct 16, 2002 10:09 am

When you export a list of all your notes to CSV, you get a list, comma separated, but with no line breaks. Is this how it should be ?

Maybe a bit off topic, but how do you get this data in excel? When I save it to exportbills.csv and then open it in excel, it takes all the data in one cell and does not look at the ';' character.
The only solution I found up to now was to paste it in word, replace all ';' with tab and enter linebreaks and then paste it in excel.

Am I being silly here and is there an easier solution?

(oh, all in office 2000)

Maarten

brunorodrigues · Post by **brunorodrigues** » Wed Oct 16, 2002 1:44 pm

it works for me... export the file, rename it to something.csv and just open in excel (somehow, excel is already the preferred application for csv files)

MDeen · Post by **MDeen** » Wed Oct 16, 2002 2:37 pm

Damn, my bad. I saved it with html headers and all. After I saved it as a text file it works like a charm.

Maarten

nanda · Post by **nanda** » Thu Oct 17, 2002 12:00 am

If you select all de notes in EBT, do a copt (menu edit copy) and open a empty excel worksheet and do EDIT PASTE..result..

I have allmy notes in excel

MDeen · Post by **MDeen** » Thu Oct 17, 2002 8:49 am

nanda wrote:If you select all de notes in EBT, do a copt (menu edit copy) and open a empty excel worksheet and do EDIT PASTE..result..

No, that does not work with me. Excel then puts everything in one cell.

ag_pt · Post by **ag_pt** » Thu Oct 17, 2002 12:31 pm

I also have a problem with CSV files, due to spaces in note comments.
To get rid of this problem I have to do like this:

1. rigth-click the link "export to CSV file"
2. choose "save target as" and give a name to the file being saved, extension CSV
3. open the file with a word processor like wordpad
4. replace spaces with _ (underscores) and save the file
5. open with Excel

Debtam · Post by **Debtam** » Fri Oct 18, 2002 7:48 pm

ag_pt wrote:I also have a problem with CSV files, due to spaces in note comments.
To get rid of this problem I have to do like this:

1. rigth-click the link "export to CSV file"
2. choose "save target as" and give a name to the file being saved, extension CSV
3. open the file with a word processor like wordpad
4. replace spaces with _ (underscores) and save the file
5. open with Excel

Thanks

emmem · Post by **emmem** » Fri Oct 18, 2002 8:37 pm

Something that might help too is to change your list separator in your regional settings to ;

To do this take Start , then Configuration , then regional settings, the numbers tab, and normally the list separator should be the last field.

exxodus · Post by **exxodus** » Wed Oct 30, 2002 8:56 am

MDeen wrote:No, that does not work with me. Excel then puts everything in one cell.

Do not copy & paste .. just do "view source" then save this result to a xxx.csv file.