Free supplier tool / Store directory
Walmart Store Number Lookup & Map
Find Walmart stores by number, name, city, or ZIP code. Map locations, match a pasted list, and copy store addresses and coordinates into Excel.
Find Walmart store numbers and locations
How do I find a Walmart store number?
Search by city, ZIP code, or store name, then check the address in the results. Select the store number to see its address, format, status, and available coordinates. The store number identifies the location; it is separate from the store’s phone number.
Can I look up a Walmart store by its store number?
Yes. Enter the store number in the search box and choose Find stores. An optional # and leading zeros are accepted. If you have several store numbers, choose Paste a list to match them together.
How do I find Walmart stores by state or format?
Choose a state or territory to filter the map and table. Use Store format to select Supercenters, Neighborhood Markets, or Discount Stores. The map includes Alaska, Hawaii, D.C., and Puerto Rico; select a table row to inspect a location without using the map.
Can I find closed Walmart stores?
Yes, when the store is included in this directory. Search by its store number or choose Closed in the Status filter. Stores without coordinates still appear in the table and downloads.
Copy a Walmart store list to Excel
Can I copy Walmart store numbers and addresses into Excel?
Yes. Filter and sort the directory, then choose Copy for Excel. Paste the results into Excel or Google Sheets to get store numbers, addresses, ZIP codes, formats, statuses, and available coordinates. The copy includes every filtered result across all table pages. Set ZIP-code columns to text before pasting to preserve leading zeros.
Can I look up multiple Walmart store numbers at once?
Choose Paste a list and paste a store-number column from your spreadsheet. If you paste multiple columns, select the column with store numbers. Download lookup results saves a CSV; Copy for Excel copies the results as tab-separated text for your spreadsheet.
What happens to duplicate or unmatched store numbers?
Every nonblank input is matched in its original order. Lookup downloads and copied results retain duplicates and unmatched inputs. The map displays each distinct matched store once. Filters affect the map and directory table; lookup exports retain the full input list. Download unmatched inputs saves the rows that need review.
Is the lookup free, and is my pasted list private?
Yes. Search, map, list matching, and downloads are free and require no account. Pasted values stay in browser memory. Only the selected store-number column is used for matching. Clear all or close the tab to remove your list. Read our privacy notice.