How to Merge Excel Data into Word Template

Sending personalized letters, creating custom certificates, or printing batches of address labels can feel like an impossible task when you have hundreds of contacts. You can spend hours manually copying and pasting information from a spreadsheet, but there’s a much faster and more accurate way. This article will walk you through, step-by-step, how to merge your data directly from an Excel spreadsheet into a Word template to create personalized documents in minutes, not hours.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, Prepare Your Excel Data for a Smooth Merge

Before you even open Microsoft Word, the success of your project depends on having a clean, well-organized Excel file. Taking a few moments to prepare your spreadsheet will prevent headaches and errors down the road. This file is your "data source," and Word will read it exactly as you provide it.

Imagine you're sending a thank-you letter to event attendees. Your spreadsheet might look something like this:

Here are the key rules for setting up your data correctly:

• One Header Row: Your first row should contain the column headers (or "field names"). These headers should be simple and descriptive, like FirstName, LastName, Email, CompanyName, etc. Do not use spaces or special characters in your headers, use CamelCase (FirstName) or underscores (First_Name) instead. This header row is what you’ll use to tell Word where to put the personalized data.
• One Record per Row: Each row below the header should represent a single record - in our example, one person. All the information for one attendee should be in one row.
• No Blank Rows or Columns: Ensure there are no completely empty rows or columns within your data list. A blank row can cause Word to think it has reached the end of your data prematurely.
• Consistent Formatting: Make sure data within a column is consistent. For example, all entries in a "State" column should use the same format (e.g., "CA" instead of a mix of "CA," "Calif.," and "California").
• One Sheet, One List: Keep your recipient list on the first sheet of your Excel workbook for simplicity. While Word can pull from other sheets, using the first one is the most reliable method.

Pro Tip: Watch Out for Number Formatting

Excel loves to reformat numbers, which can cause subtle issues during a merge. Here are two common culprits:

• ZIP Codes: If you have ZIP codes that start with a zero (like those in New England), Excel will often drop the leading zero (01234 becomes 1234). To prevent this, format the entire ZIP code column as "Text" in Excel before entering the data.
• Dates and Currency: Make sure your date and currency columns are formatted correctly in Excel (e.g., using the "Date" or "Currency" format). In some cases, you may need to adjust the format in Word after the fact, but getting it right in Excel first saves time.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Set Up Your Master Document in Word

Once your Excel file is ready, it's time to create your template in Word. This is the document that contains the main text that will be the same for everyone, as well as placeholders where the personalized information will go.

Open a new blank document in Word and write the body of your letter, email, or other document. Don't worry about the personalized parts just yet. Simply type out the message, leaving gaps where you intend to insert data from your spreadsheet.

For our event attendee example, your template might look like this:

(We'll add the personalized parts like name and company in the next step.)

[Date] [FirstName] [LastName] [CompanyName] [Address] [City], [State] [ZipCode] Dear [FirstName], Thank you for attending our annual conference last week! We hope you and the team at [CompanyName] found significant value in the sessions. We specifically noticed that you attended the "[SessionAttended]" workshop and would love to hear your feedback on the content. Best regards, The Conference Team

Save this Word document. It’s now ready to be connected to your data.

How to Merge Your Excel Data: The Step-by-Step Guide

The easiest and most guided way to perform the merge is by using Word's "Step-by-Step Mail Merge Wizard." It breaks down the process into six manageable steps, ensuring you don't miss anything.

To launch it, go to the Mailings tab, click on Start Mail Merge, and select Step-by-Step Mail Merge Wizard... from the dropdown. A task pane will open on the right side of your screen.

Step 1: Select Document Type

The wizard will first ask what kind of document you're creating. For this example, we’ll choose Letters. The same principles apply to creating Emails, Labels, or Envelopes. Click "Next: Starting document" at the bottom of the pane.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 2: Starting Document

Next, you’ll choose your template. Since you’ve already typed your letter into the current document, select Use the current document. Click "Next: Select recipients."

Step 3: Select Recipients

This is where you connect your Excel spreadsheet.

1. Select Use an existing list.
2. Click the Browse... link. A window will pop up asking you to find your data file.
3. Navigate to your saved Excel file, select it, and click Open.
4. A "Select Table" dialog box will appear. Here, you'll choose the specific spreadsheet that contains your data. If your Excel file has only one sheet, it's easy. Just make sure the box for "First row of data contains column headers" is checked. This is crucial. Click OK.
5. Next, you'll see the "Mail Merge Recipients" dialog. This screen gives you a powerful overview of your data and lets you make last-minute adjustments. You can sort, filter, and even uncheck specific people you want to exclude from the mailing. Once you've reviewed the list, click OK.

Your Excel file is now connected to your Word document! You are now ready to add the placeholders. Click "Next: Write your letter."

Step 4: Write Your Letter and Insert Merge Fields

Now, let’s replace the placeholder text in your letter (like "[FirstName]") with actual "merge fields." A merge field is a direct link to a column in your Excel spreadsheet.

1. Place your cursor exactly where you want to insert the information. For example, click in the spot where the attendee’s first name should go.
2. On the Mailings tab in the ribbon, click Insert Merge Field.
3. A list of your column headers from Excel will appear (FirstName, LastName, CompanyName, etc.). Click on FirstName to insert it.

You’ll now see something like «FirstName» in your document. This odd-looking text is the merge field. Don’t worry, it will be replaced with actual names in the final step. Repeat this process for all the other personalized elements in your document («LastName», «CompanyName», «SessionAttended», etc.).

Tip: Remember to add spaces and punctuation between your merge fields where necessary, just like you would with regular text. For instance, putting a space between «FirstName» and «LastName».

Once you’ve inserted all your fields, click "Next: Preview your letters."

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 5: Preview, Preview, Preview!

This is your critical quality control step. Word will now show you what your document looks like with real data from your spreadsheet. In the Mail Merge task pane (or on the Mailings tab), you can use the arrow buttons to cycle through the recipients (Recipient 1, Recipient 2, etc.) to see how each personalized letter appears.

Check for:

• Spacing issues (e.g., forgotten spaces between the first and last name).
• Punctuation problems.
• Awkward phrasing caused by the replacement text.
• Formatting errors with dates or numbers.

If you spot an issue, you can make edits directly in the document. Simply go back to Step 4 ("Previous: Write your letter") to adjust the fields and then preview again. Better to catch mistakes now than after printing 500 copies!

Step 6: Complete the Merge

Once you are happy with the preview, click "Next: Complete the merge." You have two main options for finishing the job:

1. Print...: This option sends the merged documents directly to your printer. It's great if you are confident and just need hard copies to pop in envelopes.
2. Edit individual letters...: This is the most flexible and highly recommended option. It creates a brand new, separate Word document containing all the individual personalized letters - one for each row in your Excel file. For a list of 100 people, this new file will be 100 pages long. From here, you can make final, one-off tweaks to specific letters, save the file as a PDF, or print them. Choosing this option gives you a final chance to review everything before finalizing the output.

And that’s it! You've successfully merged your Excel data into a Word template to produce a set of custom documents at scale.

Final Thoughts

Learning to use Mail Merge is a powerful way to automate the creation of personalized documents, saving you from the tedious and error-prone process of manual data entry. By preparing your Excel data properly and following the simple steps in Word’s wizard, you can generate customized letters, certificates, and labels with just a few clicks.

This same principle of saving time and avoiding manual work is what drives modern business reporting. Exporting marketing data to spreadsheets to build weekly reports is just as inefficient as manually typing letters. For this, we built Graphed. It connects directly to your marketing and sales platforms (like Google Analytics, Shopify, Facebook Ads) and allows you to create live dashboards by simply describing what you want to see. Instead of being stuck in spreadsheets, you can get instant insights and real-time reports without the busywork.