Word to Excel conversion

G

getafix33

Expert Member
Joined
Nov 16, 2006
Messages
1,805
Reaction score
87
Hi

I am trying to print labels and the only template that I can work with is in .docx format.

I have an Excel spreadsheet with data comprised of various formulas etc.

I have tried online conversion tools to convert to PDF then to Excel but no joy.

How would I create an Excel spreadsheet based on the Word template?

Here is the Tower W110 Word Template.

Thanks in advance
 
getafix33 said:
Select the spreadsheet as source. Shouldn't it be the Word doc (template) as the source?
Click to expand...
No unless I misunderstood. You open word and go into mailmerge wizard. Then select the template for your lables, Then select your data source as the excel spreadsheet and build the lable with the fields you want.

This doc I made was to merge with outlook but just select the label. - so ignore anything email-related. But the process is similar.

1758538689563.png
 
I am on my phone so wont open your link.

Not sure what you want to do. You say you have an excel with formulas and data.

And then you say you convert to pdf then to excel?
 
Here is more relevant info
1758539021157.png
1758539076951.png
Find your excel file and choose the records you want

1758539170221.png


1758539256698.png


Position the fields you want to use on one label.

When the first label is right, click update labels
1758539348977.png

1758539441172.png


I always merge to a blank document and then print that - if something goes wrong you can start at a particular point without having to do it all over again - and you don't waste labels.

Hope this helps
 
Last edited:
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X