Share via

How do I import an Excel spreadsheet into OneNote ensuring the data in the spreadsheet is searchable in OneNote?

Anonymous
2023-03-26T20:02:58+00:00

I need to import spreadsheets on a daily basis into OneNote. These spreadsheets have my comments drawn on to them in Excel, so I need these comments also transferred into OneNote with the spreadsheet. I can't add the notes into the spreadsheet after it's in OneNote as, due to team privacy, these notes cannot be seen prior to discussing them at daily meetings. At the moment I print to OneNote. However the spreadsheets come out blurry, and the data is not searchable in OneNote. I've tried using 'screen clipping' which keeps the data searchable in OneNote - but given I sometimes have the equivalent of 30 pages, it takes too long to screen clip each day. Any advice greatly appreciated.

Microsoft 365 and Office | OneNote | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-26T21:10:22+00:00

    Hello,

    I’m an Independent Advisor and Microsoft user like you and I'm glad to provide you information regarding your scenario.

    Could you please follow below steps to insert a Excel Spreadsheet into OneNote?

    If you create the excel first from OneNote and start editing after opening from the excel app,

    1. The added comments gets moved to excel spreadsheet and retained.
    2. The data added into excel can be searched

    Please refer the attached images

    To add an excel,

    1. Go to Insert on the Menu and select the Tables
    2. Click On "New Excel Spreadsheet"
    3. It will insert a new spread sheet on the OneNote page and if you double click on that, it will open the excel in new Window
    4. You can save and maintain the excel within OneNote.

    Please refer this blog which would be useful for you, https://www.groovypost.com/howto/embed-excel-data-into-microsoft-onenote/#:~:text=To%20do%20this%2C%20open%20your%20OneNote%20notebook%20and%20click%20Insert,that%20appears%2C%20click%20Attach%20File.

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it

    Hope this information would be useful to you. Please feel free to get back if you need any additional info.

    Thank you! Ravikumar Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    10 people found this answer helpful.
    0 comments