How to manually import footfall data

This guide explains how to prepare a CSV file, map the columns correctly, and import footfall data manually into Vemcount.

Before importing, prepare the CSV so the data is clean and easy to map. The simplest files are usually the most reliable: keep the date/time field consistent, keep In and Out in separate columns, and avoid mixing labels with numeric values in the same cell.

CSV file examples

The official guide distinguishes between a perfect example, a usable example, and a problematic example.

A perfect example

The table is clean, the time format is clear, and Count In and Count Out each have their own numeric column.

A good example

This file can still be used because it contains the date plus separate In and Out values, even though it does not include a time column.

If no time is supplied, Vemcount inserts the imported data at 12:00:00 for that date.

A bad example

This structure is difficult to map because cells are missing and text is mixed with numbers in the same fields.

Column mapping

During mapping, the Date/Time field uses PHP time format notation. Common examples from the official article are shown below with updated 2026 values.

Column mapping follows an A-Z sequence similar to Excel. If your source file uses separate Date and Time columns, merge them before mapping the Date/Time field.

How to manually import the data

1. Prepare the CSV file and make sure the structure is clean and consistent.

2. Open Manage and select Footfall Data.

3. Click Import CSV and upload the CSV file.

4. Select the correct location.

5. Skip the data template if you do not use one.

6. Choose the correct CSV format under Advanced options.

7. Map the Date/Time, In, and Out columns correctly.

8. Click Import Data. Vemcount opens a status page where you can refresh the view and follow the import process.