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.
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
Along with copying and pasting from a spreadsheet, you can also copy and paste from a .csv file or a plain text file.
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).
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:
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."
There should be a column labelled "Series Title:" which contains the titles for each series.
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.
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.
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.
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.
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.
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.
Both American-style mm-dd-yyyy dates and International Style dd-mm-yyyy date formats are supported.
Supported date formats include:
Jan 15 2011
January 15, 2011
Sunday, January 15, 2011