ZSC 0 Posted July 19, 2022 Share Posted July 19, 2022 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? Link to comment
Level 5 PinkElephant 8,780 Posted July 19, 2022 Level 5 Share Posted July 19, 2022 No, no The only way would be to use legacy desktop, and write a script that performs the action you want. Link to comment
Mike P 2,966 Posted July 19, 2022 Share Posted July 19, 2022 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. Link to comment
Level 5* DTLow 5,744 Posted July 19, 2022 Level 5* Share Posted July 19, 2022 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 2 Link to comment
karlos1234 16 Posted September 26, 2022 Share Posted September 26, 2022 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 1 Link to comment
Jon/t 1,654 Posted September 26, 2022 Share Posted September 26, 2022 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 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now