JimInSanDiego 2 Posted November 11, 2014 Share Posted November 11, 2014 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 1 Link to comment
Nadya De Angelis 24 Posted November 11, 2014 Share Posted November 11, 2014 Good question. AFAIK, there's no such functionality. Moreover, you can't even copy/paste a table even within Evernote. Link to comment
Level 5* jefito 5,598 Posted November 11, 2014 Level 5* Share Posted November 11, 2014 Have you tried HTML? Evernote for Windows will pull those in if they're in an auto-import folder. For that matter, copy and paste from Excel will work in Evernote for Windows. Link to comment
JimInSanDiego 2 Posted November 11, 2014 Author Share Posted November 11, 2014 Have you tried HTML? Evernote for Windows will pull those in if they're in an auto-import folder. For that matter, copy and paste from Excel will work in Evernote for Windows. It worked in both Mac and Windows! I exported from Numbers (I assume Excel would work too) to a html page, opened the page in Firefox (either OS), copied, went to Evernote and pasted and a table appears with the data. Now if I only had control over the data in the table, lol. I want to be able to select a row or column. Oh well, thanks. Link to comment
Level 5* JMichaelTX 4,118 Posted November 11, 2014 Level 5* Share Posted November 11, 2014 In EN Mac, I have found that copy/paste directly from Excel does NOT work so well.However, what does work well is to copy the cells of interest from Excel, Paste into Word, then select/copy the table from Word and paste into an Evernote Note. This gives you the opportunity to make any formatting adjustments in Word, if it is necessary. 1 Link to comment
Analyst444 182 Posted November 11, 2014 Share Posted November 11, 2014 JimInSanDiego - Here is an different perspective. Ask yourself why do you want to paste information from a spreadsheet into an Evernote Note? You could "attach" the spreadsheet to a Note. Would that work for you in this instance? Link to comment
Level 5* jefito 5,598 Posted November 11, 2014 Level 5* Share Posted November 11, 2014 JimInSanDiego - Here is an different perspective. Ask yourself why do you want to paste information from a spreadsheet into an Evernote Note? You could "attach" the spreadsheet to a Note. Would that work for you in this instance?An easy one: tables you give an extra bit of formatting ability. It doesn't need to be a live spreadsheet, but just the ability to store data in neat columnar fashion can be really useful. Link to comment
Level 5* JMichaelTX 4,118 Posted November 11, 2014 Level 5* Share Posted November 11, 2014 JimInSanDiego - Here is an different perspective. Ask yourself why do you want to paste information from a spreadsheet into an Evernote Note? You could "attach" the spreadsheet to a Note. Would that work for you in this instance? Here are few good reasons:You have to be a Premium account owner for Evernote to include Excel files in searches Although EN Mac will display an Excel file inline, it is not very good and other platforms don't support it. If you have limited (as in single Excel workbook, << 100 rows) of reference info, it is much more convenient to view and search if you just paste the data into Evernote. Link to comment
JimInSanDiego 2 Posted November 12, 2014 Author Share Posted November 12, 2014 JimInSanDiego - Here is an different perspective. Ask yourself why do you want to paste information from a spreadsheet into an Evernote Note? You could "attach" the spreadsheet to a Note. Would that work for you in this instance?Well the data was in a tab deliminated note program. I am shifting everything to Evernote so I can easily access my notes on a Mac, PC or my iPad. I olny put it into a spreadsheet while trying to get te dat into an Evernote table. I may yet try an attachment but I'm not sure how easy it would be to edit on various platforms. Thanks for the idea. Evernote should post the html inport in their help...wait, there is not real help or manual Link to comment
JimInSanDiego 2 Posted November 14, 2014 Author Share Posted November 14, 2014 I DID IT! I IMPORTED A SPREADSHEET INTO A TABLE IN EVERNOTE! IT CAN BE DONE! I experimented and experimented and stumbled on something that worked. I had my data in a Mac Numbers spreadsheet. I copied and pasted it in a note but there was no table. So I tried exporting the data to a HTML page. I opened the HTML page in Firefox but copying and pasting a HTML page into a note also didn’t work. Then, quite accidentally, I copied the HTML data into a new spreadsheet in Numbers. Most of the formatting also copied in including justification and background colors. I copied the spreadsheet data to the clipboard again, made a new Evenote note, pasted and Surprise! the data was there in a table including background colors and justifications. I do not own Excel but the same steps might also work with Excel. I do not know why or how the new Numbers spreadsheet was different form the old but it worked with the new one. This morning, I could duplicate the steps with success again. Give it a try. 1 Link to comment
MarkZ 0 Posted February 5, 2016 Share Posted February 5, 2016 Here's the procedure I used to convert a Numbers table to an Evernote table on my MacBook Pro running Yosemite. Cutting and pasting the table did not work. Open Numbers spreadsheet Copy table to be moved to Evernote Open Text Edit Create a new Rich Text document Paste the table into the new document Save the Textedit document as HTML Open HTML in Safari Copy Table in Safari Paste into Evernote. Link to comment
Level 5* JMichaelTX 4,118 Posted February 9, 2016 Level 5* Share Posted February 9, 2016 If you have MS Word, I have found the following to work very well: copy the selected cells in Numbers or Excel Paste into Word, which creates a table, Copy Word Table Paste into EN Note 5 Link to comment
tzero86 1 Posted March 15, 2016 Share Posted March 15, 2016 On 2/9/2016 at 11:58 PM, JMichaelTX said: If you have MS Word, I have found the following to work very well: copy the selected cells in Numbers or Excel Paste into Word, which creates a table, Copy Word Table Paste into EN Note This worked for me like a charm on Windows using Word and Excel. Thanks for posting this solution, this was driving me crazy! 1 Link to comment
MLanders 1 Posted April 19, 2017 Share Posted April 19, 2017 On 2/8/2016 at 6:58 PM, JMichaelTX said: If you have MS Word, I have found the following to work very well: copy the selected cells in Numbers or Excel Paste into Word, which creates a table, Copy Word Table Paste into EN Note I know this was over a year ago but you really helped me just now. Much appreciated 1 Link to comment
Eddychong 0 Posted May 6, 2017 Share Posted May 6, 2017 On 2/9/2016 at 10:58 AM, JMichaelTX said: If you have MS Word, I have found the following to work very well: copy the selected cells in Numbers or Excel Paste into Word, which creates a table, Copy Word Table Paste into EN Note works like a charm Link to comment
Zombeast88 0 Posted August 26, 2017 Share Posted August 26, 2017 On 2016/2/8 at 9:58 PM, JMichaelTX said: If you have MS Word, I have found the following to work very well: copy the selected cells in Numbers or Excel Paste into Word, which creates a table, Copy Word Table Paste into EN Note Just what I needed! Thanks for the post! Link to comment
frogdude 10 Posted November 12, 2017 Share Posted November 12, 2017 Just works fine now straight from Numbers on High Sierra. Copy from numbers, straight into EN. No multistep solution required. Link to comment
Level 5* DTLow 5,744 Posted December 1, 2017 Level 5* Share Posted December 1, 2017 10 minutes ago, isaac.joseph said: @frogdude Doing this gives me sort of a degenerate table that I can't actually resize, add columns to, or anything. Works for me. When I right-click on the table I see Link to comment
Damon98xp 3 Posted January 14, 2021 Share Posted January 14, 2021 在 2014/11/12 在 AM7點07分, JMichaelTX說: In EN Mac, I have found that copy/paste directly from Excel does NOT work so well. However, what does work well is to copy the cells of interest from Excel, Paste into Word, then select/copy the table from Word and paste into an Evernote Note. This gives you the opportunity to make any formatting adjustments in Word, if it is necessary. I find it's working in Copy into wordpad then cut to Evernote! Link to comment
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now