Import Your Data Effortlessly

1. Go to your Account settings page.
2. Switch to the API tab.

Note: Using this feature will require some knowledge of PHP, Java, or Ruby programming languages. To use any of the premium features, such as downloading or live data updates, you'll need to have one of the subscription plans we offer.

1. After you've added a chart or a map to your project, double-click on it to access the datasheet.
2. Select Add Google Drive document at the top of the datasheet.
3. When doing this for the first time, you'll have to connect your Google Drive account to Infogram.
4. Choose the Google Drive document you want to use for your data visualization, then click Select.
5. When you edit the information in your Google sheet, it'll automatically update your Infogram chart or map. The data are refreshed approximately every 10 minutes.

Note: Please keep in mind that if you rearrange the order of your tabs in Google Sheets, the corresponding tabs in your Infogram project won't automatically move. However, you can easily import data from Google Sheets by linking your document, and any changes you make in the linked document will be reflected in your Infogram project. Just be aware that if you rename tabs in your Google Sheets document, you'll need to manually update the tab names in your Infogram chart to ensure your data is correctly displayed.

1. After you've added a chart or a map to your project, double-click on it to access the datasheet.
2. Select Add JSON feed at the top of the datasheet.
3. Use this example to see how your JSON feed should be formatted. To create a multi-tab chart or map, use the following example.
4. Now, when you edit the information in your JSON feed, it'll automatically update your Infogram chart or map. The data are refreshed approximately every 10 minutes.

1. After you've added a chart or a map to your project, double-click on it to access the datasheet.
2. Click the database icon at the top of the datasheet.
3. In the dropdown menu, pick the database you want to connect to. Select MySQL, PostgreSQL, Amazon Redshift, Oracle, or Microsoft SQL Server database.
4. Fill out the form.
5. Click Update for the information to load.

Add data manually or by copy-pasting.

1. To add a chart to the canvas, click Add chart in the left-side toolbar and select the chart you wish to use. Drag-and-drop the chart onto the canvas.
2. Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
3. Click on a cell and start typing or use keyboard controls to copy-paste:
4. Right-click a cell to access a menu with styling options:

Note: To access the option to Add/change link, you need to have a Business subscription or higher.

You can also import data into charts from your computer, Google Drive, Dropbox, or several databases. Infogram supports the following formats: .xls (.xlsx), .csv, Google Sheets, JSON, and databases (MySQL, PostgreSQL, Amazon Redshift, Oracle, Microsoft SQL).Note: Infogram 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 on Infogram.

1. Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
2. Use one of the file import buttons above the data table.

To import your data into Infogram, you may need to give the platform access to some of your external data sources, such as Google Drive, JSON, and databases. This process involves creating a connection that allows for live updates. It's important to note that for data sources like your computer or Dropbox, you can only import files, and each time you need to update your chart, you'll have to re-upload the file.

Pro tip: Before importing your data into your chart, it's important to format it correctly. One important step is to choose the right decimal separator type for your data table, which you can easily do by using the formatting option located just above the chart's data table. Keep in mind that this setting only applies to decimals, not to thousands or millions. By taking the time to properly format your data, you can avoid errors and ensure that your chart accurately represents the information you want to convey.