Google Sheets Data Importing

This guide will walk you through the simple process of importing data from Google Sheets into your Framer Charts.

Step 1: Prepare Your Google Sheets Data

For Bar, Line, Area, Pie, Doughnut, Radar and Polar Area

Your Google Sheets data for common 2D charts should be formatted as follows:

date,sales_A,sales_B,sales_C
2024-1-1,935,520,182
2024-1-2,864,210,698
2024-1-3,234,773,997
2024-1-4,668,195,565
2024-1-5,638,871,918
2024-1-6,425,533,158
2024-1-7,902,687,777
2024-1-8,728,459,912
2024-1-9,274,491,

Each column represents a different data series, with the first column typically being your categories (like dates).

For Bubble and Scatter

For 3D charts like bubble charts, format your data like this:

dataset,x,y,r
dataset_1,78,95,11
dataset_1,63,20,30
dataset_1,33,83,39
dataset_1,12,46,32
dataset_1,18,31,65
dataset_1,38,22,95
dataset_2,32,84,78
dataset_2,70,47,84
dataset_2,25,83,54
dataset_2,41,78,56
dataset_2,74,76,39
dataset_2,62,19,

x and y are the coordinates of the bubble, and r represents its radius. For scatter, just need x and y.

Step 2: Publish Your Google Sheets as CSV

• Open your Google Sheets document.

• Click on File, then Publish to the web.

• Choose Comma-separated values (.csv) as the format.

• Click Publish.

• Once your sheet is published, copy the URL provided by Google Sheets.

Step 3: Import into Framer Charts

• In Framer, locate and select your Framer Charts.

• Select API as the Data Source

• Paste the URL of your published Google Sheets CSV file into the API URL filed.

• Toggle Data Transform and then configure it:

  • Define Labels:

    • Specify which column holds the labels for your chart (e.g., date).

    • For bubble and scatter charts, No need to define labels.

  • Define Datasets:

    • Indicate the columns representing the different datasets (e.g., sales_A, sales_B, sales_C).

    • For bubble and scatter charts, just need one value (e.g., dataset).

Conclusion

That's it! You've successfully imported your Google Sheets data into Framer Charts. You're now ready to create stunning, data-driven charts for your projects. If you have any questions or need further assistance, feel free to reach out.