About Us Icon About Us Icon Business Analyst Icon Business Analyst Icon CEO Icon CEO Icon Datameer Icon Datameer Icon Envelope Icon Envelope Icon Facebook Icon Facebook Icon Google Plus Icon Google Plus Icon Instagram Icon Instagram Icon IT Professional Icon IT Professional Icon Learn Icon Learn Icon Linkedin Icon Linkedin Icon Product Icon Product Icon Partners Icon Partners Icon Search Icon Search Icon Social Networks Icon Social Networks Icon Share Icon Share Icon Support Icon Support Icon Testimonial Icon Testimonial Icon Twitter Icon Twitter Icon

Datameer Blog

How-to: Import Excel Data (Even Existing Formula Results!) into Datameer

By on April 11, 2014

For this week’s Favorite Feature Friday, I wanted to show how easy it is to import Excel files into Datameer. Not only does Datameer read its raw data, but it also evaluates any existing formulas in the Excel sheet to pull those results in as well.

To start, select “New Import Job” and choose Excel Workbook as the file type to import.

How-to: Import Excel Files into Datameer

I’ve used a fairly simple data set for this example, but the important point to note is that the last column is the sum of the “Business Value Previous” and “Cart Value.” Datameer will interpret the formula structure for this column during import.

How-to: Import Excel Files into Datameer

Simply follow the import wizard, make sure the data looks correct in the preview, save the import job and voila. Here is what your final Datameer workbook will look like.

How-to: Import Excel Files into Datameer

You can watch my step-by-step process for further details:


Connect with Datameer

Follow us on Twitter
Connect with us on LinkedIn, Google+ and Facebook


sfroehlich

Subscribe