Top

Introduction

The Data Settings screen allows you to specify how the spreadsheet data is to be imported. You use this screen to define the sheet and cell range to import, the category to import into, and some details about the data format.

Note: You must select a sheet, provide both header and data cell ranges, select a category, and verify the column mapping to be able to tap the Save button.

Top

Features

The settings are divided into four sections.

Spreadsheet Import Source

Sheet

Use this option to select the specific sheet to use for import.

Header Cells

Use this option to indicate the cell range containing the column names. The value must be in the format [start]:[end] where [start] is the first cell in the range and [end] is the last cell in the range. Both [start] and [end] should be a standard cell format consisting of the column name as a letter (or letters) and a row number. The [start] and [end] for the header cells must be on the same row. Leave the range blank if the sheet has no row with column names.

Data Cells

Use this option to indicate the cell range containing the data to be imported. The value must be in the format [start]:[end] where [start] is the upper left cell in the range and [end] is the lower right cell in the range. Both [start] and [end] should be a standard cell format consisting of the column name as a letter (or letters) and a row number. You must enter a valid cell range.

Import Destination

Category

Select the category (and optionally a group) that the items in the specified data cells will be imported into.

Location

You can specify a default location to be used for items that don't specify their own explicit location.

Data Format

Multi-value Delimiter

The chosen delimiter is used to handle cells containing multiple values.

Column Mappings

Column Mappings

Selecting this option brings up the Column Mappings screen. This is where you map the columns from the spreadsheet with attributes of the category. MyStuff2 does its best to match up columns to attributes but you must carefully verify the mapping is correct.