How To Prepare Data For Fancy Chart To Upload Via CSV, JSON, And Google Sheets?

EB Fancy Chart is a very useful block to showcase important data with stunning charts and graphs on your website. In this documentation, you will find how to prepare data for Fancy Chart block to upload via CSV files, JSON files, and import Google Sheets in Essential Blocks.

So, from now on, Gutenberg lets you highlight data with fancy charts without coding using this block. To upload these files to your website using the EB Fancy Chart block in Gutenberg, follow this step-by-step guide.

Prepare Data For Fancy Chart To Upload Via CSV File #

To make a CSV file, first, open a sheet to import data. Now, put the dataset in each column and keep the item names in every row. 

Once your data import is done, save the file in CSV (comma-separated value) format.

Now the file is ready to upload in the EB Fancy chart. To insert your chart data from a CSV file, go to the dashboard. Choose the ‘CSV’ option from the drop-down and click on the ‘Upload’ option. Now, select the CSV file that you want to upload as shown. 

Prepare Data For EB Fancy Chart To Upload Via JSON File #

To prepare data in JSON format, you have to follow the data structure below.

• “Category” will be an array 
• “Dataset” will be an array of objects. 

For each dataset, you have to provide the name, color, and data. Here data will be arrayed on numbers and the length of the array must be equal to the length of the category array.

{
 "category" : ["Category 1", "Category 2", "Category 3", "Category 4"],
 "dataset" : [
   {
     "name": "Dataset 1",
     "color": "#ddd",
     "data": [20,30, 40, 50]
   },
   {
     "name": "Dataset 2",
     "color": "#666",
     "data": [25,35, 47, 58]
   }
 ]
}

Once you have finished preparing the JSON file, you have to upload the file into the EB Fancy Chart. Go to the dashboard and choose the ‘JSON’ option from the drop-down and click on the ‘Upload’ option. Now, select the JSON file that you want to upload as shown. 

Prepare Data For EB Fancy Chart To Import Via Google Sheets #

To import data in the EB Fancy chart through Google Sheets, you need to prepare a sheet where you can put the dataset in each column and keep the item names in every row. 

To insert the Google Sheets into EB Fancy Chart, go to the dashboard. Choose the ‘ Google Sheets’ option from the drop-down and provide the ‘API Key’, ‘Sheet ID’, and ‘Sheet Name / Range’ there.

Note: To know how to retrieve the API Keys, Sheet ID, Range, etc for Google Sheets, read this documentation. 

This is how you can easily upload data in CSV files, JSON files, and Google Sheets in the EB Fancy Chart block in Gutenberg.

Getting stuck? Feel free to Contact Our Support for further assistance.