Data Import & Export

How to Extract Unique Street Names from Excel to Word

Tauseeq Magsi Oct 15, 2026 868 views

Question details

The user wants to extract a list of unique street names from an Excel spreadsheet and copy the filtered results into a Word document.

How to Extract Unique Street Names from Excel and Copy to Word

Product: Excel, Word
Device & OS: not provided
Scenario: Extracting specific unique text entries from a large dataset in Excel to use in a Word document report or list.
Observed behavior: The user needs a clean, deduplicated list of specific values from an Excel column transferred accurately into a Word document without manually picking out the values.

Before you start

Ensure your Excel dataset has clear column headers and no blank rows to make filtering and extracting data more accurate.

Solution 1Recommended

Use the UNIQUE Formula to Extract a Distinct List

If you need to quickly remove duplicates and get a distinct list of names, the UNIQUE function is highly efficient.

The UNIQUE function automatically evaluates an array of data and returns a spilled list of completely unique values. This method is the fastest if you are using a modern version of Excel that supports dynamic arrays.

Enter the UNIQUE function

Select an empty cell in a new column and type =UNIQUE(A3:A186), replacing the range with the actual cells containing your street names.

Generate the unique list

Press Enter. Excel will automatically spill the list of unique street names down the column.

Copy the results

Select the newly generated list of unique street names, right-click, and choose Copy (or press Ctrl+C).

Paste into Word

Open your Word document, right-click where you want the list to appear, and choose 'Keep Text Only' under the Paste Options to paste a clean list.

Use the UNIQUE Formula to Extract a Distinct List

Version Requirement: The UNIQUE function is only available in newer versions of Excel (Microsoft 365, Excel 2021, or equivalent). If you are using an older version, try the Filter or PivotTable methods below.

Solution 2

Use Excel Filter to Extract Specific Data

The easiest method for extracting specific rows based on criteria is using the built-in Filter tool.

Solution 3

Use a PivotTable to Consolidate Unique Names

A PivotTable automatically groups identical entries, providing a clean list of unique values without using formulas.

Manage Data Efficiently with WPS Office

Extract and Manage Unique Data Easily in WPS Spreadsheet

WPS Office provides seamless data processing capabilities. You can easily filter, deduplicate, and copy unique values from WPS Spreadsheet directly into WPS Writer without formatting issues or data loss.

1. Open your dataset in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the street names.
2. Remove duplicates directly: Select the column of street names, navigate to the Data tab, and click on 'Remove Duplicates'. Confirm the selection to instantly narrow your list down to unique values.
3. Copy the deduplicated list: Highlight the remaining unique names, right-click, and select Copy.
4. Paste into WPS Writer: Open a new or existing document in WPS Writer and press Ctrl+V to paste your clean list of unique street names.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsBuilt-in advanced filtering and fast duplicate removal toolsLightweight, fast, and completely free to useSeamless clipboard integration between Spreadsheet and Writer

microsoft office alternative - wps office

Frequently Asked Questions

How do I copy filtered Excel data to Word without including hidden rows?

Usually, Excel only copies visible cells when a filter is applied. However, if hidden rows are accidentally copied, select your filtered data in Excel, press Alt + ; (semicolon) to select only the visible cells, then copy and paste into Word.

Can I link the Excel list to Word so it updates automatically?

Yes. Copy the list of unique street names in Excel, go to Word, and select 'Paste Special' from the Home tab. Choose 'Paste Link' and select 'Unformatted Text'. Any updates to the list in Excel will now automatically reflect in your Word document.

Why isn't the UNIQUE function working in my spreadsheet?

The UNIQUE function relies on dynamic arrays, which are only supported in modern spreadsheet versions (like Microsoft 365, Excel 2021, and the latest versions of WPS Office). If it shows a #NAME? error, use the Data > Remove Duplicates feature or a PivotTable instead.

Is it possible to automate this extraction process?

Yes, if you perform this task frequently, you can record or write a VBA macro. A macro can be programmed to automatically filter unique values, open a new Word document, and paste the results. Be sure to save your file as a Macro-Enabled Workbook (.xlsm).

Excel & Data Problems