Jump to content
2019 Calendar Templates Read more... ×
TdeV

Sort Evernote table by one columnm, ascending or descending - can it be done?

Recommended Posts

Can tables be sorted by columns, either ascending or  descending?

  • Like 6

Share this post


Link to post

No, Evernote does not sort columns.

 

You could use a spreadsheet file inside an Evernote note and let the spreadsheet do the sort.

  • Like 2

Share this post


Link to post

Yes.

 

This has to be done in Firefox.
 
1) Open Firefox
2) Download TableTools2.
 
 
3) Create the table in EN on your PC . Use the top row as your header row.
 
4) Sync with EN web client.
 
5) Click on the edit icon (the pencil in the header section)
 
6) Right click in the header section of the column you want to sort / filter.
 
7) Scroll down to TableTools2 - select your sort/ filter option.
 
8) Sort
 
9) Click on Done
 
10) Sync with EN client

 

  • Like 2

Share this post


Link to post

I'm very surprised with all the other stuff Evernote does that this isn't part of it's basic functions.

 

Why is there no way to sort table data in Evernote? Could you put this on your to-do list?

 

My work around right now for this is to use my pc version, copy my table into Word, sort it there then move it back into Evernote. Rather cumbersome don't you think?

 

I think the other method posted here about sorting it in Firefox browser is also awkward.

 

Thanks

  • Like 4

Share this post


Link to post

Doesn't help at all if one is not on a Mac, DTLow :(

Dear Evernote, we still want this, ya' know. :)

 

  • Like 1

Share this post


Link to post
16 hours ago, TdeV said:

Doesn't help at all if one is not on a Mac, DTLow :(

Dear Evernote, we still want this, ya' know. :)

 

I agree, we really need this sort feature, in all platforms supported by Evernote.

For now, the best workaround is to cut the table in the EN Note, paste into a word processor like MS Word, do the sort, copy, and paste back into the EN Note.  Automation tools like AutoHotKey can  help you do this.

  • Like 1

Share this post


Link to post

Moved to the product feedback forum so that this can be voted on.

  • Like 2

Share this post


Link to post
13 hours ago, DTLow said:

Moved to the product feedback forum so that this can be voted on.

And where would this be?

Share this post


Link to post
25 minutes ago, TdeV said:

And where would this be?

Its right here.  You found it.  Windows Desktop Product Feedback

I picked that to honour the platform of the original poster, even though its a multi-platform request, and I'm a Mac user. 
I've been told we'll be a multi-platform feedback queue, but until then - this is it.

Share this post


Link to post

Thanks @DTLow. How does that post tally the votes? It says 2 and the original post has 3 people who like it (i.e. 4).

Share this post


Link to post

You click on the up arrow to up vote a request.

The theory is it increases the attention Evernote will give the request.

  • Like 1

Share this post


Link to post

In general, I find Evernote tables to be poorly implemented.  I would much prefer that they leave the simple tables alone as they are easy to use for a basic table that a user might need.  Going forward for a proper solution, they should add embedded Google Doc spreadsheets in a scrollable frame inside a note for advanced table use  This is a far better solution then having the Evernote team waste their time to re-invent spreadsheet features for their existing tables.  

I am only a web user, and I have been frustrated by poor table/spreadsheet support, so I've been working on a Greasemonkey script to embed a Google Doc spreadsheet into an online Evernote page.  See the screenshot below.

It contains an embedded Google doc spreadsheet in my Evernote note page. It's a live spreadsheet, in that changes made in the spreadsheet are also stored back into Google Docs and changes made at Google Docs are reflected into the Evernote page.

I'm making this my own solution for now, until Evernote adds something permanent along these lines. 

Pros: easy, full Google Doc spreadsheet integration, live data
Cons: custom solution, possibly not supported in desktop clients, not available and/or difficult to do on small screen mobile clients, and spreadsheets are not searchable. 

 

yenxYQO.png

 

  • Like 2

Share this post


Link to post
53 minutes ago, Brian64 said:

In general, I find Evernote tables to be poorly implemented.

Agreed.  Or, it could be stated as "a very limited implementation".

54 minutes ago, Brian64 said:

 I would much prefer that they leave the simple tables alone as they are easy to use for a basic table that a user might need.  Going forward for a proper solution, they should add embedded Google Doc spreadsheets in a scrollable frame inside a note for advanced table use 

I have no objections to this, but not as a primary solution to the poor table implementation.   I don't want to be dependent on a online Internet connection to Google to do basic table manipulations.

I would guess that many, perhaps most, of us just want decent table formatting in Evernote.  We are NOT asking for spreadsheet calculations capability.  For that I just embed an Excel file.  But it would be most helpful to insert, delete, move, format rows and columns, and to sort the table based on one or more columns.  We can insert and delete now, but not the other stuff.

  • Like 2

Share this post


Link to post
On 7/20/2016 at 7:18 PM, Brian64 said:

In general, I find Evernote tables to be poorly implemented.  I would much prefer that they leave the simple tables alone as they are easy to use for a basic table that a user might need.  Going forward for a proper solution, they should add embedded Google Doc spreadsheets in a scrollable frame inside a note for advanced table use  This is a far better solution then having the Evernote team waste their time to re-invent spreadsheet features for their existing tables.  

I am only a web user, and I have been frustrated by poor table/spreadsheet support, so I've been working on a Greasemonkey script to embed a Google Doc spreadsheet into an online Evernote page.  See the screenshot below.

It contains an embedded Google doc spreadsheet in my Evernote note page. It's a live spreadsheet, in that changes made in the spreadsheet are also stored back into Google Docs and changes made at Google Docs are reflected into the Evernote page.

I'm making this my own solution for now, until Evernote adds something permanent along these lines. 

Pros: easy, full Google Doc spreadsheet integration, live data
Cons: custom solution, possibly not supported in desktop clients, not available and/or difficult to do on small screen mobile clients, and spreadsheets are not searchable. 

 

yenxYQO.png

 

Can you kindly share your Greasemonkey script solution?  I would like to have the ability to link a Google Spreadsheet inside of EN and have it be an editable, "Live" document.  Thanks.

Share this post


Link to post
On 2/19/2016 at 9:15 PM, DTLow said:

Its right here.  You found it.  Windows Desktop Product Feedback

I picked that to honour the platform of the original poster, even though its a multi-platform request, and I'm a Mac user. 
I've been told we'll be a multi-platform feedback queue, but until then - this is it.

Could you add a link to the vote directly. There are 1000+ ideas and searching is tedious when you do not know the phrase to search. We must have this basic functionality in EN. To have tables and not being able to sort is not good enough. Please assist

Share this post


Link to post
10 minutes ago, Bowie said:

Could you add a link to the vote directly.

Here’s a  link to a feature request post.  Voting buttons are in the top left corner

 

Share this post


Link to post
On 7/29/2013 at 12:21 AM, Rykmann said:

Yes.

 

This has to be done in Firefox.
 
1) Open Firefox
2) Download TableTools2.
 
 
3) Create the table in EN on your PC . Use the top row as your header row.
 
4) Sync with EN web client.
 
5) Click on the edit icon (the pencil in the header section)
 
6) Right click in the header section of the column you want to sort / filter.
 
7) Scroll down to TableTools2 - select your sort/ filter option.
 
😎 Sort
 
9) Click on Done
 
10) Sync with EN client

 

 

It's 2018 and the TableTools2 addon seem to be now defunct. 

Share this post


Link to post
19 minutes ago, jasecutler said:

It's 2018 and the TableTools2 addon seem to be now defunct.

More importantly, if it is that easy to do, why hasn't Evernote built in sorting in all of their apps?

Share this post


Link to post
19 minutes ago, JMichaelTX said:

More importantly, if it is that easy to do, why hasn't Evernote built in sorting in all of their apps?

 

It's a head-scratcher, that's for sure. 

You've got to question WHY the Evernote team refuses to implement this improvement. Is there an ulterior motive? 

Share this post


Link to post
11 hours ago, jasecutler said:

Is there an ulterior motive? 

I'm not seeing an "ulterior motive" other than not adding complexity/bloat to the product.
There's also funding for the development work; the majority of users are unwilling to fund this product.

Share this post


Link to post
12 hours ago, jasecutler said:

Is there an ulterior motive? 

Your question is a bit of a head-scratcher. What possible "ulterior motive" could there be? What' do you think? Is there a conspiracy underlying this? Do we need to launch a federal investigation? 

I suspect that the answer is somewhat more prosaic.

I can think of lots of reasons why Evernote might not implement this particular feature, but none of them are ulterior. They're just part of what any developer goes through when deciding which features get implemented and which ones don't. The article Minus 100 Points illustrates one way to think about it, in the context of deciding which features ought to go into the C# programming language: "Every feature starts out in the hole by 100 points, which means that it has to have a significant net positive effect on the overall package for it to make it into the language. Some features are okay features for a language to have, they just aren't quite good enough to make it into the language". Also, remember that every feature requires resources that are taken away from other features.

Personally, I think that it wold be cool to have sortable tables, with the ability to have spreadsheet-like formulas etc., and I know that that's not a huge technological task, but I'd have to rate that as nice-to-have, but probably not a requirement for a lot of Evernote's users.  It's most likely really that simple.

  • Like 1

Share this post


Link to post

Oh, @jefito, you and your persistent rationality! :o My take is that for some people, this is a huge primary need, for others it would be nice to have, and for others it's not even on our radar. It's hard (it's certainly hard for me) to realize that something that seems so obvious and essential to one's own work is not one of the major needs of many other users.

Share this post


Link to post
4 minutes ago, Dave-in-Decatur said:

It's hard (it's certainly hard for me) to realize that something that seems so obvious and essential to one's own work is not one of the major needs of many other users.

Ha-ha -- I'd say that that more or less the nutshell version of "dealing with other humans" (AKA the human condition). Most of us struggle with that; I know I do.

But understanding another's needs is only one aspect, in this case; the other piece of the equation is balancing one's own situation with someone else's needs. It's usually a bancing act. . Or to put it into context, many feature requests vs. finite resources. In that world, you take your best guess at what's important, and try to do that.

  • Like 1

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

×