Join for FREE
It only takes a minute!
Discover the ZEISS Digital Nature Hub

Welcome to BirdForum.
BirdForum is the net's largest birding community, dedicated to wild birds and birding, and is absolutely FREE! You are most welcome to register for an account, which allows you to take part in lively discussions in the forum, post your pictures in the gallery and more.

Excel to Word

Reply
 
Thread Tools Rate Thread
Old Thursday 19th December 2019, 11:04   #1
andyadcock
Registered User
 
andyadcock's Avatar

 
Join Date: Dec 2005
Location: UK and Occasionally St Petersburg, Russia
Posts: 18,882
Excel to Word

Can anyone tell me in idiot speak if possible, if there's a simple way to convert an Excel document to Word?


Thanks in advance
__________________
Andy A
andyadcock is offline  
Reply With Quote
Old Thursday 19th December 2019, 11:54   #2
opisska
Jan Ebr
 
opisska's Avatar

 
Join Date: Mar 2012
Location: Warszawa
Posts: 1,944
Quote:
Originally Posted by andyadcock View Post
Can anyone tell me in idiot speak if possible, if there's a simple way to convert an Excel document to Word?


Thanks in advance
Really depends on what kind of Excel document and what kind of formatting do you want to conserve - the question is quite a broad one.

A simple thing to try is to select a whole sheet in Excel (CTRL+A) and then copy it (CTRL+C) and then just paste in Word (CTRL+V) - oftentimes this produces a workable table and this conserves all formatting. However if the table is wide, this may be complicated.

The opposite extreme is that you can FILE->SAVE AS the Excel table as .CSV and choose tabulators as delimiters and then open this in Word as a text file - then you will just see the plain contents of the cells separated by tabs as free-flowing text and this then can be molded in Word as much as you wish.
__________________
Birds: world 2170, WP 565, gWP 602, bird photos | Mammals: 259, mammal photos | Herps: 104, herp photos
opisska is offline  
Reply With Quote
Old Thursday 19th December 2019, 12:13   #3
njlarsen
Opus Editor
 
njlarsen's Avatar

 
Join Date: Mar 2004
Location: St. James, Barbados
Posts: 23,809
A third way is to print to a PDF file. From adobe acrobat (or I assume from adobe online) you can export to word. With this route there will be some loss of formatting as well.

Niels
__________________
Support bird conservation in the Caribbean: BirdCaribbean

Recently moved to Barbados
njlarsen is online now  
Reply With Quote

BF Supporter 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Support BirdForum With A Donation

Old Thursday 19th December 2019, 13:03   #4
andyadcock
Registered User
 
andyadcock's Avatar

 
Join Date: Dec 2005
Location: UK and Occasionally St Petersburg, Russia
Posts: 18,882
Quote:
Originally Posted by opisska View Post
Really depends on what kind of Excel document and what kind of formatting do you want to conserve - the question is quite a broad one.

A simple thing to try is to select a whole sheet in Excel (CTRL+A) and then copy it (CTRL+C) and then just paste in Word (CTRL+V) - oftentimes this produces a workable table and this conserves all formatting. However if the table is wide, this may be complicated.

The opposite extreme is that you can FILE->SAVE AS the Excel table as .CSV and choose tabulators as delimiters and then open this in Word as a text file - then you will just see the plain contents of the cells separated by tabs as free-flowing text and this then can be molded in Word as much as you wish.
What I want to do, is transfer a bird list which is in excel, all I want are the species names, common andd scientific. This will just save me time in typing them in, all I'll do is delete stuff from the checklist we didn't see.

I tried copy and paste which transfers the text but it also carries over gridlines and all the formatting that is within the document and makes it really awkward the include any text.
__________________
Andy A
andyadcock is offline  
Reply With Quote
Old Thursday 19th December 2019, 13:07   #5
Kits
Social Media Editor
BF Supporter 2020
 
Kits's Avatar

 
Join Date: Sep 2005
Location: Hampshire
Posts: 161,715
If it is a spread sheet then you need to copy into Numbers rather than Word.
__________________
Kits

"Sail away from safe harbor. Explore. Dream. Discover." Mark Twain
Kits is online now  
Reply With Quote

BF Supporter 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Support BirdForum With A Donation

Old Thursday 19th December 2019, 13:35   #6
dantheman
Bah humbug
 
dantheman's Avatar

 
Join Date: Dec 2005
Location: Cornwall
Posts: 13,294
Blog Entries: 2
Quote:
Originally Posted by andyadcock View Post
What I want to do, is transfer a bird list which is in excel, all I want are the species names, common andd scientific. This will just save me time in typing them in, all I'll do is delete stuff from the checklist we didn't see.

I tried copy and paste which transfers the text but it also carries over gridlines and all the formatting that is within the document and makes it really awkward the include any text.
When you highlight the text you want to copy and then go to the word doc you want to transfer it to you should have 3 paste options (Keep Formatting/Merge Formatting/Keep Text Only)? Probably the last one should work best?
__________________
stithiansreservoirbirding.blogspot.co.uk/ - last update 10/11/15 - really rather remarkable still!!!
dantheman is offline  
Reply With Quote
Old Thursday 19th December 2019, 13:35   #7
King Edward
Registered User

 
Join Date: Nov 2009
Location: Herefordshire
Posts: 547
This should be straightforward. Try Paste Special: 'Unformatted Text'. You can use Find & Replace to change tabs (^t) to spaces.
King Edward is offline  
Reply With Quote
Old Thursday 19th December 2019, 13:42   #8
njlarsen
Opus Editor
 
njlarsen's Avatar

 
Join Date: Mar 2004
Location: St. James, Barbados
Posts: 23,809
Try this: select the fields in excel you want over and hit copy (Ctrl^C)
In word, if your copy is a similar age to mine, hit the down arrow below the paste button (see attachment). Of the three options that appear, select the one containing a "A" as part of the symbol, usually the right hand one.

Niels

PS: all three of us have essentially the same idea.
Attached Thumbnails
Click image for larger version

Name:	paste arrow.JPG
Views:	10
Size:	14.3 KB
ID:	712809  
__________________
Support bird conservation in the Caribbean: BirdCaribbean

Recently moved to Barbados
njlarsen is online now  
Reply With Quote

BF Supporter 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Support BirdForum With A Donation

Old Thursday 19th December 2019, 14:21   #9
andyadcock
Registered User
 
andyadcock's Avatar

 
Join Date: Dec 2005
Location: UK and Occasionally St Petersburg, Russia
Posts: 18,882
Thanks all but Jan (Oppiska) has don it for me.

My problem it seems was complicated in that my OS, Windows 7, has Libra installed. When I upgrade to W10 as I surely will have to, can I load Word in to it?
__________________
Andy A
andyadcock is offline  
Reply With Quote
Old Thursday 19th December 2019, 14:48   #10
delia todd
Moderator but....... If I say the wrong thing put it down to Senior Moments
BF Supporter 2020
 
delia todd's Avatar

 
Join Date: Dec 2004
Location: Perthshire
Posts: 271,698
Quote:
When I upgrade to W10 as I surely will have to, can I load Word in to it?
When I upgraded to W10 I was able to load Open Office, so don't see why Libra should be a problem.

Why was Libra an issue for what you wanted to do? It's a long time since I wanted to do what you did, but I was able to do it via OO (once I understood the terminology that is LOL)
__________________
In between goals is a thing called life, that has to be lived and enjoyed

My Lockdown List report - 2019 Down Under Trip Report

2006 63, 2007 52, 2008 46, 2009 32, 2010 31, 2011 27 Total 81 Last Patch tick: Magpie (locally scarce)

To live in hearts we leave behind
Is not to die - Thomas Campbell (1777–1844)


The only true wisdom is knowing you know nothing - Socrates
delia todd is online now  
Reply With Quote

BF Supporter 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Support BirdForum With A Donation

Old Thursday 19th December 2019, 16:38   #11
Lisa W
Super Moderator
BF Supporter 2020
 
Lisa W's Avatar

 
Join Date: Apr 2006
Location: RV traveling around the U.S.
Posts: 30,171
Quote:
Originally Posted by Kits View Post
If it is a spread sheet then you need to copy into Numbers rather than Word.
Kit, numbers is the Apple software “version” of Windows Excel. He wants to move data from Windows Excel to Windows Word.

The last 3 ways mentioned should work.
__________________
“Hold fast to dreams, for if dreams die, life is a broken-winged bird that cannot fly” Langston Hughes

My birding photos
Lisa W is online now  
Reply With Quote

BF Supporter 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Support BirdForum With A Donation

Old Thursday 19th December 2019, 17:42   #12
andyadcock
Registered User
 
andyadcock's Avatar

 
Join Date: Dec 2005
Location: UK and Occasionally St Petersburg, Russia
Posts: 18,882
Quote:
Originally Posted by delia todd View Post
When I upgraded to W10 I was able to load Open Office, so don't see why Libra should be a problem.

Why was Libra an issue for what you wanted to do? It's a long time since I wanted to do what you did, but I was able to do it via OO (once I understood the terminology that is LOL)
It's been a pain in many ways Delia, often, my wife would send documents that wouldn't display properly no matter what we tried, especially if they were sent from a Mac.

I save everything in the old Word format as I don't trust the newer versions with it quite frankly!
__________________
Andy A
andyadcock is offline  
Reply With Quote
Old Thursday 19th December 2019, 17:47   #13
delia todd
Moderator but....... If I say the wrong thing put it down to Senior Moments
BF Supporter 2020
 
delia todd's Avatar

 
Join Date: Dec 2004
Location: Perthshire
Posts: 271,698
Give Open Office a try then. I've been using it for years now and it works well for me.... and it's Free!!!
__________________
In between goals is a thing called life, that has to be lived and enjoyed

My Lockdown List report - 2019 Down Under Trip Report

2006 63, 2007 52, 2008 46, 2009 32, 2010 31, 2011 27 Total 81 Last Patch tick: Magpie (locally scarce)

To live in hearts we leave behind
Is not to die - Thomas Campbell (1777–1844)


The only true wisdom is knowing you know nothing - Socrates
delia todd is online now  
Reply With Quote

BF Supporter 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Support BirdForum With A Donation

Old Thursday 19th December 2019, 19:00   #14
andyadcock
Registered User
 
andyadcock's Avatar

 
Join Date: Dec 2005
Location: UK and Occasionally St Petersburg, Russia
Posts: 18,882
Thanks Delia.
__________________
Andy A
andyadcock is offline  
Reply With Quote
Old Wednesday 1st January 2020, 09:55   #15
THE_FERN
Registered User

 
Join Date: Aug 2004
Location: London
Posts: 1,545
Quote:
Originally Posted by andyadcock View Post
Thanks Delia.
Or LibreOffice as it's slightly more advanced and more regularly updated (but basically the same)
THE_FERN is online now  
Reply With Quote
Advertisement
Reply


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with excel - please !! Paul Higson Computers, Birding Software And The Internet 25 Sunday 30th September 2012 12:03
Excel Graph Arbu Computers, Birding Software And The Internet 7 Sunday 22nd June 2008 02:22
Word 2000 document to Excel 97 Spreadsheet Roy Ledgerton Computers, Birding Software And The Internet 6 Thursday 22nd March 2007 12:03
Excel help delia todd Computers, Birding Software And The Internet 6 Thursday 21st July 2005 19:55
Does anyone excel at MS Excel? Surreybirder Computers, Birding Software And The Internet 11 Saturday 3rd January 2004 19:59

{googleads}

Fatbirder's Top 1000 Birding Websites

Help support BirdForum

Page generated in 0.22544694 seconds with 28 queries
All times are GMT. The time now is 01:18.