Import from Excel

Import from Excel

Format of the Excel file

Your file should be in .xls or .xlsx format.

Prepare the file to extract human readable names

Visyond uses human readable names so you can type formula either as =A1-B1 or as  =Revenues[2020]-Costs[2020]. See How to use Natural Names in Visyond.

Please format your Excel to have row names and column names in the leftmost column and top row respectively: Visyond will use the these names to create human-readable names.

If not formatted this way you can always cut and paste names from grid area to names area once the project is imported.

Import time

Importing may take some time as we need to extract metadata to create Visyond data structures (richer than traditional spreadsheets).

You can close the import window and work on other projects while we are importing. We will send you an email when the project is ready.

The Import Report

We compare the import results with the original Excel file and prepare a report with the unsupported or unrecognised elements so you can easily identify them and decide what to do. The import report includes:

  • List of cells that have different values in Excel and Visyond (this can be due to differences in floating point precision, usually negligible differences at the 7th decimal digit)
  • List of cells with unsupported functions (wrapped inVisyond’s IMPORT_ERROR function) in their formulae. We do not support:
    • Some type of named ranges
    • Array Functions

We do not lose the Excel value and formulae for the unsupported functions: they are wrapped in Visyond’s IMPORT_ERROR function and the formula in the cell looks like this:

=IMPORT_ERROR(“Excel_formula_containing_usopported_function”, EXCEL_VALUE)

This way you can identify the cell and decide what to do. Meanwhile, the Excel value is reused in the calculations.

If you would like us to support a specific function, please contact us.

how to
August 11, 2018

Was that post helpful?

Related Articles