Hello,
I emailed Evernote Support and with their method all my information is in the body of the new notes. I can't specify tags, created date or title. I would really appreciate it if anyone has any insight.
They sent me the following:
"Advanced" method for CSV Importing
This script is provided as-is, with no additional support. Feel free to login and post to the Evernote Forum at http://forum.evernote.com should you require further assistance in customization.
In Excel, create the following Macro (you will need to turn on the Developer tab - search Google for information on how to do that):
Option Explicit Sub testme01() Dim iRow As Long Close #1 With ActiveSheet For iRow = 1 To .Cells(.Rows.Count, "A").End(xlUp).Row Open "c:\my documents\excel\test\" & iRow & ".txt" For Output As #1 Print #1, .Cells(iRow, "A").Value Print #1, .Cells(iRow, "B").Value Close #1 Next iRow End With End Sub
Change the filepath to a real one on your computer - best make it a new directory or you'll have 3000 files sitting somewhere you don't want them to be.
If you want all of the columns (or some of them) in a row to appear on the same line, you can rewrite it to be like this:
Print #1, .Cells(iRow, "A").Value & .Cells(iRow, "B").Value If you have 20 columns, just keep adding another "Print" line per Column letter, like: Print #1, .Cells(iRow, "C").Value Print #1, .Cells(iRow, "D").Value Print #1, .Cells(iRow, "E").Value Or, you can get fancy, if they all have the same header info format, and make them html, like: Close #1 With ActiveSheet For iRow = 2 To .Cells(.Rows.Count, "A").End(xlUp).Row Open "c:\my documents\excel\test\" & iRow & ".html" For Output As #1 Print #1, "<html> <head> " Print #1, .Cells(iRow, "B").Value & "<br /><br />Link : <a href=""" Print #1, .Cells(iRow, "D").Value Print #1, """>" Print #1, .Cells(iRow, "C").Value Print #1, " </a> <br/> <br /> <br /> " Print #1, .Cells(iRow, "E").Value Print #1, "" Close #1 Next iRow End With End Sub
(You'll need to alter this one based on your content - if you don't have a Source URL, you wouldn't need to create a hyperlink, for example.)
You can then go to Tools->Folder Import (Windows) to point to the directory of the files (after they've been created) or you can simply drag the folder of files (Mac) onto a Notebook Name in the left-hand Notebook pane, and Evernote will pick them up to import them as individual notes.
Here is a sample file that includes the Macro to help you get started.
More Advanced: You can also choose to export an existing note to .enex format, and examine the format of the file, then alter this macro to output individual .enex files. If you do that, you can use the Evernote File->Import for Evernote files.
Alternately, you can attempt to use the following script created by one of our users:
http://markstout.blo...in-windows.html
Hope this helps!
Big Thanks,
Pavel
46 replies to this topic
#2
BurgersNFries
-
-
- Title: Don't make me come over there...
- Group: Evernote Evangelist
- 9,609 posts
Posted 01 December 2011 - 01:50 PM
There is no way to specify tags or alter the created date when using import folders or when dragging files into EN. However, you can specify what notebook each import folder should send the file(s) to. When using an import folder, the note title is defaulted to the file name. If you need more info on import folders, please search the board.
If you choose to use the enex method, I think tags are assigned upon import, if you've assigned them to each note in the enex file.
If you choose to use the enex method, I think tags are assigned upon import, if you've assigned them to each note in the enex file.
I'm not affiliated with Evernote. I'm just an Evangelapologist. Evernote is an integral part of my life.
Submit support requests toward the bottom of the help/support page here. If you do not receive an auto reply email with a case #, it did NOT get submitted. Premium users will receive a reply within one business day, California time. Free users receive a reply as time permits.
Submit support requests toward the bottom of the help/support page here. If you do not receive an auto reply email with a case #, it did NOT get submitted. Premium users will receive a reply within one business day, California time. Free users receive a reply as time permits.
#3
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 28 August 2012 - 09:19 AM
Hi all!
Being new to Evernote, I'm just trying to get my data back from various other applications into it. All I have is CSV files, resulting from exporting out of Notepad or Upvise, for example. The most important in the first place is importing my to-do lists but I couldn't find any function to perform this: can anyone supply the procedure for importing a list into Evernote?
Thanks in advance for any help!
Being new to Evernote, I'm just trying to get my data back from various other applications into it. All I have is CSV files, resulting from exporting out of Notepad or Upvise, for example. The most important in the first place is importing my to-do lists but I couldn't find any function to perform this: can anyone supply the procedure for importing a list into Evernote?
Thanks in advance for any help!
#4
jefito
-
-
- Title: Evernote Evangelist
- Group: Evernote Evangelist
- 8,143 posts
Posted 28 August 2012 - 10:56 AM
You'd need to convert the CSV into something that Evernote can use, like, say, HTML with tables. Try googling for "csv to html table", there appear to be tools out there to do it.
~Jeff
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
#5
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 28 August 2012 - 02:00 PM
OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?
Thanks again for your help!
Thanks again for your help!
#6
BurgersNFries
-
-
- Title: Don't make me come over there...
- Group: Evernote Evangelist
- 9,609 posts
Posted 28 August 2012 - 02:22 PM
OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?
Thanks again for your help!
I'm sure there's a valid reason EN does not import from any file format other than HTML.
Additionally, if you can export/parse each note to a txt/ASCII file (one file per note), you can use an import folder to automatically pull in the txt files. One file = one note. You can search the board on import folder, should you want more info.
I'm not affiliated with Evernote. I'm just an Evangelapologist. Evernote is an integral part of my life.
Submit support requests toward the bottom of the help/support page here. If you do not receive an auto reply email with a case #, it did NOT get submitted. Premium users will receive a reply within one business day, California time. Free users receive a reply as time permits.
Submit support requests toward the bottom of the help/support page here. If you do not receive an auto reply email with a case #, it did NOT get submitted. Premium users will receive a reply within one business day, California time. Free users receive a reply as time permits.
#7
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 28 August 2012 - 02:28 PM
Sure! By the way, once I've converted my CSV file to an HTML file, I cannot find any import "HTML file" function in the main menu: where's the magic button there? ;-) Does it work only through an Import folder?
#8
jefito
-
-
- Title: Evernote Evangelist
- Group: Evernote Evangelist
- 8,143 posts
Posted 28 August 2012 - 03:56 PM
Yes, import folder appears to be the way.
~Jeff
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
#9
Mike Wood
-
-
- Title: Browncoat
- Group: Members
- 680 posts
Posted 28 August 2012 - 06:45 PM
@EICroco a few questions:
How many columns/fields has your CSV got? and number of rows?
Could you post an example of one of your notes in CSV format (one row).
Are there any attachments does the CSV contain file paths to these?
One option might be to import it into excel/word and then create a mail merge to a PDF writer (configured to produce a file per row)
How many columns/fields has your CSV got? and number of rows?
Could you post an example of one of your notes in CSV format (one row).
Are there any attachments does the CSV contain file paths to these?
One option might be to import it into excel/word and then create a mail merge to a PDF writer (configured to produce a file per row)
#10
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 29 August 2012 - 07:09 AM
Hi Mike,
The file structure is really straightforward: 6 columns x 25 lines, raw text only, no attachement. Here's an example (EDIT: seems the format is corrupted when copy/paste from the HTML file, I then remove the HTML code and give the original CSV file content):
This is a DIY shopping list and I just want it to stay that simple, adding a checkbox somewhere in the line that allows me to clear the entry...
If you know Upvise (list manager), this is exported from Upvise as CSV file and converted to HTML. Going to PDF would add one extra step to a procedure that already looks pretty complicated... :-(
Thanks in advance for any help.
The file structure is really straightforward: 6 columns x 25 lines, raw text only, no attachement. Here's an example (EDIT: seems the format is corrupted when copy/paste from the HTML file, I then remove the HTML code and give the original CSV file content):
Title,Quantity,Unit,Price,Description,Category
Tube acier D40 interne,1,,,,Quincaillerie
Gravier,2,tonne,,,Matériaux
Travertin,2,,,"250 x 950 + 510 x 1415
Tel: 0442047100, 8h00-12h00/13h30-18h00, appeler avant",Matériaux
Mini niveau à bulle,2,,,http://www.fpv4ever.com/accessoires/521-niveau-a-bulle-.html,Outillage
Tube flexible 1m,1,,,,Electricité
Mètre ruban adhésif,1,,,,Quincaillerie
Pince crocodile auto,2,,,,Automobile
Rayonnages acier,8,,,"H = 2m, largeur à déterminer, Le Bon Coin",Equipements
"Plaque ondulée bitumée rouge, 2x0.86 m",3,,8.9,,Matériaux
Protecteur de peinture,1,,,"Type Duragloss #105, Finish Kare 1000P",Colles & Peintures
Pied à coulisse digital,1,,19.25,M&P,Outillage
Mèche à centrer,1,,,http://www.metiers-et-passions.com/fr/catalogue/forets-centrer-forme-ahss-din-333/t-o-0004080201-skg.html,Outillage
This is a DIY shopping list and I just want it to stay that simple, adding a checkbox somewhere in the line that allows me to clear the entry...
If you know Upvise (list manager), this is exported from Upvise as CSV file and converted to HTML. Going to PDF would add one extra step to a procedure that already looks pretty complicated... :-(
Thanks in advance for any help.
#11
Mike Wood
-
-
- Title: Browncoat
- Group: Members
- 680 posts
Posted 29 August 2012 - 07:26 AM
@EICroco
So you only have 25 items?
If yes do you want to create one note or 25? I'd probably create 1 and add check boxes.
Assuming one note and as its only 25 items I'd probably just paste what you have into a new note and just edit out the commas and add a check box to each line. If you had hundreds I would load into excel and export from there into a text document... This would allow you to control the width of columns and re arrange columns... You can also save out of excel as HTML.
Key points... Have you got Microsoft Excel?
How do you want notes to look?
How many notes are you wanting to create? (are you going to combine multiple items into one note)
So you only have 25 items?
If yes do you want to create one note or 25? I'd probably create 1 and add check boxes.
Assuming one note and as its only 25 items I'd probably just paste what you have into a new note and just edit out the commas and add a check box to each line. If you had hundreds I would load into excel and export from there into a text document... This would allow you to control the width of columns and re arrange columns... You can also save out of excel as HTML.
Key points... Have you got Microsoft Excel?
How do you want notes to look?
How many notes are you wanting to create? (are you going to combine multiple items into one note)
#12
Mike Wood
-
-
- Title: Browncoat
- Group: Members
- 680 posts
Posted 29 August 2012 - 07:40 AM
This Excel macro may also help - http://discussion.ev...ort-assistance/
#13
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 29 August 2012 - 11:56 AM
Hi Mike,
Thanks for your help!
As explained before, I just want to create lists, the first one (for trial) is my DIY shopping list, which is 25 items.@EICroco
So you only have 25 items?
If yes do you want to create one note or 25? I'd probably create 1 and add check boxes.
This is what I did, but the final list looks ugly...Assuming one note and as its only 25 items I'd probably just paste what you have into a new note and just edit out the commas and add a check box to each line.
Keep in mind this is my first attempt to import a list into Evernote, other lists may contain tens of items, entering them again would really be a pain...If you had hundreds I would load into excel and export from there into a text document... This would allow you to control the width of columns and re arrange columns... You can also save out of excel as HTML.
Yes, full Office 2007.Key points... Have you got Microsoft Excel?
Would like to get an editable table, which I could sort by name/category/etc. instead of a static piece of text with checkboxes... Ticking the checkbox should grey out the related line or delete it after confirmation. Standard list manager style, see attached file.How do you want notes to look?
I don't use the word "note", what I need is (multiple) "lists": food, DYI, todo, etc. Everything should be displayed as list, with a checkbox to clear out any entry in the list (done/purchased/saved...). Is there any chance to use Evernote for this or should I just buy an Upvise license?How many notes are you wanting to create? (are you going to combine multiple items into one note)
Thanks for your help!
Attached Files
-
Upvise example.png 218.77K
2 downloads
#14
jefito
-
-
- Title: Evernote Evangelist
- Group: Evernote Evangelist
- 8,143 posts
Posted 29 August 2012 - 03:04 PM
Mike's question is on point: It doesn't matter whether you want to use the word "note" or not -- notes are what Evernote uses. Evernote notes can contain different types of content, including lists. So if you want to store your CSV-based lists in Evernote, you will necessarily be using notes to hold them; the question is whether you will be importing multiple CSV files into a single note, or whether each CSV file will generate a single note.I don't use the word "note", what I need is (multiple) "lists": food, DYI, todo, etc. Everything should be displayed as list, with a checkbox to clear out any entry in the list (done/purchased/saved...).
~Jeff
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
#15
Mike Wood
-
-
- Title: Browncoat
- Group: Members
- 680 posts
Posted 29 August 2012 - 03:05 PM
@ElCroco Thanks for the info... To be honest I'm not sure EN is going to work the way you want on its own; you need to work this out first.
I suggest you look at another app which links with EN perhaps http://trunk.evernot...gretlist/iphone
I suggest you look at another app which links with EN perhaps http://trunk.evernot...gretlist/iphone
#16
ElCroco
-
-
- Title: Member
- Group: Members
- 7 posts
Posted 29 August 2012 - 03:39 PM
Fine! The Egretlist application could actually do the trick, but I need an Android version... :-( This will probably end up with a auxiliary app...
Thanks anyway to all of you for the help!
Thanks anyway to all of you for the help!
#17
Mike Wood
-
-
- Title: Browncoat
- Group: Members
- 680 posts
Posted 29 August 2012 - 09:36 PM
@ElCroco To inspire you, take a look at this site and it's use of EN to organise tasks etc. There as some great 5 minute videos which show the power of EN very well. http://www.thesecretweapon.org/
#18
Anthonyqld
-
-
- Title: Member
- Group: Members
- 1 posts
Posted 24 October 2012 - 12:18 PM
OK, will try this! Anyway, CSV is kind of universal file format, would be good to be able to import directly CSV file... Missing feature?
Thanks again for your help!
CSV isn't a universal file format. It's a proprietry Microsoft format.
#19
Martin Packer
-
-
- Title: Browncoat
- Group: Members
- 385 posts
Posted 24 October 2012 - 12:35 PM
s/universal file format/widely-understood format/
I was going to suggest someone - in their copious spare time :-) - create a CSV-to-ENEX utility. But as the OP mentioned "Android" that probably wouldn't work.
I was going to suggest someone - in their copious spare time :-) - create a CSV-to-ENEX utility. But as the OP mentioned "Android" that probably wouldn't work.
#20
jefito
-
-
- Title: Evernote Evangelist
- Group: Evernote Evangelist
- 8,143 posts
Posted 24 October 2012 - 01:13 PM
Utter nonsense. http://en.wikipedia....eparated_values. A quote from that article: "CSV is a common, relatively simple file format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often proprietary and/or undocumented) formats. This works because so many programs support some variation of CSV at least as an alternative import/export format.". Also see the referenced: http://tools.ietf.org/html/rfc4180CSV isn't a universal file format. It's a proprietry Microsoft format.
Edit: Martin got there first.
~Jeff
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
EVERNOTE: Getting Started | Support Page | Knowledge Base | Support Requests
If someone helped you, or you like or agree with someone's post, let them (and us) know by clicking their post's "Like" button.
Also tagged with one or more of these keywords: windows, evernote
Windows
Evernote Products →
Evernote →
EXB FileStarted by akrde, Today, 05:02 PM  evernote
|
|
|
||
Windows
Evernote Products →
Evernote →
Help: Retrieve Evernote local files to new accountStarted by japferp, Today, 09:43 AM evernote
|
|
|
||
Windows
Evernote Products →
Evernote →
LOOSING DATAStarted by Waggelen, Today, 07:14 AM evernote, data-loss
|
|
|
||
Windows
Evernote Products →
Evernote →
Windows Installation Error Code 2732- Another Easy Workaround.Started by Benny.Flash, Today, 06:31 AM evernote
|
|
|
||
Windows
Evernote Products →
Skitch →
Skitch for Windows 2.1.1 is Live!Started by Joe Lopez, Today, 01:41 AM skitch
|
|
|
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
