How Do I Use the ACCME Tab-delimited Spreadsheet Template for Batch Uploading?
The ACCME has developed a sample spreadsheet file template to help you understand the way in which you will need to format your data to allow the creation of a tab-delimited file.
First, we’ll open the template file. Remember, this is the file we downloaded earlier from the tab-delimited upload FAQ. As we look at the open spreadsheet, we can see that the layout of the spreadsheet matches the PARS data set requirements we reviewed earlier. You’ll notice that each column corresponds to each of the data fields we reviewed in Appendix A. Each row of the spreadsheet contains data for each separate activity being submitted to PARS. Therefore, one row equals one activity.
We’ve provided some sample activity data in this spreadsheet – so that you can see the format requirements in action. However, it’s important that you know that this template file itself is not the vehicle by which you’ll submit your activity data into PARS. For most CME tracking systems and databases, your direct export of activity data will create a new, separate spreadsheet that you’ll need to format appropriately.
If you move around in this template spreadsheet, you’ll see that we’ve introduced special behavior for some columns that provides drop down menus to select certain data entry items – like here for Activity Type. If we select “Course” from the drop down, we see that a “C” – the special format code we reviewed earlier – is displayed. If you choose to enter activity data directly into this spreadsheet, this feature may be helpful to you. However, you’ll need to copy and paste the entire spreadsheet row – including formulas – into each of the rows in which you’ll add activity data to retain this behavior. Please note that if you simply cut and paste your activity data into this sample spreadsheet, your data will not be formatted automatically.
Once again, it’s important for you to understand that this ACCME template file is only an example of the way in which your activity data will need to be formatted. You’ll need to investigate how best to get your activity data out of your CME tracking system or database such that you’ll be able to easily conform it to these specifications. Of course, as you adjust the format and layout of your data, refer to Appendix A and this sample spreadsheet template to make sure that each of the data fields, that is, the columns of your spreadsheet, are formatted correctly.