# Multidimensional Data Upload (2D/3D/4D Tables)
URL: https://docs.valsight.ai/multidimensional-data-upload-2d-3d-4d-tables/
Description: If your source systems present data in some sort of formatted table rather than a structured "database like" table you can use the 2D and 3D upload functiona…
Upload multidimensional data by declaring the dimension levels and the measure name in cell A1, which turns a formatted 2D, 3D or 4D table into structured data.

## Create a 2D/3D data table

If your source systems present data in some sort of formatted table rather than a structured "database like" table you can use the 2D and 3D upload functionality.

The identifier in Cell A1 has to contain the following information:

### 3D / LevelName1 / LevelName2 / LevelName3 / MeasureName

| Fragment    | Explanation                                                                                                                      |
| ----------- | -------------------------------------------------------------------------------------------------------------------------------- |
| 3D          | The identifier tells Valsight that this table should be considered a 3D table                                                    |
| LevelName1  | The Name of the level that the data in column A belongs to. Should match a level name exactly.                                   |
| LevelName2  | The Name of the level that the data in column B belongs to. Should match a level name exactly.                                   |
| LevelName3  | The Name of the level that the data in Row 1, starting at Cell B1 (2D) or C1 (3D) belongs to. Should match a level name exactly. |
| MeasureName | The data will be available as this column in the resulting Valsight Table.                                                       |

You can also use the =DIM\[Dim,Level,#] identifier for each level name to create a Dimension "on the fly". However, for best results and a structured approach, you should rather have these information in separate Dimension tables.

Download an example 2D / 3D / 4D upload sheet at [Example Excel Sheets](/example-excel-sheets/).

To illustrate the way a 3D upload works: the following two tables are equivalent:

| 3D / ExampleProduct / ExampleChannel / Year / Volume | ExampleChannel | 2018 | 2019 |
| ---------------------------------------------------- | -------------- | ---- | ---- |
| Product A                                            | Online         | 10   | 40   |
| Product B                                            | Offline        | 20   | 30   |

Equivalent regular upload table:

| Year | ExampleProduct | ExampleChannel | Volume |
| ---- | -------------- | -------------- | ------ |
| 2018 | Product A      | Online         | 10     |
| 2018 | Product B      | Offline        | 20     |
| 2019 | Product A      | Online         | 40     |
| 2019 | Product B      | Offline        | 3      |