The foundation of every chart you make with Vizzlo is your data. In this article we cover how your data needs to look like to be interpreted without problems. We are constantly working on making uploading data as easy as possible.
Once the data was uploaded, you can edit it in the spreadsheet or in the chart editor, see our article Editing and adding data.
We will show you 3 ways to get your data into Vizzlo:
- Copy & paste the data from a spreadsheet
- Import your data from an Excel file or .csv file
- Connect your chart to a Google Sheets file
1. Copy & Paste
Simply copy your data using the shortcut `Ctrl / Cmd ⌘ + C` (Windows/Mac) and then paste it into a charts spreadsheet with `Ctrl / Cmd ⌘ + P`. If you have selected your data you can also right-click and chose copy or paste.
Something went wrong. The spreadsheet in the chart expects a different data format for column B; the red cells indicating a wrong data format. Also, the data in column `Life expectancy` is not the same as in the Excel file because the expected decimal separator was `,` whereas in the Excel file we used a `.`.
NOTE: the decimal and 1000s separator might be different depending on your locale.
So here there are three issues we need to take care of:
- the prefixed `$` in the column 'GDP per capita'
- the decimal separator is a `.` for column 'Life expectancy'
- change precision of column 'Life expectancy' (optional)
2. Upload Excel files or .csv files
Now that you know what to consider when adding data to Vizzlo uploading a .xslx, .xls, or .csv is straightforward. You have two options: drag and drop the file into the spreadsheet ...
... or click on `Import` to browse your local files.
3. Connect your chart to Google Sheets
To get your data from a Google Sheet into file you need to click on `Connect` next to `Import`. This will open the following dialog
- paste a link to a public Google Sheet (or Excel file)
- browse your files hosted in the cloud if you did connect your Vizzlo account to a cloud storage before
This feature allows you not only a one time upload of a Google Sheet document or Excel file but also to schedule automatic updates of your document.
To make sure that your data is imported correctly, be aware of these:
- Charts need a specific column order. This is the most essential point. Before you get your data into Vizzlo your data must make sure that the columns are in the expected order. You can see the data when you click on `Spreadsheet` in the menu bar above your chart.
For this article we'll use a Bubble Chart; in which case the first and fifth columns contains strings, columns 2 to 4 numbers.
- Numbers can come with pre- & suffixes - but you need to tell us. If you data contains numbers with pre- or suffixed currency signs, percentage signs etc., make sure to give that information to the spreadsheet before you upload it. Below well cover a such a case.
- Blank rows are fine, comments and footnotes not. Spreadsheets commonly contain comments, and descriptions in the first rows, or footnote at the end. This content needs to be removed. Blank rows are fine but they will be removed after closing the spreadsheet; just like logos.
- The first row of your data should be or will become column headers. By default every chart comes with column headers. If your data doesn't have column headers you can simply use defaults and later edit if you like.
- Each cell should contain a single number, a string or date. Cells containing a mixture of numbers and text, e.g. "Stuttgart 21" will be interpreted as text. Unless you tell the spreadsheet to expect a prefix "Stuttgart ".
Exceptions are dates, which can come in the form of "January 1 2020" - see our article for supported date formats.
- Data can contain empty cells. Empty cells will be highlighted in red. That is no problem for most chart types.