Company Finders

Guides

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.

  1. Open a blank workbook in Excel.
  2. Go to the Data tab and choose From Text/CSV.
  3. Pick your Company Finders file.
  4. 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).
  5. Click Transform Data.
  6. Select the phone column and the postcode column, and set their data type to Text. If Excel asks, choose Replace current.
  7. 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

  1. Open a blank spreadsheet in Google Sheets.
  2. Choose File, then Import.
  3. Go to the Upload tab and drop your Company Finders file in.
  4. For import location, choose Replace spreadsheet.
  5. Leave the separator type on Detect automatically.
  6. Uncheck "Convert text to numbers, dates, and formulas".
  7. 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.

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

Also useful

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.