Skip to content

Import and Export Sites ​

Quick Answer ​

Open Import / Export in the left sidebar to download this project's sites as an Excel or CSV file, or to bring sites in from a file in any layout. An import has six steps: Upload, Columns, Clean up, Fix values, Review changes and Import. You see exactly what will change before anything is saved, the save is all or nothing, and you can undo an import for 7 days. A file can be up to 64 MB, 50,000 rows and 500 columns.


Getting There ​

  1. Open the left sidebar.
  2. Under the Locate product group, click Import / Export (icon: arrows pointing up and down).
  3. The tab opens in the workspace panel with two cards: Import sites and Export sites.

Import / Export is turned on company by company. If you don't see it in the sidebar, it may not be on for your company yet: contact your customer success manager or the SiteZeus support chat. Where it is on, the entry appears only if your role includes Import (view). What you can do in the tab depends on your role:

You can…You need
Open the tab and see importsImport (view)
Export sitesImport (edit)
Import sitesImport (add)
Undo an import (see Undo)You ran the import, or Import (add) and Projects (edit); and the Delete rights for what it added

A card you can't use is greyed out and says why. Ask your administrator if you need access.

Starting from an empty project ​

A project with no sites yet shows This project has no sites yet in its Sites tab. If your role includes Import (view) and Import (add), and Import / Export is on for your company, that screen has an Import sites button next to Search a place and Add a site. It opens the same import dialog as the Import sites button on the Import / Export tab, on this project.


Export Sites ​

The Export sites card downloads this project's sites as one file that you can edit in Excel and import back.

  1. Tick the kinds of site to export: Existing sites, Proposed sites and Layer sites. Each shows how many there are (layer sites as "50 in 4 layers"). Pick at least one kind.
  2. Choose the file type: Excel or CSV.
  3. Click Download.

Only sites and values you can see are included. If your access is limited to a territory or a franchise, the file holds only those sites.

What is in the file ​

Each row is a site. The columns are:

ColumnHolds
ExternalIdYour own ID for the site (the Site ID), such as a store number
NameThe site's name
Latitude, LongitudeThe site's coordinates
Address, Address2Street address, and the suite, unit or floor
City, State, PostalCity, state or province, and ZIP or postal code (kept as text, so leading zeros stay)
CountryCountry
Revenue:<type>One column per revenue type. Existing sites only
Attribute:<type>One column per site attribute
LayerBlank for an existing site, *BOLT* for a proposed site, or the layer's name
LayerRevenueA layer site's revenue
SiteTypeThe site type, such as mature or approved
OwnerThe franchise group that owns the site. Only if your company has a franchise contract

The "About this file" sheet ​

An Excel export has two sheets. Sites is the table. About this file is a short guide: the project, when the file was made, how many sites of each kind it holds (a kind you left out reads "Not included"), how to use the file, and what each column holds. The importer reads the Sites sheet, so keep it as the table. A CSV export has the Sites table only.

Keep the column names as they are, so the file imports back with nothing to match by hand.

The blank template ​

Blank template, next to Download, gives you a file with the column headings and no sites. Use it to start a list from scratch. It has the same two sheets in Excel. Its name ends in -template, so it never looks like the file of a real export.


Import Sites ​

Click Import sites… on the Import card. The import dialog shows the six steps along the top. You can go back to any step you have passed. Nothing is saved until the last step, and your own file is never changed.

Step 1: Upload ​

  1. Drop an Excel or CSV file on the dialog, or click Choose file: .xlsx, .csv, .tsv or .txt, up to 64 MB and 50,000 rows. Any column names, in any order.
  2. If the workbook has more than one sheet, check the Sheet. The first sheet that holds a table is chosen for you; pick another if your sites are elsewhere.
  3. Check Column names are on. Title rows above the headings are skipped for you; change the row if it guessed wrong.
  4. Under What's in this file?, say whether the rows are Our existing sites, Proposed sites, Sites for a layer (then pick the layer, or name a new one), or A mix (the file has a Layer column), like an export. A kind you aren't allowed to add is greyed out with the reason.
  5. Under What should the import do?, choose Add and update, Update only or Add only.

A row updates a site when it has the same Site ID, or the same address. With Update only, a row that isn't in the project is skipped. With Add only, a row that is already in the project is skipped. Sites that aren't in the file stay as they are.

Step 2: Columns ​

The Columns step shows each column of your file, a few sample values, what it Imports as, and How it was matched: Same name, Known name, Same words in another order, Saved from your last import or Your choice.

  • Columns that were matched on their own count under matched.
  • Columns that need you show buttons: the closest field as a suggestion, New attribute, and Don't import, plus a list of every field. Pick one for each.
  • Don't import the unmatched columns leaves out every column that still needs a choice.
  • Free text, such as a Notes column, can only be left out.
  • A column you turn into a New attribute (or a new revenue type) is added to the project. The step warns you where it will show: on every site, in filters, scorecards and reports. It needs your Edit attributes permission, and the button then reads Create 1 attribute and continue.

Step 3: Clean up ​

The Clean up step fixes the small things that usually go wrong in a spreadsheet, in the columns you are importing. It shows how many cells were cleaned and gives examples as before → after. Each fix has Undo (and Redo). Your file isn't modified.

It cleans up:

  • invisible characters (non-breaking and zero-width spaces), extra spaces and line breaks inside cells
  • curly quotes and long dashes, and letters stored in different ways
  • money and numbers written as text ($1,250,000, 2,300 sq ft)
  • yes/no answers (Y, yes), matched to the project's own wording
  • the spelling of existing categories (strip center becomes Strip Center)
  • ZIP codes that lost their leading zero (2134 becomes 02134)

Valid characters stay: accents, &, # and apostrophes are never removed. A cell that starts with = is kept as text and never run as a formula.

A few fixes could change real data, so they ask first:

  • Repair garbled accents (Café to Café): Repair or Keep as is.
  • Treat placeholders as blank (N/A, TBD, -, null, or an Excel error such as #N/A): Make blank or Keep as text. Left as text, a placeholder in a number column would fail the next step.
  • How is "1.250" written?: tells the importer whether a point or a comma is the decimal mark.

Continue turns on once every question is answered.

Step 4: Fix values ​

Fix values lists every problem found in the values of your file, as cards. A card is one kind of problem in one column, with each different value as an item under it. The badge says whether it is an Error, Needs a decision or Resolved. The header counts the problems that are left, and All, Need a decision and Errors filter the cards.

Check against project turns on when every error is fixed or skipped and every decision is made.

For each item, pick an answer. The answer the importer suggests comes first and has a wand icon. You can also type a value in place and click Use. A card with several items has an All at once row to give them all the same answer. Every answer is checked again at once: if it causes a new problem, the item says so.

Errors ​

An error stops the import until you fix it, or skip the row.

CardWhat to do
Name is blankType a name, or Skip this row
Rows have no address and no coordinatesType the coordinates, or type the one part of the address that is missing, or skip. Without coordinates, Locate needs the address, city, state and postal code to place a site
Text is too longShorten to N characters (a name only), Type another, or skip
A number isn't a number, is negative, is over 10 billionType a number, Leave blank, or skip
Latitude or Longitude is out of rangeUse the corrected value (297.41 becomes 29.741), Type the coordinates, or skip
Site ID is on more than one rowType a new Site ID for a row, or Skip it. Site IDs are compared exactly, so FS-0412 and fs-0412 are two sites, and an existing and a proposed site may share one
Address is on more than one rowType a unit in Address 2 or Change the address for a row, or Skip it. Each site needs its own address
Existing sites share a pinType the coordinates for a row, Find it from the address, or Skip it
A value of a category attribute can't be a numberLeave blank, or skip. A category value is a label, such as Inline
Layer sites can't have a value for an attribute, or a Site IDLeave blank, or skip. Only existing and proposed sites have them
Country isn't this project's country (a row with no coordinates)Leave blank, so the project's country is used, or skip

Decisions ​

A decision doesn't stop the import, but it needs your answer.

CardYour answers
Rows are outside this project's country, or at 0, 0Use swapped coordinates, Find it from the address, Keep these coordinates, or skip
A value is far outside this project's rangeUse the likely value (245000 becomes 2,450), Keep it, Type a number, or skip
A number is blankLeave blank, Fill with project average, Fill with project median, or Fill with a value I type. A site that already has a value keeps it, whatever you pick. When the project's figures take in sites you can't see, the average and median show no number and can't be picked, and the card says why
Values aren't in this project yet (a new category value)Use an existing label, Add the new value, or Leave blank
Site types aren't valid for this kind of siteUse a valid site type from the list, or Leave blank
Owners aren't a franchise of this companyUse one of the company's franchises, or Use "Corporate"
Rows look like the same placeKeep both, or skip one

Download with problems (Excel) gives you the rows with a Problems column. When there are many to fix, fix them in Excel and click Upload fixed file: your choices are kept. Save it as an Excel file and keep the sheet's name, so the importer leaves its own Problems column out.

Step 5: Review changes ​

Click Check against project. The check runs on the server in four phases: sending the file, finding locations for rows without coordinates, matching against this project's sites, and working out what will change. It is only a check: nothing is saved. You can close the dialog with Run in background; the Import card shows when the review is ready, even after a reload or on another device.

When it is ready, five tiles show what will happen. Click a tile to open its list:

TileWhat it counts
Will be addedNew sites, with where they go on the map
Will be updatedSites that change, with every value before and after and how many values change
Need a decisionRows the importer can't settle by itself (below). Import stays off until each is decided
No changeRows already up to date
SkippedRows left out, with the reason: you skipped them, or the import only adds or only updates sites

A value the importer fills from the project (a blank number you chose to fill) is marked (filled). A site that moves shows "Moves 80 m on the map." If the import adds attributes, revenue types, layers or category values, This project also changes lists them.

Download summary saves an Excel file with every change and every skipped row.

Decisions on the review ​

DecisionWhat it meansYour answers
Possible duplicateA row with no Site ID is at the same place as a site already in the project, with a similar name. For example, "Row 14 has no Site ID, and is 12 m from Fresh Slice #0388"Update that site, Add as a new site, or Skip
Location not exactThe address wasn't found exactly. The closest match is shownUse the closest match, or Skip
Location not foundThe address wasn't found. Fix it in your file and import againSkip
No accessThe row matches a site outside your territory or franchise. You can't see it and the import can't change itSkip

If a site changed since your check (someone edited it meanwhile), the review says "N sites changed since your check" and nothing is saved. Click Check again to check the same file again. A check older than 24 hours expires and must be run again.

Step 6: Import ​

Click Import N sites. The import saves every site in one go: all or nothing. If anything goes wrong, no site is changed. After the save, layer statistics refresh and drive times start.

When it is done, the dialog says how many sites were added and updated, and that the rows you skipped are listed in the summary (Download summary). The project's sites refresh on the map in place.

Your forecasting model isn't rebuilt automatically. When you're ready, rebuild it from Forecasting Model and review the result before accepting it. See Forecasting Model: Settings.

If the save fails, the dialog says The import didn't go through. Nothing in the project changed. It shows the import id (give it to support if you ask for help) and Try again, which saves the same reviewed changes without a new check.


The Import Card ​

The Import card shows where the project's last import stands:

BadgeMeaning
CheckingThe check is running. Review when ready reopens it
Ready for reviewThe check is done. Review changes reopens it
ImportingThe save is running
ImportedSaved. Shows who ran it and how many sites were added and updated
Undoing, UndoneAn undo is running, or finished
Didn't go throughNothing changed. Open and try again reopens it, when the save can be retried
ExpiredThe check was not imported within 24 hours

Only one import runs in a project at a time, whoever started it. While one is running, Import sites… is off and says so.


Limits ​

LimitValue
File size64 MB
Rows50,000
Columns500
A check stays ready24 hours
An import can be undone7 days

A file over a limit is refused with a message when you choose it. Split it into smaller files, or remove the columns you don't need, and try again. Excel (.xlsx) and text (.csv, .tsv, .txt) files are read; a workbook that is damaged or password-protected can't be opened.


Undo an Import ​

An import can be undone for 7 days. On the Import card, the last import shows the amber Undo this import button, with "You can undo this import until" and the last day above it. Only the project's last import is on the card, so it is the one you can undo.

Who can undo: the person who ran the import, or anyone with both Import (add) and Projects (edit). Undoing removes what the import added, so you also need the Delete rights for it: to delete existing sites, proposed sites, or layers and layer sites. If you aren't allowed, the button isn't shown; if your rights changed since the card loaded, the card says what you may not delete.

  1. Click Undo this import.
  2. The confirmation, Undo this import?, names the file and when it was imported, and lists what will happen: how many values, in how many sites, are put back as they were before the import, how many sites the import added will be removed, and which attributes, revenue types, layers or category values the import created (they go with it unless something else uses them now).
  3. Click Undo this import to confirm. The card shows Undoing while it runs.

When it is done, a message says Import undone, and the card says what the undo did, for example "12 sites removed, 1 site put back as they were." An added site that someone had already deleted is not counted. The last import shows Undone and the date, and the map refreshes. Someone who opens the tab later sees Undone and the date.

Sites edited after the import ​

Undoing would overwrite an edit made to a site after the import, so the undo looks for those sites as it runs. If it finds any, it stops with nothing undone, and the import stays as it was. A window opens, Some sites changed after the import, that lists them ("3 sites were edited after this import"), by name where the map has the site, otherwise by number ("Site 98,213"). Sites you can't see, such as sites outside your territory, are counted but not named ("…and 2 other sites you can't see"). Choose:

  • Undo everything else undoes the rest of the import and leaves those sites as they are, the ones you can't see too. When it is done, the card says that everything else was put back and how many of the edited sites you can see were left as they are.
  • Keep the import changes nothing.

Until you choose, the card says "3 sites were edited after this import. Nothing was undone." with Choose what to do, which opens the same choice. Anyone who opens the tab later, or on another device, sees the same note.

If the undo doesn't go through ​

The card says why. When the undo is refused or fails, nothing in the project changes. When the answer is lost on the way back, the undo may or may not have gone through: Check again says which.

  • Try again sends the undo again, after asking you to confirm. After a failed Undo everything else, it opens the choice about the edited sites again.
  • "We couldn't confirm whether the undo went through": the answer was lost on the way back, and the undo isn't sent again by itself. Click Check again to see where it stands.
  • "This import can no longer be undone": the 7 days are over, and undo is no longer offered.
  • "This import can't be undone now": it is already being undone, or was undone, in another window. The card then shows that undo.

Troubleshooting ​

  • I don't see Import / Export in the sidebar. It may not be on for your company yet (ask your customer success manager), or your role doesn't include Import (view) (ask your administrator).
  • Import sites… is greyed out. Either you lack Import (add), or another import is running in this project. Wait for it to finish.
  • A kind of site is greyed out on Upload. Your role can't add that kind. The reason is shown under it.
  • My file was refused. Check it against Limits. Remove blank rows below your data, and save a password-protected workbook without the password.
  • Check against project is off. Fix or skip every error and answer every decision. The footer says how many are left.
  • Import N sites is off. A row on the review still needs a decision.
  • The review says sites changed since my check. Click Check again.
  • The import didn't go through. Nothing changed. Click Try again, or send support the import id shown.
  • Undo this import isn't on the card. The 7 days are over, a newer import is now the last one, or your role can't undo it (see Undo an Import).
  • The undo says sites were edited after this import. Nothing was undone. Click Choose what to do, then Undo everything else or Keep the import.

SiteZeus Location Intelligence Platform — powered by Zeus.ai