Memo 4: CSV Data Upload for Crosswalk K-12


Save yourself the headache of needing to re-upload CSV data files for students onto Crosswalk K-12 by doing it right the first time! By the end of reading this blog, you will surely know how.

What is a CSV file?

When we say CSV file, we mean a “comma-separated values.” What this entails is a plain text file containing lists of data separated by commas or spreadsheet. So, for Town Transit users, we’re dealing with students’ addresses, bus assignments, pick-up and drop-off times, etc. Below is an example of how to set-up a CSV file using programs like Microsoft Excel or Google Sheets. Download an example here as well.

Example of CSV file

Why is the CSV data upload important?

Preliminary data plays an integral role in the early on-boarding stages with UniteGPS, especially when it comes to assigning students to bus routes in relation to their home. Addresses uploaded into the system will appear in places like User Locations.

User Locations example

The sooner you upload student data onto the system, the sooner your team can strategically start creating routes and bus stops. In all seriousness, this data is what fuels users’ experience on Crosswalk K-12. There are a few caveats to remember here, though, the first being this: only one CSV file can be uploaded at a time. 

For example, let’s say that you have a school district of 2,000 students and you’re trying to load their data onto the system. In the past, customers have attempted to upload student data in increments, such as 1,500 hundred on one list and 500 on the other. This is where blunders happen since the system only accepts the latest upload, meaning one at a time. 

So, in this situation, Crosswalk K-12 would only record the most recent batch, meaning the previous data will be erased. Hopefully, this blog will prevent that from ever happening!

Leave a Reply