SAMPLEDATA
SAMPLEDATA([tableName])
Returns sample data into your worksheet.
If no tableName is provided then LOCATION-MONTH-DEPT is the default.
| tableName | Description |
| CITIES | |
| CITIES-MONTHS | |
| CITIES-MONTH-MONTH | |
| COUNTRY-VALUE-CODE | |
| COUNTRY-VALUE-CITY | |
| DATES-BIRTHDAYS | |
| LOCATION-MONTH-DEPT | |
| SECTOR-CODE-PRICE-CODE | |
| USERNAME-DEPT-TOTAL |
| tableName Description |
| CITIES |
| CITIES-MONTHS |
| CITIES-MONTH-MONTH |
| COUNTRY-VALUE-CODE |
| COUNTRY-VALUE-CITY |
| DATES-BIRTHDAYS |
| LOCATION-MONTH-DEPT |
| SECTOR-CODE-PRICE-CODE |
| USERNAME-DEPT-TOTAL |
CITIES
Returns a list of 12 cities.
REMARKS
This function populates a range with 1 column and 12 rows.
| =JS.SAMPLEDATA("Cities") |
| Beijing |
| San Francisco |
| Tokyo |
| New York |
| Frankfurt |
| Singapore |
| Helsinki |
| Paris |
| Chicago |
| New York |
| London |
| Wellington |
CITIES-MONTHS
Returns a table of data showing 6 months and 4 cities.
REMARKS
This function populates a range with 5 columns and 7 rows.
| =JS.SAMPLEDATA("Cities-Months") |
| Table | London | New York | Tokyo | Chicago |
| January | 6 | 496 | 39 | 440 |
| February | 149 | 59 | 122 | 31 |
| March | 19 | 471 | 347 | 276 |
| April | 381 | 286 | 58 | 174 |
| May | 327 | 417 | 225 | 131 |
| June | 34 | 72 | 161 | 450 |
CITIES-MONTH-MONTH
Returns a table of data showing 6 months and 4 cities.
REMARKS
This function populates a range with (3 columns and 8 rows).
| =JS.SAMPLEDATA("Cities-Month-Month") |
| City | Jan | Feb |
| London | 9 | 9 |
| Tokyo | 6 | 9 |
| New York | 0 | 1 |
| Tokyo | 4 | 9 |
| New York | 3 | 9 |
| Tokyo | 7 | 6 |
| London | 7 | 0 |
COUNTRY-VALUE-CODE
Returns a table of data showing 12 countries with a value and a code.
REMARKS
This function populates a range with (12 columns and 3 rows).
Note that the table below only shows 7 columns.
| =JS.SAMPLEDATA("Country-Value-Code") |
| China | USA | Japan | USA | Greece | Spain | Finland |
| 103 | 13 | 56 | 42 | 86 | 29 | 76 |
| BB | UU | JJ | AA | GG | SS | LL |
COUNTRY-VALUE-CITY
Returns a table of data showing 12 countries with a value and a code.
REMARKS
This function populates a range with (3 columns and 12 rows).
| =JS.SAMPLEDATA("Country-Value-City") |
| China | 34 | Hong Kong |
| China | 103 | Beijing |
| Finland | 76 | Helsinki |
| France | 62 | Paris |
| Germany | 86 | Frankfurt |
| Japan | 56 | Tokyo |
| New Zealand | 21 | Wellington |
| Singapore | 29 | Singapore |
| United Kingdom | 59 | London |
| United States | 13 | San Francisco |
| United States | 42 | New York |
| United States | 91 | Chicago |
DATES-BIRTHDAYS
Returns a table of data showing ??
REMARKS
This function populates a range with (1 column and 8 rows).
| =JS.SAMPLEDATA("Dates-Birthdays") |
| Birthday |
| 01/07/1977 |
| 24/10/1947 |
| 03/02/1985 |
| 02/12/2004 |
| 11/12/2004 |
| 29/02/2000 |
| 25/02/1999 |
| 16/04/2010 |
| 11/05/2010 |
LOCATION-MONTH-DEPT
Returns a table of data showing ??
REMARKS
This function populates a range with (6 columns and 11 rows).
| =JS.SAMPLEDATA("Location-Month-Dept") |
| Location | Month | Department | Spend | Age | |
| 1 | Hong Kong | Feb | Sales | 9888 | 34 |
| 2 | New York | Apr | Development | 4381 | 48 |
| 3 | Paris | Apr | Research | 2831 | 29 |
| 4 | New York | Feb | Sales | 8130 | 48 |
| 5 | New York | Jan | Research | 2125 | 42 |
| 6 | Paris | Jan | Sales | 5605 | 35 |
| 7 | Hong Kong | Feb | Research | 437 | 39 |
| 8 | New York | Apr | Sales | 3014 | 27 |
| 9 | Paris | Feb | Research | 3433 | 33 |
| 10 | Hong Kong | Jan | Research | 8058 | 41 |
SECTOR-CODE-PRICE-CODE
Returns a table of data showing ??
REMARKS
This function populates a range with (6 columns and 11 rows).
| =JS.SAMPLEDATA("Sector-Code-Price-Code") |
| #VALUE! - error |
USERNAME-DEPT-TOTAL
Returns a table of data showing ??
REMARKS
This function populates a range with (3 columns and 12 rows).
| =JS.SAMPLEDATA("Username-Dept-Total") |
| John | Sales | -17000 |
| Mark | IT | -15000 |
| David | IT | 14000 |
| James | Sales | -21000 |
| John | IT | 15500 |
| John | Sales | -12000 |
| David | Sales | -16000 |
| James | IT | 15500 |
| Mark | Sales | -17000 |
| James | IT | 19000 |
| John | IT | 15500 |
| John | Sales | -24000 |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext