Data Import & Export

How to Import Payment Method Data and Filter Websites in Excel

Khadija KhanKhadija Khan Nov 13, 2026 868 views

Question details

The user needs to create a payment-method data table and a separate view that imports the table and filters the websites that support a selected payment method.

Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is building a website payment-method directory and wants to filter websites by each payment option.
Observed behavior
The source data is in one sheet, and the user needs an imported, filterable view on another sheet without manually copying rows.
Before you start

Make sure the source data has a single header row and no blank rows or columns, and that each payment method is recorded consistently in the same column before importing.

Solution 1Recommended

Create an Excel table and import it with Power Query

Use this when you want a live, refreshable filtered view of websites by payment method in Excel.

Power Query creates a query table that stays linked to the source data, so you can refresh the filtered view after adding or editing payment-method records.

1
Format the source data as a table

Open the Excel workbook and select the source range, including the website and payment method headers. Click Insert > Table, or press Ctrl+T, confirm the range, and click OK.

2
Load the table into Power Query

Click inside the source table, go to Data > From Table/Range, and confirm that the first row contains headers if Excel prompts you.

3
Close and load to a new worksheet

In the Power Query Editor, apply any cleanup such as removing empty columns or trimming spaces. Click Close & Load, choose Table, and select the destination sheet or a new worksheet.

4
Filter by payment method

On the loaded table, click the filter arrow in the payment-method column, clear Select All, and select the payment method you want to view. Excel displays only the websites that support it.

Filter arrows are live: The loaded table stays linked to the source table. To refresh after editing the source data, right-click the table and choose Refresh.
Free Microsoft Office alternative

Use WPS Office Spreadsheets to Manage Payment Method Data Free

WPS Office Spreadsheets is a free, lightweight alternative to Microsoft Excel. It opens .xlsx workbooks with full format compatibility and gives you familiar tables, filters, and data tools, so you can maintain payment-method lists and filter websites without an Office 365 subscription.

  1. 1. Download WPS Office: Go to WPS.com and click Download WPS Office Free to install the suite on your computer.
  2. 2. Open your workbook: Launch WPS Spreadsheets and open the .xlsx payment-method workbook you created in Excel.
  3. 3. Filter by payment method: Select the payment-method column, click Filter, and choose the payment option to display only the website rows that support it.
Filter payment-method lists with familiar table and AutoFilter controlsOpen and save .xlsx Excel workbooks without format conversionFree and lightweight Office suite with a familiar ribbon UIImport and manage data with built-in spreadsheet toolsSeamless migration from Microsoft Excel for payment tracking
microsoft office alternative - wps office

Frequently Asked Questions

Can I import the table into Power Query if my data is not already formatted as an Excel table?

Yes. Select the range and press Ctrl+T to format it as a table first, then click Data > From Table/Range. Excel will load the current range into Power Query.

How do I update the filtered list when I add new website payment methods?

Add or edit rows in the source table, then right-click the imported table and choose Refresh. The filter arrows remain applied and show the updated matching rows.

Can I filter by more than one payment method at the same time?

Yes. In the payment-method filter arrow, select multiple payment methods before clicking OK. Use Search or Text Filters to narrow the list if the column has many values.

Does this workflow work in WPS Office Spreadsheets?

WPS Office Spreadsheets opens and saves .xlsx files and provides table and filter tools. For the exact Power Query import workflow, use Microsoft Excel; for basic payment-method filtering and maintenance, WPS Spreadsheets works as a free alternative.