Microsoft Excel can be a powerful tool in manipulating and analyzing your data that you collect with Fulcrum. We here at Fulcrum use open and well known data formats. UTF-8 is the standard for the web. Unfortunately, Microsoft Excel has its own preference for data encodings. You can use Microsoft Excel’s import tool to massage your data in to working with Excel.

Once you have Microsoft Excel 2007 open:

  • Click on the Data menu bar option.
  • Next, click on the From Text icon.
Click From Text
  • Now, navigate to the location of the .CSV file you exported from Fulcrum.  Click on the filename and then click on the Import button.
Navigate To File
  • Choose the delimited file type and Choose 65001: Unicode (UTF-8) from the drop-down list.
Select Unicode
  • Check the “Comma” delimiter, which is what was used in the data exporter file.  The Data preview window will show you how your data will appear.
Choose Comma
  • Now, choose the appropriate data format for each column of data that you want to import.  You also have the option to not import one or more columns of data if you want.
Select Format
  • Finally, click on the Finish button to finish importing your data into Microsoft Excel.

Now all of your data will be imported properly into Excel and it will avoid any of the strange issues that come from document encoding changes. You now have the full power of Microsoft Excel to analyze, manipulate and massage your data.

Data Imported Into Excel
Generate Chart

Microsoft Excel is a very powerful tool for analytics, it can be used to generate practically every type of table and graph possible, even pivot tables. What sort of features to you like to use in Excel? For me, I love the radar charts! They allow you to analyze multivariate data in a quick  and easy to read format.

About the author

Tyler worked on Fulcrum's web application platform, using Ruby, Javascript, node.js and other web technologies.

Get started with Fulcrum today