TABLE OF CONTENTS

• Use the Lifetrack Google Export function
• Google spreadsheet Reference materials

Once you have the worklist, you can export the data

Use the Lifetrack Google Export function

With the exception of the Study date and Birthdate, the exported dates in the Google spreadsheet are in UTC timezone. 


You can check the link before on how to convert the timezone

Google spreadsheet Reference materials

Some reference materials that might be helpful when working on Google spreadsheet:
- https://support.google.com/a/users/answer/9282959?hl=en

- Converting date timezone
    https://www.automateexcel.com/formulas/convert-time-zones/

- Google spreadsheet and Excel Best practice
    https://support.google.com/docs/answer/9331167?hl=en

- Create a lookup table in excel
    https://www.wallstreetmojo.com/lookup-table-in-excel/