How to make a searchable database from your spreadsheet: 3 ways
Make a searchable database from a spreadsheet in Excel, Google Sheets or an app. Copy the formulas, then print a record or put it on your website.
Turn your spreadsheet into an app
Upload an Excel or CSV file. Free, no account needed.
On this page
To make a searchable database from a spreadsheet, put your records in a clean table, one record per row with a heading on every column, then add a search box. In Excel or Google Sheets, you build the box with one formula on its own tab. For several people, a phone or your website, turn the sheet into an app.
This guide is for the owner or office manager with a big spreadsheet who wants to type a name, find the record and print it. It builds the same customer search three ways, then covers putting records on a website and printing.
How we researched this: in November 2026 we checked every function, menu name and limit below on Microsoft’s, Google’s and Airtable’s own help pages, and the upload facts on GoodTaco’s own pages. Steps are for Excel for Microsoft 365 on Windows and Google Sheets in a browser on a computer; other versions can label things differently.
What is a searchable database, and what are the ways to make one from a spreadsheet?
A searchable database is a list with one record per row and a box that finds records by what you type. Your spreadsheet already has the list. What’s missing is the box, and there are three ways to add it.
The picture is an example, not your data. It shows a sheet before and after someone tidies it; a search box can’t do that for you.
| Way | It fits when |
|---|---|
| Find on the page (Ctrl+F) | You jump to a name now and then. It lists cells, not whole records. |
| A search box in Excel | It’s mostly you, or one shared workbook. Needs Excel for Microsoft 365, 2021 or 2024. |
| A search tab in Google Sheets | A few people share one live sheet in a browser, and you trust them to edit. |
| A searchable app | More people, a phone, customers, or some who should only look. |
Ctrl+F (Command+F on a Mac) is the plainest way. In Excel, Find All lists every cell that has your word (Find). But it lists cells, not whole records, and there’s nothing to print.
If you’d rather skip the formulas, upload your file on our spreadsheet to app page for a searchable app, with no account needed to try. If it holds customer details, read who can see an app (below) before you upload.
How do you get a spreadsheet ready to search?
A search finds what’s written, so it’s only as good as the list. Tidying is the slow part, and it’s yours to do. Check these first:
- One record per row. A customer, a part or a job takes one row. No blank rows, merged cells or title above the headings.
- One heading per column, in the first row. Name, Phone, City. Don’t tuck the city into Notes, or you can’t sort or filter by city.
- One style in each column. A search for “rosa alvarez” finds “Rosa Alvarez” but not “Alvarez, Rosa”. Pick one way to write names, and one for phone numbers. In Excel, Flash Fill (Data > Flash Fill) can split or join names from an example you type once (Flash Fill).
- An ID on every record. A short code such as LC-7201. Names repeat; IDs don’t.
- Real dates. Type Oct 14, 2026 as a date, not “mowed last Tues”.
On a big sheet, tidy one column at a time, and try the search on a small copy first.
The examples use ten customers of a lawn care company: columns A to D of the Customers sheet. Columns E and F hold Service and Last visit.
| ID | Name | City | Phone |
|---|---|---|---|
| LC-7201 | Rosa Alvarez | Salem | (555) 010-4417 |
| LC-7202 | Tom Alvarado | Dayton | (555) 010-3361 |
| LC-7203 | Nadia Rahman | Salem | (555) 010-5820 |
| LC-7204 | Greg Hollis | Dayton | (555) 010-2679 |
| LC-7205 | Linda Kowalczyk | Albany | (555) 010-6034 |
| LC-7206 | Marcus Webb | Salem | (555) 010-7752 |
| LC-7207 | Grace Lindqvist | Albany | (555) 010-8198 |
| LC-7208 | Carlos Mendes | Dayton | (555) 010-9043 |
| LC-7209 | Hannah Brooks | Albany | (555) 010-1127 |
| LC-7210 | Sam Whitfield | Salem | (555) 010-2284 |
How do you make a searchable database in Excel?
You have two choices. The filter buttons work in every version. The Search sheet is the better box: it searches several columns at once.
Search with the filter buttons
- Click a cell in your list, choose Home > Format as Table and tick “My table has headers” (create and format tables).
- On the Table Design tab, type Customers in the Table Name box (name a table).
- Click the arrow on the Name heading, type alva in the Search box and press Enter (filter with the Search box). Excel shows only the rows that match.
This searches one column at a time, and the other rows stay hidden until you clear the filter. For one-click buttons on a column of choices such as City, choose Insert > Slicer (slicers).
Add a search box with a formula
The formula uses FILTER. Microsoft lists it for Excel for Microsoft 365, 2021 and 2024, on Windows and Mac, and doesn’t list Excel 2019 or earlier. To check yours, choose File > Account (or Help) and read Product Information (which version). On an older version, use the filter buttons.
- Add a sheet and call it Search. Keep it apart from the list: Microsoft says results that spill into neighboring cells can’t sit inside a table (dynamic arrays).
- In A1 type Search for. B1 is the box you’ll type in.
- In row 3, type the same headings as the Customers table: ID, Name, City, Phone, Service, Last visit.
- In A4, enter this formula:
=IF($B$1="", "Type a name, phone or city in B1", FILTER(Customers, ISNUMBER(SEARCH($B$1, Customers[Name]&" "&Customers[Phone]&" "&Customers[City])), "No matches"))
- Type alva in B1 and press Enter. Rosa Alvarez and Tom Alvarado fill in below.
Using your own headings. Name, Phone and City are this list’s headings, and Customers is the table’s name. Swap in yours. The easy way: delete a name from the formula, then click that column in your table, and Excel types it for you (structured references). If Excel refuses the formula or shows an error, a name doesn’t match.
Read the formula from the inside out. It joins each customer’s name, phone and city into one line, looks for what you typed in that line, and keeps the customers where it finds it. Because it looks inside the line, alva finds both Alvarez and Alvarado, salem finds everyone in Salem, and 4417 finds a phone number. Microsoft explains SEARCH and FILTER if you want the detail.
A few things to watch:
- A #SPILL! error. The results need free cells below and to the right of A4. If you see #SPILL!, clear what’s in the way (fix a #SPILL! error).
- Dates and phone numbers. If Last visit shows as a number, format those cells as dates. Keep phone numbers in one style, as text.
- New customers. Type a new customer in the row under the table, and the table grows to include them (add rows to a table).
- A shared workbook. Everyone types into the same B1, so when Dee starts a new search, your results change too. Make a copy of the Search sheet for each person. To stop anyone overwriting the formula, unlock B1 (select it, press Ctrl+1, clear Locked on the Protection tab), then choose Review > Protect Sheet. Microsoft says this isn’t a security feature (protect a worksheet).
To link a list of jobs to this list of customers, see our guide to using Excel as a database.
How do you make a searchable database in Google Sheets?
The layout is the same: a Customers tab with headings in row 1, and a Search tab with the box in B1, the headings in row 3 and the formula in A4. Sheets can name tables too, but this formula uses column letters, so it works either way (table references). In Customers, A holds the ID, B the name, C the city and D the phone.
=IF($B$1="", "Type a name, phone or city in B1", IFERROR(FILTER(Customers!A2:F, ISNUMBER(SEARCH($B$1, Customers!B2:B&" "&Customers!C2:C&" "&Customers!D2:D))), "No matches"))
It works like the Excel one. Swap B, C and D for your own columns. A2:F and B2:B have no end row, so new customers are included. IFERROR shows No matches, because Google’s FILTER gives #N/A when nothing matches (FILTER). If Last visit shows as a number, format those cells as dates.
QUERY is the other common choice. Put it in A3 instead, and skip typing the headings. It sorts the matches and lists everyone when the box is empty, but it checks one column (B, the name), shows only the headings when nothing matches, and breaks if someone types an apostrophe. Its contains is case-sensitive, so both sides are lowercased (Google’s query language).
=QUERY(Customers!A1:F, "select * where B is not null and lower(B) contains '"&LOWER($B$1)&"' order by B", 1)
Sharing is where Sheets differs most:
- A quick search needs no formula. Choose Data > Create a filter, click the filter icon in the Name heading and type in the Search box. Everyone with the sheet sees that filter, so on a shared sheet use a filter view (Data > Create filter view) instead. If you can only view the sheet, Google lets you make a temporary filter view that only you see (sort and filter).
- One search cell, and edit access. Everyone types into the same B1, so one person’s new search changes what the others see: make a Search tab for each person. Anyone who types in B1 can edit the sheet, so choose Data > Protect sheets and ranges, restrict Customers to you, and protect Search except B1. Google says protection isn’t a security measure, because people can still copy and print the data (protect sheets).
For more on running records out of Sheets, see how to use Google Sheets as a database.
How do you turn a spreadsheet into a searchable app?
An app suits you when more people need to search, some should only look, or you search from a phone. With GoodTaco, you ask for the search and print pages you want, and it builds them from your file:
- Upload the file. Use an Excel file (.xlsx or .xlsm) or a CSV (comma-separated) file; no account is needed to try. Start with one part, such as one year or one branch, and see it work.
- Say what you want, if you like. The form has an optional box for what the app should do.
- Open the link we email you. The first version takes minutes and is built around what you asked for.
- Keep it. Create a free account to keep the app.
- Change it and share it. Tell GoodTaco what to change, in plain words, such as “search across every column” or “a form to add a customer.” Every version is saved, so you can go back. Share it by link; people open it in any browser, including a phone’s.
A description like this is enough for step 2:
Let me search customers by name, phone or city, open one to see everything, and print a customer sheet.
This example shows a request after you’ve kept the app: you ask, and GoodTaco builds the search and the print sheet.
GoodTaco imports each sheet into the app’s own built-in database as records, turns columns of repeated choices, such as City or Service, into dropdowns, and rebuilds the formulas it can reproduce exactly.
Two things to know before you commit:
- Who can see your customers. Once you publish, anyone with the link can open the app, unless you make it private so only the people you invite can sign in. For names and phone numbers, make it private.
- The app becomes the home of your records. To keep working in a Google Sheet, connect it with the Google Sheets app builder instead, and the app reads and writes the same sheet.
Other tools build apps too. Airtable’s Interface Designer builds shareable interfaces on data you keep in Airtable. Softr builds portals and internal tools with a database and permissions built in. Knack builds no-code database apps, with templates such as a customer portal.
Can you make a searchable database for a website?
Yes, but your website needs somewhere to hold the records and a page that searches them. People do it three ways:
- Publish the sheet. In Google Sheets, File > Share > Publish to web gives you a link or an embed code for a version visitors can’t edit (publish to web). It’s a table: visitors can’t type into your search box, only use their browser’s find, and everything in the published tabs is open to anyone with the link.
- Embed a view from an online database. Airtable, for one, gives a shared view an embed code (an iframe) for a page that accepts custom HTML or an embed block, such as Squarespace, Wix, Webflow or a self-hosted WordPress site. Airtable calls it a live, read-only copy and doesn’t say visitors get a search box, so test it on a draft page first (Airtable embeds).
- Link to an app. Publish your GoodTaco app with its public link and put a button on your site that opens it. You choose which columns visitors see. If only members should see the records, make the app private so people sign in first.
A public app is open to anyone with the link, including any screen that adds or changes records. Ask GoodTaco for look-only pages, and leave out anything you wouldn’t print on a flyer:
Visitors can search and read, but not add or change anything.
How do you print one record, or a report, from a searchable database?
Finding the record is half the job. You can print one record on its own sheet, or a whole report.
Print one record from Excel or Sheets
- Add a sheet called Record. In A3 to A7, type the field names: Name, City, Phone, Service, Last visit.
- In B1, type a customer’s ID, such as LC-7202. You’ll find it in the first column of your Search sheet.
- In B3 to B7, enter these formulas. Each looks up the ID in your list and brings back one field. Format B7 as a date.
| Cell | Type this in Excel |
|---|---|
| B3 | =XLOOKUP($B$1, Customers[ID], Customers[Name], "Not found") |
| B4 | =XLOOKUP($B$1, Customers[ID], Customers[City], "Not found") |
| B5 | =XLOOKUP($B$1, Customers[ID], Customers[Phone], "Not found") |
| B6 | =XLOOKUP($B$1, Customers[ID], Customers[Service], "Not found") |
| B7 | =XLOOKUP($B$1, Customers[ID], Customers[Last visit], "Not found") |
- Select A1 to B7. In Excel, choose Page Layout > Print Area > Set Print Area (print area). In Google Sheets, choose File > Print > Selected cells (print from Sheets). Then print.
XLOOKUP isn’t in Excel 2019 or earlier (XLOOKUP). Google Sheets has it, with columns by letter, such as =XLOOKUP($B$1, Customers!A:A, Customers!B:B, "Not found") for the name (XLOOKUP in Sheets).
Print a report
- In Excel, select the results and set the print area as above. Set it again if a new search returns more rows.
- For a long list, set Width to 1 page and Height to Automatic under Scale to Fit (scale a worksheet).
- On the Customers sheet, choose Page Layout > Print Titles and type $1:$1 in Rows to repeat at top, so the headings repeat on every page (print titles).
In Google Sheets, freeze row 1, then choose File > Print > Headers & footers > Repeat frozen rows. In an app, ask for a one-page customer sheet or a report page, then print from your browser:
Add a report page of customers by city, laid out for printing.
Which way should you choose?
Stay in a spreadsheet while it’s you, or a few people you trust. Our guide to the difference between a database and a spreadsheet covers the rest.
Excel, five people, thousands of records? Use a table with the filter buttons today. It needs nothing new. If people overwrite each other’s searches, or you want a print button, upload one part of the list, such as one year or one branch, and see it work first.
Move to an app when:
- some people should only look (ask GoodTaco to let only certain people add or change records);
- you search from a phone, where a wide grid is hard to use;
- customers or the public need to search; or
- each person should see only some of the records.
If you’re weighing tools, see our guide to database software for small business. For a customer list in particular, see our guide to customer database software.
Make your spreadsheet searchable with GoodTaco
Upload the customer list above and say what you want: search by name, phone or city, a page for each customer, a form to add new ones, a sheet to print. In minutes you have a first version to try, with your records in a built-in database. Your team opens it in any browser, including a phone’s. You change it by telling GoodTaco what to change, in plain words, and every version is saved so you can go back. Share it by link, or make it private so people sign in first. If your records live in a Google Sheet, GoodTaco can read and write that sheet live instead.
GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.
Bring your spreadsheet, and give your team a box that finds the record. Start free, no credit card needed.
Frequently asked questions
How do I make a searchable database in Excel?
Put your list in an Excel table with a heading on every column, then add a Search sheet. Type what you're looking for in B1, and use a FILTER formula with ISNUMBER and SEARCH in A4 to list the rows that contain it, with your own table and heading names. FILTER needs Excel for Microsoft 365, Excel 2021 or Excel 2024. In older versions, use the Search box in a heading's filter button.
How do I make a searchable database in Google Sheets?
Keep the records on one tab with headings in row 1, add a Search tab, type your search in B1, and use a FILTER formula with ISNUMBER and SEARCH in A4. Wrap it in IFERROR, because FILTER returns #N/A when nothing matches. For a quick search without formulas, choose Data > Create a filter and type in the Search box. People who can only view the sheet can make a temporary filter view.
How do I turn an Excel spreadsheet into a searchable database?
Tidy the list first: one record per row, one heading per column and one style in each column. Then either add a Search sheet with a formula, or upload the file on GoodTaco's spreadsheet to app page. It needs no account to try. With a large sheet, start with one part and see it work, and tidy names and phone numbers first.
How do I make an Excel spreadsheet searchable without formulas?
Format the list as a table with Home > Format as Table. Each heading gets a filter button, and its Search box lets you type text to find. It searches one column at a time. Slicers, from Insert > Slicer, add one-click buttons for choices such as city or status.
Does the FILTER function work in older versions of Excel?
No. Microsoft lists FILTER for Excel for Microsoft 365, Excel 2021 and Excel 2024, and doesn't list Excel 2019 or earlier. In those versions, use the Search box in a table's filter button instead.
How do I make a searchable database for a website?
A website needs somewhere to keep the records and a page that searches them. You can publish a Google Sheet to the web, which shows visitors a table they can't edit, embed a shared view from an online database such as Airtable on a page that accepts embed code, or publish an app and link to it from your site. A public app is open to anyone with the link, so only put in records you'd be happy for anyone to read, and ask GoodTaco for look-only pages so visitors can't add or change records.
How do I print one record from a searchable spreadsheet?
Make a Record sheet: type an ID in B1, fill the cells below it with XLOOKUP formulas that look that ID up in your list, then print just that area. XLOOKUP needs Excel for Microsoft 365, 2021 or 2024. In Excel, use Page Layout > Print Area > Set Print Area. In Google Sheets, select the cells and choose File > Print > Selected cells.
Turn your spreadsheet into an app
Upload an Excel or CSV file and we’ll build an app around your records, with its own database. Free, no account needed.
Upload a spreadsheetNo file handy? Start from a template