Uploading or Importing Time Tracking Entries From a File / Spreadsheet

If you have time entries stored in a spreadsheet (for example, if you and your team have tracked your time spent on working on an Event), you can upload that data to the Time Tracking tool in an Event using a .CSV file.

To convert your spreadsheet to a .CSV file:

  • In Excel - Go to File > Save As; in the "File Format" dropdown, select the "Comma Separated Values (.csv)" option; click "Save".
  • In Google Sheets/Drive - Go to File > Download As; select the "Comma-separated values (.csv, current sheet)" option.

To Upload or Import Data in the Time Tracking Tool

  1. Click on the "Time Tracking" tool button on the Event Dashboard - OR - use the Quick Launch or Switch Event tool to select the appropriate Event and the "Time Tracking" tool.
  2. Click on the "Import .CSV" button.
  3. Click on the "Choose File" button to select the .CSV file from your computer.
  4. Click on the "Start Import Process" button.
  5. Match the fields from your file to the available fields in Planning Pod (Description of Entry, Date, Hours, Billed?). When you are done, click the "Continue to Next Step" button.
    • NOTE: If your file does not have a header row, make sure the "Imported file has column headers?" checkbox IS NOT checked.
  6. Review the data on the page. If there are any fields that can be edited, double-check them to ensure they contain valid information and edit them if necessary. If the information is not in a valid format, you will not be able to submit it until it has been fixed.
    • NOTE: If the information here looks incorrect, you may need to go back and re-match fields, or you may need to fix your original .csv file and re-try this process.
  7. Once all fields are correct, click the "Looks Good - Import Now" button. Your information will be uploaded momentarily.

Once your data is uploaded, you can edit it and add additional information.

Have more questions? Submit a request

0 Comments

Article is closed for comments.