---
title: "Preparing Excel and Word Templates for Data Merge"
description: "Overview. Wheelhouse can merge data into Microsoft Word and Excel templates, creating professional documents with current information from your database. The merged file can be exported to PDF or kep…"
url: "https://support.wheelhousemfg.com/article/z0tccr7xr5-preparing-excel-and-word-templates-for-data-merge"
category: "Reports, Import, Exports, and Document Templates"
updated_at: "2025-07-16T23:39:07Z"
---

# Preparing Excel and Word Templates for Data Merge

### Overview

Wheelhouse can merge data into Microsoft Word and Excel templates, creating professional documents with current information from your database. The merged file can be exported to PDF or kept in its original format.

**Recommended Reading:** Refer to the [How to Modify Document Templates](https://support.wheelhousemfg.com/article/lyoks5fzxr-how-to-modify-document-templates) to learn about editing existing templates before creating your own!

### Prerequisites

Before creating templates, ensure you have:

- **Access Requirements**: DocumentManager role or higher
- **Software**: Microsoft Word (preferred) or Excel (free web versions available at Office.com)
- **Navigation Access**: Verify you can see **Data Administration > Files > Template Documents**

Wheelhouse can merge data into Microsoft Excel and Microsoft Word templates. The merged file can be exported to PDF or kept in its original format.

### Creating a Template

#### 1. Set Up the Document Structure

**For Word Templates (Recommended):**

1. Set up proper page layout and margins for your intended output
2. Consider table formatting for structured data presentation
3. Use consistent styles and formatting throughout
4. Plan document flow for optimal readability

**For Excel Templates:**

1. Set appropriate page width and margins for paper output
2. Avoid merged cells when using text wrapping or AutoFit Row Height
   
   ![](https://files.helpdocs.io/u2psp4t8yl/articles/z0tccr7xr5/1752708364595/image.png)
3. Use single rows for cells that need to auto-resize
4. Enable text wrapping where needed

#### 2. Prepare the Layout

**Option A: Start from Scratch**

1. Create your document design in Word (recommended) or Excel
2. Set up headers, footers, and basic structure
3. Plan where dynamic data will be inserted

**Option A: Use existing templates or copy from a Global Template**

1. Navigate to **Data Administration > Files > Template Documents** to view the available templates
2. Refer to the [How to Modify Document Templates](https://support.wheelhousemfg.com/article/lyoks5fzxr-how-to-modify-document-templates) to learn about editing existing templates.

#### 3. Add Template Fields

**Replace Static Content with Field Placeholders:**

1. In your Word document, replace static content with `${field_name}` placeholders
   
   ![](https://files.helpdocs.io/u2psp4t8yl/articles/z0tccr7xr5/1752708694400/image.png)
2. Use exact field names from the available field reference

#### 4. Upload the Template

1. Navigate to **Data Administration > Files > Template Documents**
2. Upload your document by:
   
   - Clicking the upload button and selecting your file, or
   - Dragging your document file into the upload area
3. Add descriptive keywords to help identify the template's purpose
4. Set the file purpose and file type to connect the document with system functionality
5. Save the template record

#### 5. Test the Template

1. Generate a test document using real data from Wheelhouse
2. Verify all field names populate correctly
3. Check formatting and layout with actual data
4. Make adjustments as needed and re-upload

### Troubleshooting

#### Word-Specific Issues (Recommended Platform)

**Tables Splitting Across Pages:**

- **Table Properties**: Uncheck "Allow row to break across pages"
  
  ![](https://files.helpdocs.io/u2psp4t8yl/articles/z0tccr7xr5/1752709069564/image.png)
- **Paragraph Properties**: Check "Keep lines together"
  
  ![](https://files.helpdocs.io/u2psp4t8yl/articles/z0tccr7xr5/1752709082510/image.png)
- Use **Paragraph "Keep with Next"** setting for related content
  
  ![](https://files.helpdocs.io/u2psp4t8yl/articles/z0tccr7xr5/1752709096308/image.png)

**Text Formatting:**

- Use consistent styles for better appearance
- Test with varying lengths of data
- Consider using tables for structured data layout
- Use Word's built-in styles for consistency

**Page Layout Issues:**

- Check margin settings for proper spacing
- Verify header/footer positioning
- Test print preview before finalizing

#### Excel-Specific Issues

**AutoFit Height Not Working:**

- Verify AutoFit is enabled for the cell
- Ensure text wrapping is enabled for the cell
- Confirm cells are either single rows or not merged
- Test by exporting to Excel first (before PDF) to verify data insertion

**General Excel Formatting:**

- Use consistent row heights where possible
- Avoid complex merged cell structures
- Test with longer text strings to ensure proper wrapping

#### Field and Data Issues

**Missing or Incorrect Field Data:**

- Verify field names match exactly with available field reference
- Ensure proper syntax with `${ }` wrapper
- Check that the field is available for your specific document type
- Test with known good data to isolate the issue

**Data Not Displaying:**

- Confirm the field name exists in the field reference
- Verify no extra spaces or characters in field names
- Check that the document type supports the requested field

### Best Practices

1. **Start Simple**: Begin with basic templates and add complexity gradually
2. **Test Frequently**: Check formatting and data population at each step
3. **Keep Backups**: Save working versions before making major changes
4. **Use Consistent Naming**: Follow organizational standards for template names
5. **Document Your Work**: Keep notes about field names and formatting choices
6. **Plan for Data Variation**: Consider how the template handles different data lengths
7. **Test with Real Data**: Always test with actual records from your system

### Additional Resources

- Review existing templates in your system for field usage examples
- Use the field reference tool to discover new available fields
- Contact Wheelhouse Support for advanced template requirements

[Go to Article: How to Modify Document Templates](/article/lyoks5fzxr-how-to-modify-document-templates)