
+1
Create CSV in Excel
I'm new to Fuelio and trying to import my data from a previous app. I exported a csv from both apps and used Excel to get the data from my old app into the format Fuelio uses, however it appears the CSV Excel saves is a different format than the one Fuelio creates. Below are the examples from Excel (first) and Fuelio (2nd). Importing the one from Excel causes Fuelio to crash. Anyone know how to save the Excel data to the same format of CSV as Fuelio uses?
(Excel)
## Vehicle,,,,,,,,,,
Name,Description,DistUnit,FuelUnit,ConsumptionUnit,ImportCSVDateFormat,,,,,
Tenley's car,Description,1,1,1,yyyy-MM-dd,,,,,
## Log,,,,,,,,,,
Data,Odo (mi),Fuel (us gallons),Full,Price (optional),mpg (optional),latitude (optional),longitude (optional),City (optional),Notes (optional),Missed
2011-08-09,123875,13.219,1,3.499,,,,,,
2011-08-19,124223,11.607,1,3.499,,,,,,
(Fuelio)
"## Vehicle"
"Name","Description","DistUnit","FuelUnit","ConsumptionUnit","ImportCSVDateFormat"
"old","Description","1","1","1","yyyy-MM-dd"
"## Log"
"Data","Odo (mi)","Fuel (us gallons)","Full","Price (optional)","mpg (optional)","latitude (optional)","longitude (optional)","City (optional)","Notes (optional)","Missed"
"2011-08-09","123875","13.219,","1","3.499","0.0","0","0",,"","0"
(Excel)
## Vehicle,,,,,,,,,,
Name,Description,DistUnit,FuelUnit,ConsumptionUnit,ImportCSVDateFormat,,,,,
Tenley's car,Description,1,1,1,yyyy-MM-dd,,,,,
## Log,,,,,,,,,,
Data,Odo (mi),Fuel (us gallons),Full,Price (optional),mpg (optional),latitude (optional),longitude (optional),City (optional),Notes (optional),Missed
2011-08-09,123875,13.219,1,3.499,,,,,,
2011-08-19,124223,11.607,1,3.499,,,,,,
(Fuelio)
"## Vehicle"
"Name","Description","DistUnit","FuelUnit","ConsumptionUnit","ImportCSVDateFormat"
"old","Description","1","1","1","yyyy-MM-dd"
"## Log"
"Data","Odo (mi)","Fuel (us gallons)","Full","Price (optional)","mpg (optional)","latitude (optional)","longitude (optional)","City (optional)","Notes (optional)","Missed"
"2011-08-09","123875","13.219,","1","3.499","0.0","0","0",,"","0"
Customer support service by UserEcho
Hi, Tenley
Did you succeed in creating a fuelio csv from excel file?
Best regards,
Arlan Souza
Use sw called EmEditor and works without problems https://rsload.net/soft/editor/9992-emeditor.html