# We are currently experiencing issues with account & payment-related actions. Please click here for real-time status reports and affected components.
# We are currently experiencing issues with account & payment-related actions. Please click here for real-time status reports and affected components.

Adding data to a chart in Prezi Design

Prezi Design holds more than 40 different charts for you to choose from. After adding one of them to your design, you'll want to add data to visualize. Read on to see how.

Add data manually or by copy-pasting

  1. After you've added a chart to your design, open the datasheet by double-clicking on the chart. You can also access the datasheet by expanding the Edit data tab in the top right corner of the page.
    Note: Every chart is pre-populated with placeholder data for you to see what is the correct formatting.
  2. Click on a cell, type in the value you want to display, and tap Enter. The changes will appear instantly.
  3. If you'd like to copy-paste data into the datasheet, use keyboard shortcuts Cmd + V (Mac) or Ctrl + V (Windows).

Adding_data_manually_and_copy-pasting.gif

Upload an XLS, XLSX, or CSV file

If you have a lot of spreadsheets that you'd like to display in a chart, copy-pasting might not cut it. In this case, you can upload an XLS, XLSX, or CSV file and populate your chart with data in no time!

You should know: Prezi Design doesn't support formulas (including arrays), only raw data. If you import data from Excel, make sure it has only plain data in the cells, as the formulas won't work.
  1. Open the datasheet by double-clicking on the chart or by clicking on the chart and expanding the Edit data tab in the top right corner of the page.
  2. To import a file, click on the Upload file... button.
  3. Select the file you want to use and click Open. After uploading the data, you can edit the spreadsheet at any time.

Uploading_an_Excel_file.gif

Connect to a Google Drive document

Connect your Google Drive account to Prezi Design and make use of live data updatesevery time you'll introduce changes in the Google sheet, they will automatically appear in your chart, including all embeds.

Paid feature: Connecting to a Google Drive document is possible for users with a Plus or higher Prezi plan. Luckily it's a breeze to upgrade your license and get access to this and all the other great features our Prezi plans have to offer.

  1. Open the datasheet by double-clicking on the chart or by clicking on the chart and expanding the Edit data tab in the top right corner of the page.
  2. Select Add Google Drive document at the top of the datasheet.
    Note: When doing this for the first time, you'll have to select the Google account you want to use and allow Prezi Design to access it.
  3. Choose the document you want to use and click Select.

Connecting_to_Google_Drive.gif

If the Google Drive document has several spreadsheets, you can select whether you want to display all of them or only a specific one. Use the dropdown at the top of the datasheet to switch between the spreadsheets.

If you want to, you can disconnect your chart from the Google Drive document at any time by clicking Disconnect. The connection will be then lost and you'll be able to edit the data table in Prezi Design.

Connect to a JSON feed

Paid feature: Connecting to a JSON feed is possible for users with a Plus or higher Prezi plan. Luckily it's a breeze to upgrade your license and get access to this and all the other great features our Prezi plans have to offer.

  1. Open the datasheet by double-clicking on the chart or by clicking on the chart and expanding the Edit data tab in the top right corner of the page.
  2. Select Add JSON feed at the top of the datasheet.
  3. Enter your JSON feed URL in the pop-up window and select Update to load it.
Note: Your data should be in proper JSON format with sheets as outer dimensions (similar to spreadsheets in Prezi Design), followed by rows and columns. See an example here.

Connecting_to_a_JSON_feed.gif

Now, your chart will be connected to the JSON feed with the auto-update feature enabled by default. This way, you cannot introduce any changes to the spreadsheet in Prezi Design, only in your JSON feed.

If you want to, you can disconnect your chart from the JSON feed at any time by selecting Disconnect. The connection will be lost and you'll be able to edit the data table in Prezi Design.

Connect to a database

If you're storing data on an online database, you can connect your Prezi Design chart to it directly to visualize real-time data with live updates. It's possible to connect to MySQL, PostgreSQL, Amazon Redshift, Oracle, and Microsoft SQL Server databases.

Paid feature: Data connectors are available for users with a Premium Prezi plan. Luckily it's a breeze to upgrade your license and get access to this and all the other great features our Prezi plans have to offer.

  1. Open the datasheet by double-clicking on the chart or by clicking on the chart and expanding the Edit data tab in the top right corner of the page.
  2. To connect to a database, click on the database icon above the datasheet.
  3. In the dropdown, pick the database you wish to connect to.
  4. Fill out the form:
    • Hostname(URI) or IP: If you want to make sure this integration is secure, you can restrict access to these IP addresses: 54.205.187.192, 52.3.140.213, 3.224.121.183. We will connect to your database from one of these addresses, so make sure they are whitelisted.
    • Port number
    • Database name
    • Username
    • Password
    • If your database supports SSL connections, we suggest you check the SSL checkbox in the app for that database. We recommend that you use this setting to make sure the data is not transmitted in plain-text.
  5. Click Update for the information to load.

Connecting_to_a_database.gif

To learn more about the available chart customization options, check out the article on customizing your chart in Prezi Design, or browse the Data visualization section of our knowledge base.

Was this article helpful?

We're here to help

Reach out to support, find answers in our community, or view tutorials in the workshop.