Formating Your Spreadsheets

Back

Organization

Your spreadsheet should be organized in a table with the first row being the header row. The header row should be labeled as follows:

  • At the farthest left, "Arena"
  • "Date"
  • "Start Time"
  • At the farthest right, "End Time"

    • Put the dates in YYYY-MM-DD format, and the start and end times in HH:MM format. The arena should be in all caps to avoid confusion.

    Creating .CSV Files from Spreadsheets

    Using Microsoft Excel:

    1. Open Microsoft Excel on your computer.
    2. Input or copy-paste the data into an Excel worksheet.
    3. Organize the data in rows and columns.
    4. Click on File → Save As.
    5. Choose the location and select CSV (Comma delimited) (*.csv) as the file format.
    6. Adjust CSV options if prompted and click Save.
    7. Verify the saved .csv file in the chosen directory.

    Using Google Sheets:

    1. Access your Google Sheets account.
    2. Input or paste the data into a Google Sheets document.
    3. Ensure the data is organized correctly.
    4. Click on File → Download → Comma-separated values (.csv, current sheet).
    5. Check your browser's download directory for the downloaded .csv file.
    6. Optionally, open the .csv file in a text editor or spreadsheet program for additional formatting.