Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel file that I want to split into several files (Word, PDF is also good), based on content. The content is somewhat like this:

Person  Fase  Date       Item  Text
A       1     01-01-2012 Z     Lorem ipsum
A       2     01-02-2012 X     Lorem ipsum
B       1     02-01-2012 Y     Lorem ipsum
C       2     01-01-2012 Z     Lorem ipsum

I want Word/PDF documents with names like

Person_Fase.docx

And as content the date, item and text. Idealy in a table layout. Any hints/ clues on how to get there? It's about 700 clients, with up to 300 Excel entries each.

share|improve this question
add comment

2 Answers 2

I'm not sure but you can use open office. After opening the xls file with open office, Click the export under the Menu then export it as pdf or docx.

share|improve this answer
    
Then how do I make a file per person/fase? I am aware of the save as option ;-) –  Lennart Nov 26 '12 at 20:15
add comment

There is an Add-In for Microsoft Word which performs this exact function using a Mail Merge.

Go to http://www.gmayor.com/individual_merge_letters.htm, read the instructions carefully and download the zip file of templates.

Install the template for the version of Word that you have. I have used this in Word 2010, but it looks like other versions are also supported.

In your Excel spreadsheet, create a new column with your desired filename. For example =A2&"="&B2 if Person were in column A and Fase was in column B.

In Word, create a new document using the new template.

Then start a Mail Merge using your Excel spreadsheet as a data source.

Format the doument as you wish, probably by inserting a table with five columns and two rows. In the first row put your column headers and in the second row insert the Merge Fields.

Click Split the Merge and go through the wizard to select the records, choose the filename, and set your path.

This saves each record/row in a separate Word document, using the filename and path you set.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.