Convert Excel Spreadsheet to TXT files or compatible for Evernote

Hi All,

I have a CSV files, converted to XLSX, which I would like to separate into notes for Evernote. I managed to extract this info from a Samsung Memo app and want to now reconvert the contents for Evernote.

Basically the content are like this:

Date	Note Content
YYYYMMDD	Blah Blah Blah

It would be great if I could preserve the dates of the notes, but whatever's easiest is fine – not vital information. I have searched the net, but I find a lot off Macros and scripts – which I don't even faintly understand. Since I have no further use for learning these techniques, I was wondering if someone would be so kind as to suggest a way of doing this?

So the end result is that I have my 96 cells separated into (text?) files in a (zip?) folder, which I understand is best for Evernote.

Please and thank you!

Sounds relatively straight forward - Please can you clarify what the text files should be called? Can the name be the date - or do you have more than one item per date? Should the name just be 1 through to 96?

What information should be in the text file just the

note content

or

Date , Note content

Ta
Bren

Hi, Thanks for replying, Bren!

Each cell in the column titled 'content' is an individual note. For simplicity, the title could be the date from the other column, or it could be blank if easier. Ideally, as I say, it would be great if Evernote could 'read' and save the date from Column A, but I wouldn't want to put you out, as I honestly have no idea what Evernote's requirements are.

Here is a screenshot to clarify:

http://i.imgur.com/EH1eUy6.png

Mega thanks. Seems to be doing something. Will be back if I get stuck (and anyway to offer huge praise).

This version just does the comment and ignores the date


Text File Creator no date.xlsm

Hi! Seems to have largely worked – great work – very grateful!

Would it be possible to not include 'Date\' at front of filename?

For some reason it outputs 87 txt files – I don't know why this would be? Also it outputs it at one directory higher than the xls file you gave me (odd, but no real problem).

Text File Creator no date file name is number.xlsm

This one just names the file 1, 2 , 3 etc etc.

I guess you got 87 before because the same date appeared several times and it over typed so you only got 1 file for that date. No problem with this version.

Hi...

Thanks so much for taking the time to do this. Added rep for you earlier.

You saved me hours of headaches. Used a file renamer to change the file names to just the numbers.