Manual CSV Import Tutorial

Learn how to manually create and import your EV charging data

CSV Format Requirements

Your CSV file must include specific headers with data in the correct format. Use this guide to ensure your manual import is successful.

Tip: Don't want to create a CSV manually? Check our tutorials section for guides on exporting data directly from supported charging networks.
Column NameExampleFormat / Notes
charging_networkExample NetworkNetwork name (see supported networks below)
session_idEX-1234-80Unique identifier for the session
location_nameGros HomardName of the charging location
location_address229 Main St, Shediac, NB E4P 2A5Full address (optional)
charger_id506SG-532Charger identifier
energy_transferred44.22In kWh
end_state_of_charge81.2Battery percentage after charging
max_charging_rate224Maximum rate reached in kW
start_date2025-04-15 14:30:00Format: YYYY-MM-DD hh:mm:ss
end_date2025-04-15 15:30:00Format: YYYY-MM-DD hh:mm:ss
charge_duration24:59:59Format: hh:mm:ss (actual charging time)
total_duration24:59:59Format: hh:mm:ss (total session time)
grace_period_duration24:59:59Format: hh:mm:ss (free time after charging)
idle_duration24:59:59Format: hh:mm:ss (time after grace period)
base_charging_cost11.22Numeric value (e.g., 11.22)
sales_tax_cost12.12Numeric value (e.g., 12.12)
idle_cost12.12Numeric value (e.g., 12.12)
discount24.24Numeric value (e.g., 24.24)
total_cost11.22Numeric value (e.g., 11.22)
currencyCAD3-letter code (e.g., CAD, USD)

Supported Charging Networks

For best results, use one of these exact network names in your CSV:

BC Hydro
ChargePoint
EVgo
Electric Circuit
Electrify America
Electrify Canada
Flo
Journie
Petro-Canada
Shell Recharge
Unico
Note: The system will attempt to match network names even with minor typos, but using the exact name ensures the best experience.

How to Create Your CSV File

1

Use a Spreadsheet

Open your preferred spreadsheet software (LibreOffice Calc, Excel, Google Sheets, etc.) and create a new sheet with the headers exactly as listed above.

Download Template

We've created a ready-to-use Excel template with all the required columns:

Download Excel Template
Tip: Make sure to enter the column names exactly as shown in the table above.
2

Enter Your Data

Fill in each row with your charging session data following the format requirements for each column.

3

Export as CSV

Save or export the file as CSV format. Make sure the CSV uses commas as separators.

Example CSV content:

charging_network,session_id,location_name,location_address,charger_id,energy_transferred,end_state_of_charge,max_charging_rate,start_date,end_date,charge_duration,total_duration,grace_period_duration,idle_duration,base_charging_cost,sales_tax_cost,idle_cost,discount,total_cost,currency
Example Network,EX-1234-80,Gros Homard,229 Main St Shediac NB E4P 2A5,506SG-532,44.22,81.2,224,2025-04-15 14:30:00,2025-04-15 15:30:00,24:59:59,24:59:59,24:59:59,24:59:59,11.22,12.12,12.12,24.24,11.22,CAD

How to Import Your CSV

1

Navigate to Import Page

Go to /import or click on "Import" in the navigation menu.

2

Select Manual Import

Choose "Manual Import" from the available import options.

3

Upload Your CSV File

Click "Choose File" and select your CSV file or drag and drop it into the designated area.

4

Review and Submit

Review the data preview to ensure it was parsed correctly, then click "Import Data" to save your charging sessions.

Important: Each charging session must have a unique session ID. Duplicate session IDs will be rejected or may overwrite existing data.

Now What?

Add Your Vehicles

Add all the EVs you own or have driven to associate them with your charging sessions.

Go to Profile

Manage Your Sessions

Link your charging sessions with specific vehicles and road trips.

Manage Sessions

View Your Summary

See comprehensive analytics of your charging data, including costs, energy usage, and network breakdown.

View Summary

Common Issues & Solutions

CSV not recognized

Ensure your file has the correct headers and is saved as CSV with comma separators.

Data not importing correctly

Check that your date formats match YYYY-MM-DD hh:mm:ss and your durations match hh:mm:ss.

Network not recognized

Use one of the exact network names listed in the "Supported Networks" section.

Need Help?

If you encounter any issues while importing your data, please contact us for assistance.