Search the Community

Showing results for tags 'excel'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Calendars

  • Community Event Calendar
  • Evernote Events

Forums

  • General Discussions
    • Evernote General Discussions
    • Third Party Application Discussions
    • Using Evernote
    • Billing and Payments
  • Evernote Products
    • Evernote
    • Evernote Business
    • Evernote Web Clipper
    • Scannable
    • Skitch
    • Penultimate
  • International Forums
    • Japanese Discussions
    • Brazilian Portuguese Discussions
    • Discussions in Spanish
    • Korean Discussions
    • Traditional Chinese Discussions

Categories

There are no results to display.

There are no results to display.


Found 66 results

  1. Hi All I just had a question in relation to saving excel documents into Evernote. As I understand it - you can drag and drop an excel document into Evernote, open it from there, edit and save and all the changes will be saved. However, is it possible to save a new version of the excel into the same note? The reason I ask is because I tend to update my spreadsheets daily and get into the habit of saving a new version every time I make a big update/change in case I need to reverse it earlier. i.e. i might start off with Work v1, save it as Work v2, Work v3 each morning. That way i can track changes and go back to an older version of the excel in case I make a mistake or change that I did not want. Essentially, it is my way of using "undo" when the actions have been performed from days or even weeks before etc. Is there an easy way to do this in Evernote? At the moment, I have to save the daily version onto my desktop, and then drag it back into the note as a separate attachment. Any help on this would be much appreciated!
  2. Hello, I love how Evernote scans my business cards and digitizes the contact info. I need to export this list of email addresses and names into a CSV file. I have a Free plan, and I use the web client (not the desktop apps). Can someone tell me how to do this? Thanks!!!
  3. Dear Evernote, I would like to make the suggestion of inserting Excel worksheets within notes an available Evernote feature. I believe this would be a hugely useful feature among users to organize information where a spreadsheet is best suited to accomplish this. Currently, the tables that can be inserted in Evernote (that are more similar to those that can be inserted in Microsoft Word) are useful, however their practicality is low given that they require very manual work to update and keep text aligned. Furthermore, viewing these inserted tables via the Evernote app on a handheld device distorts the text alignment and squeezes the content into a much narrower column making it very difficult to read. Just thought I would bring this up if it hasn't been already; I believe your user base could stand to substantially increase with this feature. Yours truly, Kevin
  4. Is there a way to scan my business cards, add to my contacts, then export that information in a csv or excel doc? I have about 500 business cards to be added to evernote but also need them for Constant Contact. Constant Contact requires a csv or excel document. So frustrated with searching this site for help. So any help would be appreciated!
  5. Hello Evernote-Team, I am using Excel-Sheets to collect a mass of data and analyse them with Excels Pivot functions. For Pivot-functions Excel uses additional access to the file; And this produces an error Evernote is adding an Extension to the filename like [1], in the amendment folder. (I guess it is for protection of overwriting of different file Versions) As these characters are prohibited as filenames, Excel produces an error, when doing a Pivot Analysis. (see attached screenshot) => Please change the type of characters used for filename-Extension into allowed ones. Thanks Jens
  6. Please build a bridge to export contacts in Evernote to Microsoft Excel. The lack of that feature is THE MOST FRUSTRATING DEFICIENCY for me and others I've spoken with. Thank you!!!
  7. Linking Excel/Google Sheets to EN

    Hello - Here is my scenario... I have project notes in evernote with time estimates attached to individual tasks (see attached). I have manually added these to get the total time for each projects. I have a weekly time budget in excel (see attached) Here is what I want to accomplish... I want to be able to update total project times in EN, and then have the "Updated Time" column in excel automatically update to reflect the amount of time remaining in the project. So... What must I do or change to accomplish this? Thanks! Will Sample Weekly Budget.xlsx
  8. Linking Excel/Google Sheets to EN

    Hello - Here is my scenario... I have project notes in evernote with time estimates attached to individual tasks (see attached). I have manually added these to get the total time for each projects. I have a weekly time budget in excel (see attached) Here is what I want to accomplish... I want to be able to update total project times in EN, and then have the "Updated Time" column in excel automatically update to reflect the amount of time remaining in the project. So... What must I do or change to accomplish this? Thanks! Will Sample Weekly Budget.xlsx
  9. Hello - Here is my scenario... I have project notes in evernote with time estimates attached to individual tasks (see attached). I have manually added these to get the total time for each projects. I have a weekly time budget in excel (see attached) Here is what I want to accomplish... I want to be able to update total project times in EN, and then have the "Updated Time" column in excel automatically update to reflect the amount of time remaining in the project. So... What must I do or change to accomplish this? Thanks! Will Sample Weekly Budget.xlsx
  10. Evernoteに、Excelの表を貼り付けたのですが、 Excelのセルの中に1行しか文字が無いのですが、セルの高さが3行になっています。 そこで、セルの高さを1行分にしたいのですが、横線はドラッグできません(縦線はドラッグできますが)。 Evernote プラス に入れば、この誰でも起きる初歩的な問題を解決できますか? また、Evernoteの操作で、セルの背景の色を変更する方法を教えて下さい。
  11. 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.
  12. Hi, this may be a little bit off topic however I see a lot of discussions on this forum revolving around goal setting and "life planning". Has anyone used FireGoal with Evernote? How do you integrate it with your current Evernote "structure" or productivity system? The website is firegoal.com Comments or feedback appreciated.
  13. I wrote an apple script that iterates over rows in a spreadsheet, finds the appropriate notebook and note, and auto-files the formatted information from the row at the top of the note to create an organized log. One piece of information I am trying to capture is the web link to an external source (say, the information is a short synopsis of an interesting Wall Street Journal article). The piece that is currently non-functioning is the hyperlink. It appears as a hyperlink, but includes the evernotecid in the link and so it won't go to the page when clicked. The output looks something like the attached; the link is live, but rather than it taking you straight to the right page http://www.bmj.com/content/352/bmj.i1102 it is linked with the evernotecid in front (e.g. evernotecid://[specificnoteblahblah]http://www.bmj.com/content/352/bmj.i1102) Any ideas as to why the link is including the evernotecid and how to prevent that so the link goes straight to the source? [NOTE: if I just enter the link directly, evernote automatically creates it as a hyperlink and is clickable. I'm specifically looking to solve the issue so I don't have to show the full link and instead can simply link readable text] As reference, Using 6.6 on Mac; Evernote business Thank you!
  14. Hi I am a freelance consultant My dayli nightmare, for nearly 10 years, is the accountancy : invoices to classify, photocopy, whilst writing the amount in an excel sheet. I would like to connect each scanned invoice (via scannable) with an excel sheet I have configurated , so with iphone I can now dictate the amounts, dates and nature of invoices, but the SCAN of invoice is a priority How can I do ? Thanks for your advice
  15. I compile draft reports using Evernote as I like the ability to link notes and other texts back to web clippings. I also include charts from Excel 2016 for Mac in these reports and every time I paste the picture of the chart, it forces a pdf rather than an inline image. In the Evernote for Mac, this is not a problem while viewing on the screen, however when I print the document, the pdf 'images' are moved to the back of the document and are full-sized. This messes up my document and the flow for the reader. Please help with a solution to paste a picture which is inline rather than a pdf. If I paste from a pdf it works, but this is painful when I have 5-10 excel charts to keep repeating this process. PS: Microsoft OneNote is far better at dealing with this issue.
  16. There is a problem, that by adding a macro to excel *.xlsx document file extension changes to *.xlsM. From that moment such file becomes not searchable by evernote. Renaming file back to *.xlsx cures searchability in EN, but excel refuses to open it. Is there a workaround? Thanks.
  17. I've attached an Excel Spreadsheet to a Note and on my Desktop I am able to successfully make changes to the spreadsheet. I'm running Evernote Version 7.4 1 on my Kindle Fire HDX (which is running an Amazon version of Android) and can successfully make changes to the spreadsheet on this device using WPS Office. However, on my Samsung Galaxy S4 Mini phone and HP Touchpad (both running Android and Evernote Version 7.4.2) I am unable to make changes to the spreadsheet. When I click on the three vertical dots 'button' it asks me if I want to View, Edit, Edit a copy, Remove or Download and when I select Edit, "Resource not changed" appears briefly on the screen and any edits I make do not get saved. I'm using WPS Office on both of these devices. Any help to resolve this would be much appreciated.
  18. タイトル通りなのですが、名刺のデータを活用するため、表計算ソフトで使える形式にエクスポートしたいのですが、EVERNOTEのメニューからだと、EVERNOTE形式かHTMLしかありません。 何か良い方法はないでしょうか?
  19. Does anyone know if Evernote Basic, Plus, or Premium can do this with an Excel spreadsheet in it? Please see below for a jpeg of what I'm referring to (see inside red square). I'm trying to figure out if Evernote can do this or not so I know whether I need to keep searching for a program that can. On that related topic, if Evernote can't do this, and someone knows of a similar program that can, please let me know! Thanks everyone for your help! Erin K
  20. Picked up EN again (blank) and starting to put stuff in there. I've been a "member" since 2012. First off, 60MB is still NOT enough and should have been raised by now. Anyways, once reason I left EN and never bothered to pay for it was because the formatting in this thing is terrible. Tried to copy a simple Excel table into EN and all formatting is lost and becomes a complete mess. Tried to copy the table from Excel to Word, then to EN and same effect. Don't get me started on bullet lists. How are you going to make a notes app and can't get formatting properly? Yet, every other moment, EN is asking for me to pay for it? It's too bad Onenote looks terrible on mobile (that desktop look doesn't fit phones and tablets too well). I wish EN engineers would stop making the platform available for every platform and work on fixing long standing issues. It's a shame this app hasn't improved in the basic tasks in the last 3 years. The new web app looks pretty though.
  21. I have many occasions that need to save and edit the Office docs(mainly including Word and Excel), and current workflow for editing office docs is: 1. Save the doc in Evernote to a local file and edit and save it, 2. and then replace the old doc in the Evernote with the local new one. And you know, it's very inconvenient and error-prone. It would be better that the Evernote can support in-place editing of MS Office docs. Thanks!
  22. I had the need to create 4000 notes based on excel data because tagging system in Evernote makes search way more easier than excel. Also with Evernote I could create many Table of contents based on my needs. My excel data was well formatted - each row was going to one unique note. After searching through this forum I realized that may it is impossible to do and I decided to copy painfully one note at a time. Then IDEA!!!! came What if I create a note in Evernote, export evernote file (.enex) Open in notepad and view xml code Find out of table structure and modify to my needs Use vba Macro to convert each row as one noteI found a gentleman (Anton Fishman) on internet who worked on similar problem before and he helped me achieve my goal. I can not attach excel here - but here is the link People with good XML knowledge can help clean up the VBA code a bit to get better table format, that would be great. Remember to change the path to your liking strFile = "C:\Users\1.enex" I created my 4000 notes with required tags with click of a button, it took more time to Sync across devices than to create it. It will create one big .enex file but when you import in windows or Mac machines with File-> import, it will create all notes for you. I would appreciate people's feedback
  23. I am using a mac. I used to be able to cut tables out of excel spreadsheets and other data sources, then paste them into evernote. They looked fine. Sometimes the columns would narrow but I could live with that. They stayed in alignment and looked like a proper table. For the past few days each time I paste, the rows and columns are all unaligned (columns are various sizes for each row). Tables end up looking like a staircase! not square or rectangle. Why is this happening? Is it something to do with the update that was recently done? I tried to find a way to 'paste special' but there doesn't seem to be that option in Evernote. Can anyone help.
  24. How do I take a word, excel or powerpoint file (in Mac) and save it to one of my notebooks? When I'm in the notebook I don't see a way to browse files to save to it. Thanks.
  25. I would like to copy some small Excel spreadsheet pages into EN and have them appear in EN as a grid (with or without the lines). I have basic Evernote. Is there a way to do this?