Entering Data Table Data via Excel (Partners)

There are two ways to enter data into data tables:

  1. Entering data online
  2. Uploading a spreadsheet containing all your rows of data (as shown on this page)

Mix and match data entry: You can use a combination of entering data online or uploading a spreadsheet. For example, you might upload a spreadsheet for the bulk of your data, and then add a couple individual rows online or edit the entered rows online. You can download a copy of the table into Excel at any time to use as a template for future uploads. Unlike Activity Reporting, Data Table rows can be entered at any time, regardless of set reporting period submission periods.

Spreadsheet Tips

Before you upload a spreadsheet containing data, here are a few quick tips to get you started:

  • Your Excel spreadsheet should have columns for every column in the data table. It can have more columns than are in the data table (the system will ignore the extras), but it should not have less.
  • While your Excel spreadsheet column headers can be anything, the import will go faster if your spreadsheet's column headers match the data table column headers.
  • One very easy way to create a spreadsheet template to use for this process is to go to the Data Table and click the Download All button on the right.
    • If you use this option, either delete or just ignore the KeyValue column.
  • Be sure your Excel spreadsheet is saved in a location that you can easily access before you begin the upload process.
  • Records uploaded from Excel will appear in the data table in the exact order they appear in the spreadsheet.

Upload Steps

1) Log into DevResults. Your website will be something.devresults.com.

  • Forgot your password? You can get a new one yourself.
  • Does the site not recognize your email? Talk to your contacts to whom you report data. DevResults staff cannot give partners access to the system.

2) When you log in, you will be taken to your Partner Dashboard. This page will show a list of activities on the top right for your organization. If the activity includes data tables, you'll see a data tables button to the left of the Activity name:

3) Click the Data Tables button for the Activity that you wish to enter data for.

4) This will open information for the Activity. The data table will display below this. You can see which data table you're entering data for by looking at the dropdown that appears just below the blue tabs. (In the screenshot, we are looking at the 20150210 Trainee Table.) Click to select the relevant data table in the dropdown menu:

5) To upload a spreadsheet with data, click the Upload Spreadsheet button to the upper right of the table.

6) Click the Choose File button.

7) Browse to the file you created earlier and select it.

8) The system will try to map the columns in your spreadsheet to the columns in the data table--if you used the same column headings, it should do this flawlessly. If you named the columns something else, it will mark them as "Do Not Import." Review the settings here to make sure they match properly.

If you used the Download All button to create a template and kept the KeyValue column, be sure to mark this as "Do Not Import."

9) If the mappings are correct, you can skip to the next step. If they aren't, simply click the dropdown arrow under the bold column and select the spreadsheet column you want entered in that column.

10) Once you've confirmed the column mappings are correct, click the Next button in the lower right-hand corner of the Upload Data pop-up:

11) You now have two options:

  • Add new rows to table will insert the rows in your spreadsheet while leaving existing data intact. Use this option if your spreadsheet only contains data collected since your last upload (periodic).
  • Clear out existing rows and uploads before importing this upload will remove all existing data so that your data table only contains the data in your spreadsheet. Use this option if your spreadsheet contains all the data you want in the data table (cumulative).

12) Select the option that suits your needs and click the Import Data button in the lower right corner.

13) Once the data is imported, you'll return to the spreadsheet view of the data table. You can now make edits to the data online and download a spreadsheet containing the entire data table.

Didn't answer your question? Please email us at help@devresults.com.