How to open CSV in Excel or Google Sheets
Open your Company Finders CSV file in Excel or Google Sheets without losing phone numbers or postcodes, then sort, filter and work through the list.
Your Company Finders order page offers the list as an Excel workbook and as a CSV file. This guide is for the CSV, which is a plain text table with no colors, no formulas and no tabs, so almost any spreadsheet program can read it. To open a CSV in Excel, double-click it, or use Data, then From Text/CSV, if you want full control. In Google Sheets, use File, then Import.
What is in the file
Each row is one business, and these are the columns.
| Column | What it holds |
|---|---|
| Name | The business name |
| Category | The business type |
| Phone | The phone number on the listing |
| Address, city, region, postcode, country | Where the business is |
| Rating | The rating on Google Maps |
| Number of reviews | How many reviews the listing has |
| Website | The website on the listing, if there is one |
| Result | No website, Broken, Out of date, Loads fine or Could not check |
| What we found | What our check saw on the website |
| Date we checked the website | The day of your order |
| Email shown on the site | Only when the home page shows one |
| What the site is built with | WordPress, Wix, Squarespace, GoDaddy, Weebly, Shopify, Webflow or Duda, when we can tell |
| Whether the Google profile is claimed | Claimed by an owner, or not |
| Date the listing was last refreshed | How recent the listing details are |
| Google Maps link | Opens the listing |
| Latitude and longitude | The position on a map |
The rows come in a set order, with businesses that have no website first, then broken websites, then out-of-date websites, then the rest. Inside each group, the businesses with the most reviews come first. If you sort the sheet yourself you will lose that order, so keep a copy of the file as it arrived.
Open it in Excel
The quick way
Double-click the file, and if Excel is your default program for CSV files it opens right away. You can also start Excel, choose File, then Open, and pick the file.
Recent versions of Excel may ask whether to convert some values, such as numbers that start with a zero. If you see that question, choose not to convert.
The careful way
Use this if phone numbers or postcodes look wrong after the quick way, or if letters with accents look scrambled.
- Open a blank workbook in Excel.
- Go to the Data tab and choose From Text/CSV.
- Pick your Company Finders file.
- In the preview window, check that the delimiter is Comma. If names with accents look wrong in the preview, change File Origin to Unicode (UTF-8).
- Click Transform Data.
- Select the phone column and the postcode column, and set their data type to Text. If Excel asks, choose Replace current.
- Click Close & Load.
Menu names differ a little between versions of Excel. If yours looks different, look for "Get Data" or "From Text" on the Data tab.
Save it as a workbook
A CSV cannot keep filters, colors or column widths. Once the file is open, choose File, then Save As, save it as an Excel Workbook, and work in that copy.
Open it in Google Sheets
- Open a blank spreadsheet in Google Sheets.
- Choose File, then Import.
- Go to the Upload tab and drop your Company Finders file in.
- For import location, choose Replace spreadsheet.
- Leave the separator type on Detect automatically.
- Uncheck "Convert text to numbers, dates, and formulas".
- Click Import data.
Do not skip step 6, because it tells Sheets to leave every cell exactly as it is in the file.
Keep phone numbers and postcodes as they are
Spreadsheets like to tidy up anything that looks like a number. That can spoil two columns in a list of businesses:
- A postcode that starts with a zero can lose the zero.
- A phone number written as a long run of digits can be shown as a rounded number, or lose a leading zero or plus sign.
The fix in both programs is to bring those columns in as text. In Excel that is step 6 of the careful way, and in Google Sheets it is the box you uncheck in step 6.
If a column already looks wrong, do not try to repair it by hand. Close the sheet without saving and import the original file again.
Sort and filter
First, freeze the top row so the column names stay in view.
- Excel: View, then Freeze Panes, then Freeze Top Row.
- Google Sheets: View, then Freeze, then 1 row.
Then turn on filters.
- Excel: click any cell in the list, go to the Data tab and click Filter.
- Google Sheets: Data, then Create a filter.
A small arrow appears at the top of each column, and you can use it in a few ways:
- On the result column, select only the group you want to work on today, such as the businesses with no website.
- On the email column, hide the blanks to see only the businesses with an email address. Businesses without a website never have one in our file.
- On the "built with" column, pick one website builder if you only work in that one.
- On the claimed column, show only the profiles nobody has claimed.
For what each result means, see how we check websites. Take care with "could not check", which means the site turned our checker away, and we never call that broken.
Add your own columns
The file is yours to add to, and three extra columns turn it from a list into a work log. Add one for the date you contacted the business, one for what they said and one for the next step, and fill them in as you go. If you plan to phone, our post on a cold call opener for web designers has wording for each kind of row.
Use the Google Maps link
Every row has a link to the business on Google Maps. Open it before you contact a business, most of all for the "no website" rows, because a business can have a site it never added to its listing. Our guide to what it means if a business has no website on Google Maps shows how to check.
In Google Sheets the links are usually clickable as soon as the file is imported. In Excel they may arrive as plain text. To make one clickable in Excel, go to an empty column and type =HYPERLINK(S2), where S2 is the cell that holds the link in the file as it arrives. Change S2 if you have moved the columns, then copy the formula down the column.
If something looks wrong
- If everything is in one column, the program did not split the file on commas, so import it again and set the delimiter or separator to Comma.
- If names show odd symbols where accents should be, import it again and choose Unicode (UTF-8).
- If the number of rows looks short, check that a filter is not hiding some of them.
If you do not have a list yet, you can count the businesses with no website in your own trade and city for free on the search.
Updated 18 Nov 2026.
More guides
- A cold call opener for web designers that leads with a factStart a cold call with one true fact about the owner's website and a question. This guide has the wording for each thing our check finds.
- How to find businesses without websitesWe compare three ways to find local businesses with no website, show what one real search returned, and list four mistakes to avoid.
- How to pitch a website redesign when the site is brokenTell a local business owner their website is broken without shaming them. You get wording for each problem our check finds and the mistakes to avoid.
- How to sell websites to local businesses in seven stepsPick one trade, build a list where every business has a reason to hear from you, look before you call, and make a small, clear first offer.
- What it means if a business has no website on Google MapsThis guide explains what a Google Maps listing with no website tells you about a business, what it leaves out, and how to check before you call.
Also useful
- Find local business leads by trade, city and distanceGet a contact list for one trade near one city, with phone, address, rating, reviews and what we found on each website. The count is free.
- Web design leads with a reason for every callPick a trade and a city and we show which local businesses need a website and why. We open and check every listed site on the day you order.
- Scrap.io alternative with no monthly planScrap.io is a monthly plan for map data in 195 countries. Company Finders sells one checked list at a time, with no plan and no account.
See how many are near youChoose a trade and a city. The count is free, and you see the price before you decide whether to buy the list.