Sheets template for. csv logs

Discussion in 'New Member Question and Answer Section' started by Cfoldone, Aug 25, 2020.

Watchers:
2 users.
  1. Cfoldone

    Cfoldone Gold Member

    Joined:
    Mar 2, 2020
    Posts:
    398
    Trophy Points:
    63
    Location:
    PacficNorthWest
    Ratings:
    +405 / -1
    Please tell me somebody who deals with csv files and Google sheets has created a "plug in" or template. I went into hardware not software and math was why!
    What I end up with has absolute units values with no ability to format units to match Baseline x axes... I see boxes and my mind goes.... Blank...
     
    Cfoldone, via a mobile device, Aug 25, 2020
    #1
  2. Rod4893

    Rod4893 Greenie Member

    Joined:
    Aug 20, 2020
    Posts:
    29
    Trophy Points:
    3
    Location:
    new jersey
    Ratings:
    +9 / -0
    If I am understanding correctly, you're saying that you can't modify (format, create pivot tables, etc.) the data tab of the CSV file? If so, it is because you need to save your logs as .xlsx (or excel file) before being able to. One you have done that, you'll be able to modify the data to fit whatever graph you need. Apologies if that wasn't what you were asking for.

    P.S. if anyone has examples of graphs they look at with their data logs, I can create templates for you. I am highly adept in MS Excel but would need graphs to reference.
     
    • Like Like x 1
  3. Cfoldone

    Cfoldone Gold Member

    Joined:
    Mar 2, 2020
    Posts:
    398
    Trophy Points:
    63
    Location:
    PacficNorthWest
    Ratings:
    +405 / -1
    Thank you for the advice...Sadly VersaTune uses their proprietary file format or CSV to export... maybe I'll find a conversation table somewhere...thank you. May take your offer if something shows up...
     
    Cfoldone, via a mobile device, Aug 25, 2020
    #3
  4. Rod4893

    Rod4893 Greenie Member

    Joined:
    Aug 20, 2020
    Posts:
    29
    Trophy Points:
    3
    Location:
    new jersey
    Ratings:
    +9 / -0
    Nah bro, you literally need to export the csv first, save it, open it and then SAVE AS. When you save as, change file type to .xlsx.

    AP also exports in csv... i convert to .xlsx before checking/manipulating.
     
    Rod4893, via a mobile device, Aug 25, 2020
    #4
    • Like Like x 1
  5. Cfoldone

    Cfoldone Gold Member

    Joined:
    Mar 2, 2020
    Posts:
    398
    Trophy Points:
    63
    Location:
    PacficNorthWest
    Ratings:
    +405 / -1
    Went the easy way used app and selected some options... Thanks! Screenshot_20200825-225249.png Screenshot_20200825-225255.png
     
    Cfoldone, via a mobile device, Aug 26, 2020
    #5
Loading...

Share This Page

Users Viewing Thread (Users: 0, Guests: 0)