# We are currently experiencing technical issues with Prezi. Please click here for real-time status reports and affected components.
# We are currently experiencing technical issues with Prezi. 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 at 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 hit Enter. The changes will appear instantly.
  3. If you'd like to copy-paste data into the datasheet, right-click on a cell and choose Paste, or use keyboard shortcuts Cmd + V (Mac) or Ctrl + V (Windows).

Adding_data_to_a_chart.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!

Note: Prezi Design doesn't support formulas, 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.

Adding_en_Excel_file.gif 

Connect to a database

If you're storing data on a database, you can connect to it directly to visualize the data in Prezi Design. It's possible to connect to MySQL, PostgreSQL, Amazon Redshift, Oracle, and Microsoft SQL Server databases. We currently offer one-time imports.

Paid feature: Data connectors are available 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. 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 are going to 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.

Database.gif

Was this article helpful?

We're here to help

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