This article describes how to prepare your fuel purchases file to make it ready for import.
Your fuel purchase file must be in Excel or CSV format. Ensure that your file has:
-
Only the text and data that is required. The first row should either be the header row or the data of the first fuel transaction. In the following example, "Vehicle Report" and "Company No. 1234" should be removed.
-
No blank cells. You can manually add data where required. In the following example, location names should be added to the blank cells in the "Location" column.
-
One fuel transaction per row
-
A maximum of 1,000 rows
Before you import your file, ensure that it has at least the following column headings:
-
Location name
-
Street
-
Date
-
Time
-
Liters purchased; OR gallons purchased
-
Price per liter or price per gallon; OR total fuel cost
-
City and State/Region; OR Postcode
The following table provides more detail about the information your fuel purchase file should contain, and how the numerical data should be formatted. Note that not all columns are required.
Table 1. Accepted date formats
|
Date format |
Example |
|---|---|
|
dd/mm/yyyy |
24/06/2023 |
|
dd-mm-yyyy |
24-06-2023 |
|
mm/dd/yyyy |
06/24/2023 |
|
yyyy/mm/dd |
2023/06/24 |
|
Street |
Required if uploading any new places, or if Place ID is not mapped. |
|
City |
Required if uploading any new places, or if Place ID is not mapped. Exception: Not required if Postal Code is mapped. |
|
State |
Required if uploading any new places, or if Place ID is not mapped. Exception: Not required if Postal Code is mapped. |
|
Postal Code |
Required if uploading any new places, or if Place ID is not mapped. Exception: Not required if City and State are mapped. |
|
Country |
Optional. |
|
Date |
Accepted formats: dd/mm/yyyy; mm/dd/yyyy; dd-mm-yyyy; yyyy-mm-dd. |
|
Time |
Accepted formats: hh:mm:ss; hh:mm; hh:mm:ss XM; hh:mm XM. |
|
Liters purchased or gallons purchased |
Format: 0,00. |
|
Price per liter or price per gallon |
Format: 0,00. Either "Price per [unit]" or "Total fuel cost" must be mapped. |
|
Total fuel cost |
Format: 0,00. Either "Price per [unit]" or "Total fuel cost" must be mapped. |
|
Product description |
Optional. |
If your file doesn’t have column headings, the Reveal labels are mapped to the column position (Column A, Column B, Column C, for example) in Step 3. Map columns of the Import Fuel Purchases wizard.
In the following example, the "Location name" label will map to Column C, and the "Street" label will map to Column D.