How can I import location data using regular GeoJSON or GPX standards ?

3 replies
78 views

The only type of imports are GoogleTakeout and MileIQ . How can I import my personal location tracking data using GeoJSON or GPX ?

QuickBooks Self-Employed

JoesemM

Moderator

Hello there, johenkel. You are correct that QBSE only supports Google Takeout and MileIQ imports and they don't natively support the open-source GeoJSON or GPX formats.

As your data is in a standardized format, you can convert your file into the Comma-Separated Values (CSV) format that is compatible with the QuickBooks import tool.

After you have prepared your CSV and ensured it is properly formatted, you can import your trips:

Sign in to QuickBooks Self-Employed on a web browser.
Go to the Miles menu.
Select the Add Trip ▼ dropdown. Then select Import MileIQ trips.
If you already have your mileage in a CSV file, select Browse and upload the CSV.

Then, follow steps 2-3 in the article about categorizing and tracking them in QuickBooks: Switch from MileIQ to QuickBooks Self-Employed.

If you have further questions, don’t hesitate to ask here at any time. I'm here to help.

johenkelAuthor

Thank you so much for replying.

So I can just convert GeoJSON to CSV and import that. Thank you very much, I will try it that way.

GianSeth_A1

That's right! Converting GeoJSON to CSV is an effective way to prepare data for tools that primarily handle tabular formats.

We're delighted to know that the troubleshooting recommended by my colleague, JoesemM, could help point you in the right direction.

Feel free to reach out if you run into any issues with the conversion or the import process. Have a great day ahead!

Sign up

Login with SSO

Let's get you signed in

Login with SSO