- 2,884
- Near Reading, Uk
- JohnSchoonsBeard
@JohnScoonsBeard how do we use spreadsheet in pcars dash?
From the tuning screen select the option icon and then export to CSV (comma seperated values) then import that into your spreadsheet column a. Then you can split that column across the page using a formula I'll post shortly.
This is the Formula in a Google sheets/Google Drive spreadsheet
=SPLIT(location of data row eg A2 ,",")
Therefore in my spreadsheet
=SPLIT(A2,",")
Copy for each row of data
It may be a different formula in Microsoft Excel.
@Football67611 sorry mate I can't make tonight. I've been given a load of jobs by the Missus. I'm hiding in the loo to write this. Shhhhh
Last edited: