buschihh 0 Posted July 19, 2011 Posted July 19, 2011 Hi folks,I haven't found anything about this in the forum.I have a excel file with I use as a project data base. I now would like to import this data base into a notebook (each single row as single note).Question: 1. how can I open a Evernote xml (*.enex) export file? MS Excel doesn't work.2. how can I edit the *.enex file (or even better to reformate the Excel file) with my data and import it into a new Evernote notebook?Thanks for your help.Buschi from Germany
Level 5* jefito 5,598 Posted July 19, 2011 Level 5* Posted July 19, 2011 Please refer to the Evernote API Overview for a description of the ENML format used in .enex files: https://www.evernote.com/about/developer/api/evernote-api.htm
inkedmn 8 Posted July 19, 2011 Posted July 19, 2011 You'll need to open the .enex file using some type of plain text editor (TextEdit will work, as will TextMate, MacVim, BBEdit and others). As far as formatting your Excel data, you won't be able to modify the data within the .enex file; when you add a binary file (a non-text-based file, in other words) to Evernote and export that note, the file is written as a byte sequence within the XML file. If you want to bring your Excel data into the body of an Evernote note such that the data is then editable within Evernote, you're probably going to have to key the data in by hand (which may be time-prohibitive, depending upon how much data we're talking about). I just tried copying/pasting from Excel to Evernote and it didn't really work very well.Good luck - sorry I couldn't be of more help!
fcroteau 1 Posted August 23, 2011 Posted August 23, 2011 I have the same need. I would like to import an excel file (about 1000 lines) into evernote. Each line would become a new note into evernote. I read on a forum somewhere that an evernote employe wrote a macro to do this, Is this true????? May I get this macro???? If not... Is there a way to do what I want to do without having to do it by hand, one by one... Thanks
Level 5* jefito 5,598 Posted August 23, 2011 Level 5* Posted August 23, 2011 Searching the forum for "import excel macro", I found this page: http://forum.evernote.com/phpbb/viewtopic.php?f=37&t=8953&p=34439&hilit=excel+import+macro#p34439
Idea
buschihh 0
Hi folks,
I haven't found anything about this in the forum.
I have a excel file with I use as a project data base. I now would like to import this data base into a notebook (each single row as single note).
Question:
1. how can I open a Evernote xml (*.enex) export file? MS Excel doesn't work.
2. how can I edit the *.enex file (or even better to reformate the Excel file) with my data and import it into a new Evernote notebook?
Thanks for your help.
Buschi from Germany
4 replies to this idea
Recommended Posts
Archived
This topic is now archived and is closed to further replies.