Export this data...
Get embeddable link...
 
Text this live dataZoa Chart to a smart phone...
Email this live dataZoa Chart...
Post this live dataZoa Chart internally to a dZ user...
 
Text this live dataZoa Chart to myself
Email this live dataZoa Chart to myself
dataZoa
 Uploading...
Paste, Drag, or Type Your Data Here:
Allow Replacement [?]
Need help uploading your data?

Most people copy and paste data from their spreadsheet into the dataZoa upload window to the left.

Click
here
to learn more about DataZoa Upload formats including how to add units, footnotes and other data descriptors.

Click here for some upload examples...

Click one of the sample links below to see examples of common data upload formats (use the Clear Button to clear these examples out of the data upload window).

A simple series...
Multi-column...



Replacing Series while preserving their Series Keys...

You can replace the contents of Series entirely but keep all references in place in your charts and tables.

A common application for this is when you have a spreadsheet of data that you routinely copy and paste into dataZoa.

After you have uploaded the spreadsheet the first time, just use the Workbench to Export the series to a file. The file header will have a row of series keys you can then add to your spreadsheet to use from then on.

Like this... Original:    With Keys:




Automate your uploads with the dataZoa API...

With the dataZoa API, you can automate your data transfers. If you have important recurrent updates, your systems can cooperate with dataZoa for enhanced reliability, timeliness and accuracy.
Read
the dataZoa API documentation or download it here.


Drop...

Drop...

Bringing Data into dataZoa

Examples
Description

In general, you can copy and paste any time series data from a spreadsheet into dataZoa. You can also copy and paste data from a plain text file. Here's a quick video tutorial showing how to upload data from a spreadsheet with dates appearing in the leftmost column of your copy & paste rectangle. See examples of alternate formats and ones with more header data below.

Examples

You can copy/paste any of these examples into your dataZoa data upload panel (pictured at right).


Here's a simple series:

Series Title:	My Favorite Series
		
01/01/2011	1
02/01/2011	1
03/01/2011	2
04/01/2011	3
05/01/2011	5
06/01/2011	8
07/01/2011	13
08/01/2011	21
09/01/2011	34

Here's an example with multiple columns, and headers that are specific to each column.

Title:	Blue Widgets	Road Salt	Water
Units:	Candlefeet	Kilograms	Liters
Person:	N. A. Jones	A. Williams	R. Robinson
As-Of:	03MAR2011	02FEB2010	12DEC1999

12/2010	314	159	2
1/2011	653	58	9
2/2011	793	23	8
3/2011	4,626	43	3.8

Notes: These numbers are estimates.

Note that in the above example, "Title:" and "Blue Widgets" are separated by a tab, as are "Blue Widgets" and "Road Salt" but "Notes:" and "These numbers" are separated by a space, because we want "Notes: These numbers are estimates" to be associated with every series in the table, not only with the "Blue Widgets" series. See "Tables with Multiple Series" below.

Also note that in the above table, all the header lines except the "Title:" line are optional


Here's an example with multiple columns and headers that apply to every series in the table:

Frammis Size
Office of Strategic Planning
Contact Jane Doe
Complied 12/23/11

Week Ending	Fms Len	Fms Weight
21FEB2011	2.790	2.734
14FEB2011	3.789	2.987
07FEB2011	2.432	8.745
31JAN2011	3.654	9.875
24JAN2011	4.098	2.345
24JAN2011	4.098	2.345
17JAN2011	4.008	1.234
10JAN2011	5.789	1.234
03JAN2011	2.134	3.456

For the above table, all the lines in the header will be associated with every series in the table. (See "Tables with Multiple Series" below.)

Because the above table doesn't include the words "Series Title:" or "Title:", the blank line above the "Fms Len" line is essential because it indicates to dataZoa that "Fms Len" and "Fms Weight" are series titles. (See "Titles"below.)


The example below is a table of quarterly data

Series Title:	2010Q1	2010Q2	2010Q3	2010Q4	2011Q1
Baseball Games	3	5	13	15	4
Football Games	10	8	3	5	9
Example of a table that could be uploaded to dataZoa
Example of a table that could be uploaded to dataZoa

Description

.csv Files

Along with copying and pasting from a spreadsheet, you can also copy and paste from a .csv file or a plain text file.

Dates

If the series is arranged vertically, dates must be in the leftmost column. If the series is arranged horizontally, dates must be in a row immediately above the topmost data row and must not be separated from the data by any blank lines. Dates can proceed earliest-to-latest or latest-to-earliest

A wide variety of date formats is supported, including both ddmmyyyy styles and mmddyyyy styles. A list of supported date formats is below.

The earliest date dataZoa will accept is 1/1/1000 and the latest date dataZoa will accept is 12/31/9999.

Periods can be either decimal separators or "thousands separators". Commas can be either decimal separators or "thousands separators" (unless the input is a .csv file).

Data Values

Missing observations are permitted, and an unknown value can be indicated by ##NA##, or any of several other strings (see below). That is, if the input series skips a date, then the series in dataZoa will also skip that date, and if the input series has a value such as ##NA## then the series in dataZoa will have NA.

Tables and series may contain non-numeric text. dataZoa will ignore non-numeric values unless it recognizes the text as one of the following accepted text strings:

Series Titles - for data arranged in columns

If the header or footer contains a "Seires Title:" or "Title:" field, then the value of that field is used as the title. Otherwise the column header is used as the title. Note that the keyword "Series Title:" or "Title:" must end with a colon (:).

If there is neither a "Series Title:" or "Title:" field nor a column header, the series will be called "Untitled Series."

Series Titles - for data arranged in rows

There should be a column labelled "Series Title:" which contains the titles for each series.

Known Keywords

You can use certain keywords in a header or footer to provide information to dataZoa about your data. For example: Series Title, Units, and Unit Multiplier.

Tables with Multiple Series

Multiple Series in Columns

When a table contains multiple series in columns, a line in the header or footer that has text only in the leftmost column (the Date column) is associated with every series in the table, whereas when line has text in more than one column or in any column other than the leftmost column each string of text is associated only with the series underneath/above it.

Multiple Series in Rows

When a table contains multiple series in rows, a line of text above or below the data is associated with every series in the table, whereas text to the left or right of a row of data is associated only with the series on that row.

Blank Lines

Sometimes it may be necessary to add or remove a blank line between the header and the data or between the data and the footer in order for dataZoa to properly accept your table.

Advanced Formatting Specifications

On rare occasions, it is necessary to provide dataZoa with a "hint" about how the input data is formatted. The format of these "hints" is described here.

Other Notes

Separators between fields can be tabs or commas. Spaces can also be used as separators, but the use of spaces as separators is not recommended. When spaces are separators, tokens that contain spaces can be enquoted.

Headers and Footer are optional.

Date Formats

Both American-style mm-dd-yyyy dates and International Style dd-mm-yyyy date formats are supported.

Supported date formats include:

01-15-2011
01-15-11
01/15/2011
01/15/11
15-01-2011
15-01-11
15/01/2011
15/01/11
15-Jan-11
15JAN2011
2011-01-15
20110115
Jan 15 2011
January 15, 2011
Sunday, January 15, 2011
110115
1/11
1/2011
2011
2011Q1
2011q1
01-2011
2011m01
2011 Jan
2011Jan
Jan 2011
Jan2011
Copyright © 2000-2017 Leading Market Technologies, Inc.
All rights reserved. Patents pending.