Advertisement

How to import data

This page explains how to import 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.

Note

Make sure you have the latest version of the GloveBox app installed on your device. Not all versions support importing data.

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 fuel and expenses 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 spreadsheet applications such as Excel or Numbers.

Each line of the CSV file can be either a fuel or 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 fuel or 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.

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: 2018-08-16
  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: You must have app version 1.5.2 or higher installed to view any notes you've imported.)

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: 2018-08-16
  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.
    (Note: You must have app version 1.5.1 or higher installed to view and manage any custom categories you've imported.)
  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.

FUEL,2017-03-01,67.57,41137,57.9,TRUE,FALSE
FUEL,2017-03-17,65.30,41619,56.93,TRUE,FALSE
FUEL,2017-04-10,62.74,42286,55.67,TRUE,TRUE,"Added fuel treatment, loyalty card expired"
EXPENSE,2017-04-12,5.00,,"Cleaning","Car wash","Wash, wax and dry. High street"
FUEL,2017-04-26,62.49,42781,54.96,TRUE,FALSE
FUEL,2017-05-09,63.20,43291,56.58,TRUE,FALSE
EXPENSE,2017-05-11,30.00,,"Tax","Road tax 2017",
FUEL,2017-05-19,67.52,43873,57.76,TRUE,FALSE
EXPENSE,2017-05-22,143.65,43159,"Servicing","Service","Oil change, new wiper blades."
FUEL,2017-06-01,65.67,44428,57.15,TRUE,FALSE

Things to note:

  • There are 10 entries in this file. Fuel entries are on lines 1, 2, 3, 5, 6, 8 and 10. Non-fuel expenses are on lines 4, 7 and 9.
  • The expense entries on lines 4 and 7 do not have an odometer value, which is optional for non-fuel expenses.
  • The expense entry on line 7 does not have any notes, which is optional for non-fuel expenses. Note that the final comma is still required to separate the title from the 'empty' notes field.
  • The text values in this sample are all surrounded with quotation marks ("). Quotation marks are optional, but are required if the text contains a comma (such as lines 4 and 9) or a quotation mark.

Contact us

If you're having problems importing fuel or expenses you can send us a message.