Hello and welcome from our WebDataRocks community!

We offer you to see your own data on the grid so you can play around with our live demo and try the functionality it provides. In our today’s blog post I am going to guide you through the process of preparing your Excel data and explain how to connect it to our demo. The process is simple and consists of a few steps:

Step 1. Clean up your data using set of tools from Excel

Preparation of the dataset is an essential process that should precede any data analysis. Unprepared dataset often contains excessive or incomplete information which interferes with the analysis process. Before any manipulations we advise to create a backup copy of data, just to be able to revert the changes if the result is not satisfying. Follow our tips to clean up your data:

  • Use Sort & Filter to locate duplicates, apply naming conventions, find blank or incomplete records
  • Try one of the lookup and reference functions to add the columns with necessary details to your dataset
  • Format cells with phone numbers, zip codes, etc. to make sure they look the same way
  • Use Find and Replace feature to remove the unnecessary characters such as dashes of empty spaces
Step 2. Export data from Excel

In this step, we are going to save data we were preparing in the previous step. CSV format is considered to be really convenient for data analysis. Save data in this format by choosing Save As -> CSV UTF-8. To display your data correctly WebDataRocks requires the content to be encoded as UTF-8.

Step 3. Connect your dataset to WebDataRocks

Now it is time to display your data on the grid. Please open our demo, choose Connect -> To local CSV and select the CSV file generated in the previous step. Hooray! Your data from Excel is displayed in our demo. You do not have to worry about the security of your data as WebDataRocks is a client-side tool and we never store your data on our side.

Thank you for attention. Want to add WebDataRocks to your website? Leave a request to get your copy of our tool.

Stay tuned, in the upcoming posts we will share some hints about JSON data preparation and the best ways to use our demo.