Export evernote table to a spreadsheet for sorting

[LynuSBell 11]

Hi,

I use evernote to easily and quickly collect quotes when I am reading. I take my notes on-the-go from my android smartphone and access them on my computer when writing. I was thinking of exporting/copy-pasting my quotes into a csv file and sort quotes by author, alphabetically.

However, Evernote tables seems to consider each new line as a cell instead of the content of a single cell. Excel will merge cells if needed.

For instance, I have two or more merged cells for the author's name next to two or more cells containing a quote and whatever pieces of information I added with it.

Obviously, I am not consistent with it... so can't use a macro except if coded as such "If cell in column A is merged, much X cells on the right".

Is there a way to better work with tables in Evernote?

Or a way to embed a google spreadsheet into a note and access it directly without going to google spreadsheet?

I am also thinking of a zap... let's say, I have one note per quote with a tag "add quote" and Zappier will transfer the quote but I'd rather access my notes in Evernote itself.

Thanks a lot

[gazumped 11,667]

Hi.  I'd suggest creating a separate note for each quote and using tags for each author,  and a standard for 'quotes'.  Give each one a title which suits your system - maybe a summary of the topic,  like "how to succeed" or "strengths & weaknesses".  Then you could search for quotes in general,  or one author in particular and the results would be a list of options for your selection.

[DTLow 5,736]

On 1/2/2020 at 12:56 AM, LynuSBell said:

I use evernote to easily and quickly collect quotes when I am reading. I take my notes on-the-go from my android smartphone and access them on my computer when writing. I was thinking of exporting/copy-pasting my quotes into a csv file and sort quotes by author, alphabetically.

As per @gazumped, my solution is separate notes with tags for author, subject, ...

My tag structure is

A sample quote is

>>I was thinking of exporting/copy-pasting my quotes into a csv file and sort quotes by author, alphabetically

I like to view my data in a spreadsheet; there's more options for sorting and reporting
I do the export using a script on my Mac

[LynuSBell 11]

Hi,

I discovered the tag hierarchy and I simply love it!
I started sorting and tagging even more
 

Do you know if there is a way to tag all the tags in a hierarchy?

Let us say I want to tag

A species taxonomy (I am a biologist).

I would like to tag:

Vertebrates > fish > sharks > species of shark.
If I would tag a species of shark, it would tag all the tags upward. Is it possible? Maybe with Filterize?

 

[DTLow 5,736]

23 minutes ago, LynuSBell said:

Do you know if there is a way to tag all the tags in a hierarchy?

This is not an Evernote feature
It can be done using third party Filterize, or scripting on a Mac

Automatic Tag Hierarchy

If you assign a tag, filterize can add all parent tags automatically. So you have the solution, as described in the third case, but without the requirement of adding all parent tags by hand.

Additionally, you can select which parent tags you are interested in. So if you have irrelevant tags in your hierarchy, you can avoid adding them.

[LynuSBell 11]

I understood that

I am curious about your scripting. I have a MAC but I am not so familiar with scripts.

Do you have it somewhere for download? Or how did you set it up.

[DTLow 5,736]

16 hours ago, LynuSBell said:

I am curious about your scripting. I have a MAC but I am not so familiar with scripts.

Do you have it somewhere for download? Or how did you set it up.

I started an AppleScript discussion here https://discussion.evernote.com/topic/112316-scripting-on-a-mac-applescript/

Navigating the tag hierarchy is simple, for example
     tell application "Evernote"
          repeat while theTagParent is not missing value
               set the theTagParent to parent of theTagParent
          end repeat
     end tell

Assigning tags is simple, for example
     tell application "Evernote"
          assign tag TagParent to theNote
     end tell