~ 4 MIN READ
ClearPoint Data Loader: The Easiest Way To Add Or Update Data
Read how the ClearPoint Data Loader saves hours of time by moving information from your local files into ClearPoint, automatically and lightning quick.
How much time do you spend on data entry? For many people, the answer is always “too much.” We built the ClearPoint Data Loader to eliminate as many hours of data entry as possible—this tool automatically adds or updates data in ClearPoint, so you don’t have to copy and paste information from one file to another. The Data Loader is simple to use and fast...you won’t know how you lived without it.
How The ClearPoint Data Loader Works
The Data Loader is a local application, which means it’s installed and lives on your desktop computer. It could also be installed on a virtual machine or central server.
Once installed, the Data Loader can pull files in any format (Excel, CSV, SQL, etc.) from any directory you choose. That data can be grabbed and uploaded to ClearPoint in three ways:
- Real Time: The Data Loader can “watch” for edits to files you’ve designated and automatically upload new data to ClearPoint when it’s changed. This happens in real time and on autopilot...it couldn’t be easier to get fresh information into your account.
- Scheduled: The Data Loader can pull new data at regular time intervals, such as weekly or monthly.
- Manual: You can manually run the Data Loader to pull new information whenever you want, or to setup your scorecards and add new elements.
When you pull a file, the Data Loader will map each column or row header to a field in ClearPoint. The mapping happens automatically based on the text in columns, rows, and fields, but users will confirm the mappings are correct. The Data Loader also flags any invalid or undetermined mappings so users can define how the data should be assigned and fill in any blanks. The Data Loader will remember the mappings and your next information upload will happen automatically without the need for manual adjustments.
Formatting Files For The ClearPoint Data Loader
As far as formatting requirements, there aren’t any—the Data Loader is built to be incredibly flexible. The tool can pull any sort of organized table of data into ClearPoint, including both quantitative and qualitative data. Your file can have data periods as columns or rows; data series can go in either axis; and the overall format can vary. Your data table does need to have some type of methodical arrangement, but you don’t need to spend time reconfiguring tables and rows to make the information consumable by the Data Loader.
How The ClearPoint Data Loader Helps You
The Data Loader automates many activities that are central to ClearPoint’s functionality. When you want to add new information to ClearPoint, you can now use a spreadsheet. ClearPoint will instantly “read” that data, creating and editing elements as needed. This includes objectives, measures, initiatives, action items, owners, descriptions, etc. Remember, the Data Loader works for both quantitative and qualitative information, so it will automatically add or update numerical figures as well as fields like analyses and descriptions.
This saves users a significant amount of time and also ensures your data is consistent and accurate as you move it from local files to ClearPoint.
Examples Of How To Use The ClearPoint Data Loader
Because the Data Loader is so flexible, there are many ways our clients can use the tool to save time and ensure all of their information lives in ClearPoint. Here are three examples to inspire you when considering how to leverage the Data Loader at your own organization:
1. Set up your entire strategic plan or scorecard with one upload.
If you’ve been managing your strategy in a spreadsheet and are ready to advance your process by using ClearPoint’s software, you can do it in a single upload...in a matter of minutes. The Data Loader will take your master spreadsheet and add all your objectives, measures, and initiatives to ClearPoint. Data will be automatically and logically linked together, including information like owners, descriptions, etc. In short, it’s fast and easy to graduate from a spreadsheet to more sophisticated technology that’s built to track and manage strategies.
If your strategic plans aren’t quite in order, you can download our Balanced Scorecard Excel Template, add your strategy information, and then upload it instantly to ClearPoint. It really is that easy!
2. Pull action items into ClearPoint as they are added to other systems.
If you use task-tracking tools like Favro, Asana, and the like, you can use the Data Loader to replicate those tasks in ClearPoint. As an action item is created in another system, send it to a spreadsheet that the Data Loader has been assigned to “watch.” The Data Loader will recognize it as new information and instantly upload it to ClearPoint, automatically linking the task to the defined initiative or objective.
3. Create reports easily.
When it comes time to build your monthly or quarterly reports, the Data Loader makes the entire process a lot easier and faster. The tool pulls new analyses and data from your reporting spreadsheets into ClearPoint. Charts and status icons are automatically updated and ready for executive team review, without requiring you to spend time manually updating information or reformatting visuals. Then, you can use ClearPoint schedules to automatically generate your report and send it to your team.
The Data Loader is the easiest and fastest way to move information from your local files into ClearPoint. It’s automated and intuitive, saving users hours of time. You can even use it to upload your Balanced Scorecard—no reformatting necessary.
Need to create a Balanced Scorecard, but don’t know where to start? Download our free Excel template.
The ClearPoint Data Loader is a powerful tool to help you manage your strategy. Contact us today to send us your spreadsheet (whether it’s a Balanced Scorecard or any other data file) and we’ll show you the tool in action.