How to import data

This page explains how to import trips, fuel and expenses into GloveBox.

First you need to get an import code from the app, then visit the GloveBox website and upload a CSV file in the correct format.

Get an import code from the app

You need an import code from the app, which is used to identify both your account and the car you'd like to add data to.

  • Log in to the GloveBox app.
  • Tap on the car you'd like to import data for.
  • Tap 'Import'. You'll be given a unique code that's valid for one hour.
  • Go to my.glovebox.mobi/import and enter the code.

You'll be prompted to upload a CSV file in the correct format.

Note

You can only import data for cars you own.

Create a CSV file

A CSV (Comma Separated Value) file is a text file where each line contains a number of values in the correct order, each one separated by a comma.

You can create a CSV file using a text editor such as Notepad or Text Edit. You can also use a spreadsheet application such as Excel, Numbers or Google Docs.

Each line of the CSV file can be either a trip, a fuel entry or a non-fuel expense and should have the following fields in the exact order below. The fields you use depend on whether the line is a trip, a fuel entry or a non-fuel expense. Even if a field is labelled as optional you still need to include the commas that separate it from the other fields.

Trip

  1. The word "TRIP" to indicate that the current line is a trip.
  2. Date of the trip in the format YYYY-MM-DD. For example: 2020-08-13
  3. Category name for the trip. *
  4. Distance. [Use the same units as the car's odometer (km/miles)]
  5. Odometer at start of trip. [Optional]
  6. Text note for the trip. * [Optional]

Note

It is currently not possible to import origin and destination locations for trips. Use the app to add locations to trips after they've been imported.

Fuel

  1. The word "FUEL" to indicate that the current line is a fuel expense.
  2. Date of the entry in the format YYYY-MM-DD. For example: 2020-08-13
  3. Total cost of the fuel. [It is not possible to import fuel entries with a cost per unit]
  4. Odometer reading.
  5. Number of units of fuel. [Uses currently selected fuel entry unit in Settings > Units]
  6. A value of "TRUE" or "FALSE" indicating whether this entry is a full tank.
  7. A value of "TRUE" or "FALSE" indicating whether entries were missed between this entry and the previous one.
  8. Text note for the fuel entry. * [Optional]

Note

It is currently not possible to import locations for fuel entries. Use the app to add locations to fuel entries after they've been imported.

Charge (electric cars and PHEV only)

  1. The word "CHARGE" to indicate that the current line is an electric charging session.
  2. Date of the entry in the format YYYY-MM-DD. For example: 2020-08-13
  3. Cost per kWh.
  4. Fixed cost (such as a connection charge or one-off service fee).
  5. Odometer reading.
  6. Number of kWh.
  7. A value of "TRUE" or "FALSE" indicating whether entries were missed between this entry and the previous one.
  8. Text note for the fuel entry. * [Optional]

Note

It is currently not possible to import locations for fuel entries. Use the app to add locations to fuel entries after they've been imported.

Expenses (non-fuel)

  1. The word "EXPENSE" to indicate that the current line is a non-fuel expense.
  2. Date of the entry in the format YYYY-MM-DD. For example: 2020-08-13
  3. Total cost of the expense.
  4. Odometer reading. [Optional]
  5. Expense category. Preset values are "Servicing", "Repairs", "Tax", "Insurance" and "Cleaning". If you specify any other value, a new category will be created.
  6. Title of the expense. *
  7. Text note for the expense. * [Optional]

Note

* Text values can optionally be wrapped in quotation marks ("). Quotation marks are required if the text value contains a comma or quotation mark. Quotation marks that are part of the text should be converted to a double quotation mark ("").

Advertisement

Example CSV file

When preparing the CSV file you may choose to add headers to the first row. In this case ensure you check the appropriate box when uploading the file so that GloveBox ignores the first line.

This is an example CSV file.

TRIP,2020-02-22,"Business 1",127.3,40298,"Travel to client site"
FUEL,2020-03-01,67.57,40566,57.9,TRUE,FALSE
TRIP,2020-02-06,Personal,16.85,39987,"Visit friends"
FUEL,2020-03-17,65.30,40854,56.93,TRUE,FALSE
FUEL,2020-04-10,62.74,40905,55.67,TRUE,TRUE,"Added fuel treatment, loyalty card expired"
TRIP,2020-04-22,"Business 1",85.3,40973,"Meting in London"
EXPENSE,2020-04-12,5.00,,"Cleaning","Car wash","Wash, wax and dry. High street"
FUEL,2020-04-26,62.49,42781,54.96,TRUE,FALSE
FUEL,2020-05-09,63.20,43291,56.58,TRUE,FALSE
CHARGE,2020-05-10,0.35,1.50,43380,18.354,FALSE,"Overnight charge to 80%"
EXPENSE,2020-05-11,30.00,,"Tax","Road tax 2020"
TRIP,2020-05-16,"Business 2",32.9,43801,"Visit to client site"
FUEL,2020-05-19,67.52,43873,57.76,TRUE,FALSE
EXPENSE,2020-05-22,143.65,44006,"Servicing","Service","Oil change, new wiper blades."
FUEL,2020-06-01,65.67,44428,57.15,TRUE,FALSE
TRIP,2020-06-08,"Business 2",73,44432,"Travel to client site"
CHARGE,2020-06-08,0.323,1.20,44499,14.542,FALSE,"Rapid charger 50 kW"

Explanation:

  • There are 17 entries in this file. Trips on lines 1, 3, 6, 12 and 16. Fuel entries are on lines 2, 4, 5, 8, 9, 13 and 15. Electric charging sessions are on lines 10 and 17 (only supported by electric and PHEV cars). Non-fuel expenses are on lines 7, 11 and 14.
  • The expense entries on lines 7 and 11 do not have an odometer value, which is optional for non-fuel expenses.
  • The expense entry on line 11 does not have any notes, which is optional for non-fuel expenses.
  • The text values in this sample are all surrounded with quotation marks (") except the note for the trip on line 3. Quotation marks are optional but are required if the text contains a comma (such as lines 5, 7 and 14) or a double quotation mark.

Contact us

If you're having problems importing trips, fuel or expenses please send us a message.