FlowsBook a callSign inCreate free accountSign up
Business and places data

How to export a business list to a spreadsheet

A CSV from the email, a row in Google Sheets for every new business, a file in Drive each run or a live feed for Excel: which export fits which job.

Part of the guide Location intelligence automation

By the xMap team · · 6 min read

There are four ways to get a list of businesses from xMap Flows into a spreadsheet, and the right one depends on how often you need it and who works in the file. For a one-off, download the CSV linked in the run's email or from Results. For a sheet the team edits every day, let each new business become a row in Google Sheets. For a dated copy of every run, save a CSV to Google Drive, or have a scheduled export emailed each week or month. For a report that refreshes itself in Excel or a BI tool, connect a live feed.

This article is for anyone who ends up in a spreadsheet anyway: sales operations preparing a CRM import, analysts building a pivot, marketers cleaning a mailing list, managers who want a file they can sort. It explains each route, what the file contains, how to keep columns tidy and how to avoid the usual export headaches.

Which export fits which job

You wantUseHow it arrives
One list, nowThe CSV link in the email, or ResultsA file you download and open
A shared sheet that growsThe Google Sheets app, a row per itemNew rows appear after each run
A dated file for every runThe Google Drive app, a CSV each runA file named after the flow and the date
Figures that refresh in Excel or a BI toolA live feed from ResultsA link Excel reads with From Web

The four routes from a flow's results to a spreadsheet.

The quickest route: the CSV in the email

When a flow's Email block sends one email per run, the email shows the first places and carries a button to download every item as a CSV. The link works for 30 days. The file holds every field the run gathered, not just the few shown in the email: name, address, city, phone, website, rating, number of reviews, category, position and, when an AI block scored the places, the score and its reason.

The same list lives on in Results, where every real run keeps what reached the end of the flow. Filter it by flow, city or kind and download it there when you need a fresh copy weeks later.

A sheet the team works in: a row per business

When people sort, comment and colour cells in the same sheet every day, a download each time is a chore. Add a Google Sheets step at the end of the flow instead. Connect the app, choose Create a new spreadsheet (it is made in your Drive with a header row of the fields your flow sends) or paste the link of an existing sheet, and set it to add a row for each item.

Each column is filled from a field of the item, written as {{name}}, {{phone}} or {{website}}. You choose which fields go in and in what order, so the sheet stays as narrow as you want. When a row is added under a sheet formatted as a table, it takes the table's look; otherwise it copies the format of the row above.

Put Only new before the Sheets step and the sheet only grows by businesses it has not had before. Without it, a daily flow writes the same places every morning.

A file for every run in Google Drive

Some teams want a record: what the flow found on each date, kept as separate files for audit or for comparing months. The Google Drive app's Create File from Text action, left empty, saves the results as a CSV named after the flow and the date. Point it at a folder by link or by name, and Drive collects one file per run.

A list that refreshes itself in Excel

For a dashboard that should never be exported by hand, use a live feed. On Results, Live feed makes a private address for a flow, a saved view or all results, as CSV or JSON. In Excel, Data, From Web, paste the address and refresh whenever you like; Power BI reads it the same way, and Looker Studio through Google Sheets. Stop the feed at any time and the address stops answering.

A worked example

Here is a made-up case. A company that services commercial coffee machines in Singapore wants its two sales reps to work from one shared sheet of cafes and bakeries in Google Sheets, and its finance lead wants a monthly file for the board pack.

  1. A flow runs every Monday: Area of interest Singapore, Nearby places with cafe and bakery types, Filter for places that are open.
  2. Only new keeps the businesses not seen before.
  3. Google Sheets adds a row per business with name, type, rating, phone, website and a map link, plus an empty column the reps fill with their notes.
  4. In the flow's Alerts and exports, a monthly export sends the finance lead a CSV link of the month's new results.
  5. The finance lead opens the monthly file in Excel and pastes the totals into the board pack.

In this example nobody exports anything by hand, and the reps' sheet never repeats a business.

Export mistakes to avoid

  • Opening a CSV by double-click and re-saving it. Spreadsheet programs can strip leading zeros from phone numbers and postcodes. Import the file and set those columns to text, or keep working in the Sheets copy.
  • Exporting every field to a sheet people read. Forty columns hide the six that matter. Send only the fields the team uses to Sheets, and keep the full CSV for analysis.
  • Sorting a live sheet while the flow writes to it. New rows go at the bottom of the table; sort in a filtered view so you do not shuffle what the reps are working on.
  • Forgetting duplicates. The same business can appear under two names or in two searches. A Remove duplicates step before the export keeps one of each.
  • Treating the export as the master list. If the sheet is edited by hand and the flow also writes to it, decide which columns belong to people and which to the flow.

Let an AI employee do the exporting

Any of these routes can be the last step of an AI employee that runs on its own. A common one: Schedule each weekday morning, Area of interest, Nearby places, Only new, Remove duplicates, then a Google Sheets row per business and an Email saying how many were added, with its CSV link. The New businesses routed by size template sends key accounts to Slack and the rest to a sheet, and Score new leads from a sheet template works the other way round, starting from rows your team adds.

Questions

Can I export to Excel directly?

Yes. The CSV from the email or Results opens in Excel, and a live feed lets Excel refresh the list itself through Data, From Web.

How long does the CSV link in the email work?

30 days. After that, download the same results again from Results.

Will the sheet fill up with the same businesses every day?

Not if Only new comes before the Google Sheets step: it lets through only businesses the flow has not found before.

Does it work with Microsoft Excel online?

Excel reads the CSV and the live feed. The Google Sheets step writes only to Google Sheets.

Can I choose which columns go into the sheet?

Yes. Each column is filled from a field you pick, such as {{name}} or {{phone}}, so the sheet holds only what the team uses.

Templates that do this

Read next

More on business and places data · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.