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.

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

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 dataCons: 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.

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.

2

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 dataCons: 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.

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

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

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.

1

Share this post

Link to post

Oh, @jefito, you and your persistent rationality! 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

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.

1

Share this post

Link to post

I've looked through this, and I'm sure most people may have already thought of or done this, but for the newbies, just dumping the data to Excel, sorting and then pasting it back into the Evernote Table works pretty simply.

- Highlight the entire table (the little, "equal" sign in the circle at the top of the table) >> Edit >> Copy

- Go to a blank Excel Spreadsheet and Edit >> Paste

- Highlight the data >> Data >> Sort

- Edit >> Copy

- Go back to Evernote - should still be highlighted >> Edit >> Paste (do not Match Style - puts everything into one cell or column)

Share this post

Link to post

I've looked through this, and I'm sure most people may have already thought of or done this, but for the newbies, just dumping the data to Excel, sorting and then pasting it back into the Evernote Table works pretty simply.﻿

That will only work if your Excel copy/paste faithfully reproduces the original row/column layout. I've seen cases where pasting (at least from the Evernote Windows application) into Excel does not do this. So while this is a good idea, it may not work well in practice.