• Announcements

    • gbarry

      Reach out to Evernote support on Twitter @EvernoteHelps   09/20/2016

      We've been leveling up our support across all channels. If you're active on Twitter, try your hand with our @evernotehelps feed. It's helmed by a crack team out of Austin, TX who are here to answer your questions. They're generally active from 7am-4pm CST.  https://twitter.com/evernotehelps  
Cre8withJulie

Craft Creating Notes from an Excel Spreadsheet

Recommended Posts

I am trying to create individual notes from an excel spreadsheet.  I did this 1 time about 15 months ago but nothing I seem to do will work.   Here is what I have done so far:

Drag a CSV file from Finder to Evernote Elephant icon on bottom tray Result.  1 note with my cvs file as an attachment in note

Drag Data in Column A (rows 1 - 80) with header or without header record onto Evernote Elephant in Bottom Tray . - Result 1 note with each row in a list under the note title

Drag .Xlsx file onto Evernote Elephant in Bottom Tray - Result - 1 note with File name as Note - and .xlsx file as attachment

I am trying to get each row in column A to be a unique note

 

Please help!

 

Share this post


Link to post
21 hours ago, Cre8withJulie said:

I am trying to create individual notes from an excel spreadsheet.

afaik  This is not a feature in Evernote (create individual notes from an excel spreadsheet)
Evernote can create an individual note for each file; but this requires you to convert your speadsheet data to separate files

I have scripted this on my Mac by parsing a .csv file, and could probably import directly from an excel spreadsheet
 

Share this post


Link to post

A few years ago I converted a spreadsheet into files by using the Mail Merge feature in MSOffice.  Use the spreadsheet as a data file and design the output layout using fields in a Word document.  It's possible (or was then) to save the output to file - I used TXT format,  then added the files to an Import Folder (there are scripting options for Mac).

Obviously proceed cautiously and process a small number of records in a test copy spreadhseet first!

Share this post


Link to post

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 account

Sign in

Already have an account? Sign in here.

Sign In Now