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

Editing and Importing Road Trip CSV

You can use a spreadsheet such as Microsoft Excel to edit your existing Road Trip data. This is useful if you want to make a large number of edits to your data, or if you want to merge two sets of data.

1. Editing Road Trip CSV Data

Road Trip’s CSV file contains all of your vehicle’s data and settings. The file is divided into multiple tables:

  • Fuel
  • Maintenance
  • Road Trips
  • Vehicle
  • Tire Log
  • Valuations

You are free to add, remove, or edit rows in any of the tables. Do not remove any of the tables or reorder the columns.

You do not have to add rows in any particular order. The rows will be sorted automatically by date and odometer.

When adding new data, the Flags column should always be blank. Most other columns are optional and can also be blank.

2. Save as CSV

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.

3. 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

4. Verify data format.

The importer should indicate that it has found Road Trip CSV data.

Verify that the data format is correct, then click the Import Data button.

5. Download the generated .roadtrip file.

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

6. 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