Road Trip
for iPhone, iPad, and Mac
HomeFeaturesScreenshotsSupportUser ManualCSV Data Import Tool
User Manual > Import CSV

Importing from a Spreadsheet

The Road Trip CSV Importer allows you to import fuel and expense data from a spreadsheet such as Microsoft Excel, Apple Numbers, and Google Sheets. The importer is flexible and allows you to configure the contents of each column of data.

Requirements

  • All vehicle data must be contained within a single table. If your data contains both fuel and service/expense data then your table must contain a Type column to identify a row as fuel, service, or expense.
  • The rows do not need to be in any particular order. The data will be sorted automatically by date and odometer.
  • The minimum required fuel columns are: Date, Odometer, Fill Amount, Price per unit. These columns must be present even your data only contains expense records.
  • The data is always imported as a new separate vehicle without affecting your existing data or vehicles.

Column Names

The importer allows you configure the contents of each column of data. To make things easier, it will try to guess each column type based on the column titles. If you use column names that the importer recognizes then it will make things easier.

More information: Column Name and Types

1. Save as CSV

You can use a spreadsheet to edit the data you wish to import. When you are finished editing, you will need to save your data in CSV format.

Microsoft Excel

  1. Go to File > Save As.
  2. The Save As dialog box appears.
  3. In the Save as type box, choose CSV (Comma delimited).
  4. Save the CSV file to your desired location.

Apple Numbers

  1. From the main menu, choose File > Export To > CSV…
  2. In the Export Settings window, click Save..
  3. Save the CSV file to your desired location.

Google Sheets

  1. Click File in the top-left corner.
  2. Hover over Download.
  3. Select Comma Separated Values (.csv)
  4. Save the CSV file to your desired location.

2. Load your CSV files into the Road Trip importer.

Use the Road Trip CSV Importer to import your CSV file.

  • Click Choose File and choose the CSV file from your spreadsheet.
  • Click Next

3. Review the column types.

Choose your preferred units for your vehicle, then review the column types.

Each column contains a popup menu that allows you to specify the contents of each column. Check that all of your columns are set to the correct column type.

Once the column types have been set, click the Import Data button.

4. Download the generated .roadtrip file.

The importer will generate a .roadtrip file that contains your data. Click the Download button to download this file.

5. Send the .roadtrip file to your iOS device.

Once you have downloaded your data you can send the file to your iOS device by email, or by simply copying the file to your iCloud Drive.

Email

Send the .roadtrip file to your iOS device as an email file attachment. On your iOS device, tap the file attachment and choose Road Trip from the share menu.

iCloud Drive

Copy the .roadtrip file into a folder in your iCloud Drive. On your iOS device, use the Files app to locate the file. Tap on the file to open with Road Trip.

Help

If you have any trouble using the importer please contact us and we’ll be happy to help out. You can also send us your data and we’ll import it for you. Email: support@darrensoft.ca