Spreadsheet Import Documentation
Do you love programming in Excel / Google Sheets? Well, we do too. So we have created a way for you to upload your xlsx files directly to Wodfollow. Allow us to import your programming for you!
If you have programming in your spreadsheet that looks like the image below, you're going to love this new feature.
There are 4 main things you need to get right on each spreadsheet
'Segments' needs to be in the top left cell (A1) of the spreadsheet
This allows us to verify that your sheet is intended to be imported to Wodfollow. It's a sort of litmus test we first look at
Segment Names need to be in column A below the 'Segments' cell
These will be used as the titles for each item when we display the programming for the athlete
Proper dates displayed along the top in the format 'YYYY-MM-DD'
Weeks are Sunday - Saturday. If these dates do not coincide with the week the spreadsheet is uploaded to then we will alert you of the problems. As long as these match up everyone is happy and the import will be successful.
Format of the file must be .xlsx
Once you have your spreadsheet all set, head over to the Spreadsheet import page
1) Visit the Spreadsheet Import page
Here you can view the spreadsheets already imported for the previous, current and 6 future weeks.
Additionally, you can choose to export spreadsheets for programming you imported from weeks prior. Didn't enter that programming with a spreadsheet? No problem, we will create that for you.
2) Click on the appropriate week
You can either select a specific track OR you can upload a spreadsheet that has programming for *each* track on separate sheets (sheets must contain the exact name of the track).
If you want to upload a single sheet with all programming for each track, your sheet names should be named EXACTLY identical to your track names
4) Apply the programming
Once the programming looks like you want, just click the "Import / Re-Import Data" button. Your programming for that week will be brought into Wodfollow.
Careful, if you have already imported programming for that week, clicking this button will overwrite all that programming with what you see in the preview area.