Reports generated from MileIQ can be exported in the CSV format and then imported into any spreadsheet program. In this video, learn how to open CSV files in Microsoft Excel and Google Sheets.
- [Instructor] Previously, we looked at how to generate … a report from the MileIQ mobile app, … and we saw that you'll receive an email like this one … with links to CSV and PDF versions of your report. … We took a look at the PDF option already, … so now let's see how to work with the CSV version. … Let's check out All Drives CSV. … So that's downloaded a CSV file to my computer, … which we can see here. … Now, CSV stands for character-separated values. … It's basically data in which a specific character … is used to separate or delimit the data. … In this case, … MileIQ uses commas as the character that separates the data. … I can show you this. … Now, by default on my computer, … Microsoft Excel will open this file if I double-click it, … but let me just show you this in a simple text editor first. … So what we're looking at here is the raw data … from my drives in this report. … Now, obviously it's not very usable like this, … but you should be able to see the commas … that are being used to delimit the data here, …
- Tracking drives
- Classifying and auto-classifying drives
- Viewing data in the MileIQ dashboard
- Generating reports from the mobile app and web dashboard