Import CSV file to Evernote

[ZSC 0]

Hello,

Does anyone know how to import csv / excel file to evernote? Import as in creating new notes for every row in the excel / csv.

If not, does anyone know of a tool to convert csv / excel to enex file?

[PinkElephant 8,076]

No, no

The only way would be to use legacy desktop, and write a script that performs the action you want.

[Mike P 2,625]

8 hours ago, ZSC said:

Does anyone know how to import csv / excel file to evernote? Import as in creating new notes for every row in the excel / csv.

The approach I would take personally is to do the scripting outside of EN. You could quite easily create a text file for each row and then save those to your import folder. Text files appear inline  within a note. However they are not editable within EN so you have to either copy and paste the text into the body of the note or edit the file in a text editor. 

Alternatively enex is just a fancy text file (well XML really) so would not be difficult to create with inputs from the csv file. Sorry, can't think of an off the shelf solution.

[DTLow 5,736]

14 hours ago, ZSC said:

Import as in creating new notes for every row in the excel / csv.

My solution is applescript on a Mac   
I process monthly csv transaction files from the bank , creating individual notes   
   
Using Evernote Legacy, I can directly create notes in Evernote   
With the v10 product, I would create text files in the import folder   

>does anyone know of a tool to convert csv / excel to enex file?  

I could probably figure out the coding for an enex file   
It would be an improvement over the text as an attachment file that v10 imports

[karlos1234 15]

I think the best thing would be to just create a .enex file as you noted. You could steal some ideas and code from here, which is a tool I wrote that converts markdown files to .enex. You'd just modify this to read each line of the CSV file, and then populate title, note content, dates, tags, etc accordingly.
https://github.com/karloskalcium/md2enex

[Jon/t 1,275]

Another possible solution would be to upload the CSV to Google Drive/Sheets and write a small script to go through each line and export as a text file. Then import into Evernote. Maybe use an Import Folder.

https://stackoverflow.com/questions/32993527/google-spreadsheet-convert-rows-to-text-files