Search the Community
Showing results for tags 'spreadsheet'.
Found 15 results
-
I have information stored in a spreadsheet which I would like to import/place into a table in a note. I have tried copy/paste, copy and paste tab delimited file, copy and paste comma delimited, pure text, rtf and .doc but all of the data always pastes into one cell. There appears to be mo import command available. Any idea how I could accomplish the import? Thanks, Jim
-
If I posted about this already, I apologise. If I didn't post it before I also apologise. If someone else suggested it here, I'm sorry that I'm now taking credit for finding it. In fact let's just start off with me being really, really, really sorry and move on. Then, on a happier note.. I liked Transpose, because it was, until very recently, a database to which you could add structured information, and process and display it online in various ways. It's now closed down, but I found a new contender. Airtable. Which is a spreadsheet to which you can add data. It's also a relational database - you can link new facts to stuff you already know - and a calendar (if you have dates in there somewhere) and a KanBan chart of items sorted by various options. In fact it's quite a little powerhouse of collaboration and connectability which I'm initially using for one project as a trial. Too much information for detail, but Transpose Airtable* would mean (forinstance) that if I was arranging meetings throughout the year on different subjects at different venues, I could have one database of venues, one database of subjects, and one database of details and dates, linking to the relevant subjects and venues so I don't have to keep entering the same information over and over for each event. I can share the Calendar view with my customers so they know what's coming up in their area, and if they sign up with one or other venue I can use their sign-up form (created in Airtable) to look-up or populate their customer record for my information later. I can use the KanBan view to keep me on track with support material for each event. It looks really good. Obviously do your own due diligence before you invest hours setting up your own system, and (just for information) I get all my data together in Evernote before I set it up in Airtable and they support Zapier, so I should be able to arrange to copy details across rather than enter it twice. It's an app worth Evernoting, even if you don't need it now. (Just to confirm - I have no connection with them!) PS Evernote - the relational database thing is what they call 'transcopy' in Wikis, where you show some or all the content of one note as part of another. If only Evernote did that sort of thing I wouldn't need to use third-party software... * PPS - Oops.
- 35 replies
-
- 3
-
-
- spreadsheet
- database
- (and 2 more)
-
Is it possible to update an excel spreadsheet in evernote instead of uploading a new file every time a change is made? Thanks! -
I often want to put notes in Evernote that are in some sort of table or spreadsheet format. I don't need to do any fancy spreadsheet stuff. Just raw data. The problem is I often don't know ahead of time how many cells I will need. And I often just need to add cells or tweak things. I've found the table tool included in Evernote to be completely worthless. I need to guess ahead of time how big the table is going to be, and when typing within the table, the formatting is just kind of...screwy. Does anyone else have this problem? How did you solve it? It's actually something I do pretty often in the 3 years I've been using Evernote, I'm kinda surprised this isn't something that has ever been fixed or added.- 67 replies
-
- 1
-
-
- table
- spreadsheet
- (and 1 more)
-
Dear Evernote team, One very useful feature of a note editor is automatic in line calculations like it is implemented in OneNote (already mentioned on this forum) Or in more sophisticated calculation apps like Calca Please consider adding this functionality to (at least) desktop clients (may be as a premium feature) Thanks Denis
-
Hello forum, can any of you help with my query below in red? I have included a message from Evernote Help and Learning too spencer0i (my query) May 26, 19:08 I have a spreadsheet with multiple rows (150+). I need to create a note in Evernote for each row in my spreadsheet (150+ notes) but I don't want to do this manually as it will take ages. Is there a way to automatically create these notes from the rows in my spreadsheet? (This is an urgent issue that I need to resolve) Amanda H. (Evernote Help and Learning) May 27, 11:47 Hi there, Thanks for contacting Evernote support! At this time there is not a native way to create Evernote notes automatically from an Excel spreadsheet, the only way to do this is by manually copying and pasting the content. Some of our other Windows Evernote users may have created workarounds, or you can ask other users if they've found workarounds for accomplishing this on our Evernote User Forum. I hope that helps! Let me know if you have any other questions, and enjoy the rest of your weekend. Regards, Amanda H. -
Hi, are there any short cuts for inserting or deleting new columns and rows into spreadsheets? I didn´t find it handy to use all the context menus. Thanks a lot!
-
Hi all, This is mostly for the Windows client (latest, 5.6.4.4632), I'm having a Premium subscription. I'm aware there's no "simple spreadsheet" as integral part of evernote, althogh I (and a number of posters) really could use a way to make simple calculated lists. (mini-budgets, comparing offers etc) I can see why Evernote is reluctant doing "spread". But I can't see any useful workaround using an external editor, like Excel. What seems like one obvious solution: Adding (dragging etc) a spreasdheet file to a note, edit externally, but preview the filled part of the active sheet directly, without click & wait. DropBox works like a charm with a fast web preview of XLSX and XLS files. Evernote just shows an icon for these file types. Making copies to Evernote really won't do in a workflow today. (I like a lot about Evernote, absolutely, but it can't yet become my sole "master system" for smaller information clips) Or did I miss something? Thanks! -olav
-
As has been briefly discussed before (at least here https://discussion.evernote.com/topic/30398-simple-spreadsheet-soon/ and https://discussion.evernote.com/topic/29114-simple-spreadsheet-please/). I am similar to the former post in that I have ton of small, simple spreadsheets cluttering my hard drive -- spreadsheets which are very handy but don't really need most of the overhead of a full spreadsheet app. This would be a killer feature for me in EN and would fit my usage of the app (I use Mac and iOS mostly) perfectly. When I need to make a quick list or note or reminder, I use EN; when I need to make a fancy document with lots of formatting, etc, I use a word processor. Similarly, when I just need to run some numbers and save them for later, I would love to use EN to sort, tag, find, search etc. If I need a really fancy spreadsheet with different sheets, charts, complex formulae, etc, I can use a dedicated spreadsheet app. (Note that I don't envision the need for "spreadsheet notes" to be embedded w/i other notes, but to be separate, stand-alone notes.) I've been using EN for over 4 years now and paid customer for about 1. It's great and a feature like this would make it greater and dramatically increase my usage. Thanks, Clayton
-
windows 8 EN is changing cells format for an attached Excel file
Alexs7 posted a topic in Windows Archive
That happened to me several times. Once I edit an attached excel file in EN and save it then reopen it, I found all cells without formulas has their format changed to "Date" format ! that is really ruining my work ! I even have premium account ! Anyone experiencing this ? how to stop that ? I attached simple table in the excel file . see how all numbers changed to date. the lower cells are 1, 2, 3 but changed to 1-Jan-00, 2-Jan-00, 3-Jan-00 ! -
When will Evernote be able to create speadsheets with formulas and slideshows, so we don't have to have excel or powerpoint?
-
Hello, How can I copy a part of a spreadsheet or a part of a letter in Word, copy to Evernote ? Thanks in advance ! Peermeneer -
Quite often in my work I want to informally "run the numbers." In the past, I cluttered up my hard drive with numerous quick and dirty spreadsheets that rarely used more than sum rows or columns and occasionally a percentage formula. If evernote is going to really work for me, I need to be able to work on those spreadsheets from within the evernote application. I'll be happy with any solution: 1. A live frame within the note that is a window to a google or other cloud based spreadsheet where the cost is not unreasonable 2. A native spreadsheet that initially does only the very basic operations and after that periodically adds new features. 3. Some other workaround that's not too cumbersome to use on a regular basis. Thanks,
-
One of my projects for 2013 is to buy a new bottle of wine every time I'm out grocery shopping, thus giving me a chance to try something new and build up my "wine cellar" after my equatorial move. After buying the 4th bottle, I realized that it was going to be increasingly difficult to remember which ones I had already bought. I've started a very simple list (currently only 4 lines long) and I'm trying to figure out the best way to utilize Evernote so that while I am out shopping, I can pull up the note (once I pay for the premium services, of course) and see what I've already bought so I don't buy it again. I would love to have the ability to then on the spot add the new wine I buy to the EN list, but this part is a "wish" more than a "need". I'm trying to figure out the best way to do this in Evernote. Any suggestions? I've already tried a simple spreadsheet in OpenOffice, which I could then copy and paste into Evernote, but this removes the synching aspect, as if I made any changes, it would not update the OpenOffice file. I tried making a spreadsheet in Evernote, but then I lose the ability to sort alphabetically, which would make finding wines already purchased a lot easier. I've tried linking the OO spreadsheet, but then I cannot make any on-the-go changes. Are there other workarounds for this simple sort of task that I am overlooking? It really is a very simple list - just label, wine type, sub-type (for things like "fizzy" or "dessert wine") and a column for entering a rating once I have a chance to taste it. The only functionality I'm missing in a EN-only table is the alpha-sort. The only functionality I'm missing in any other solution is the synch. Help! -
Dear Evernote - Love your product, blah blah blah. :-) I use my evernote constantly. Use it for all sorts of things. One thing I use it for is jotting down my budget expenses. I'd love it if Evernote had a simple math function in its tables. Nothing fancy, nothing spreadsheetish. It'd just be nice if I could do a table like: John $100 Jane $200 Bill $300 Total =COLSUM where =COL gets replaced with the sum of that column. You could also have =COLAVE where it's the average. That's about the only two functions that are essential for me. What do you think? Karen
