Importing from File

The following file formats are supported by BellaDati:

• Plain text file (or CSV - comma separated values)
• Microsoft Excel spreadsheet (XLS, XLSX) - Office 2003, 2007 and 2010 (previous versions not guaranteed)
• XML files
• ZIP files containing one or more supported file formats above

In Import Data popup:

1. Open the data sets page and select "Import data" in the left menu and select "Data file". If you are importing into existing data set, open the desired data set and click on "Import data".
2. Choose Import type to "Data file" and select right file content according to your file format.
3. After selecting the data file, you need to wait until the file is uploaded

When you are importing plain text file (CSV), please continue directly to Import settings page. In another cases, please continue on following chapters:

Importing from Microsoft Excel

After uploading XLS/XLSX file you will be prompted to select the desired spread sheet list in next window.

Importing from XML

In the XML importing guide, you will be prompted to select the row tag, which represents repeatable data sentence. The following example illustrates it on XML file containing employees:

<employees>
	<employee>
		<name>Jan</name>
		<surname>Novak</surname>
	</employee>
	<employee>
		<name>Petr</name>
		<surname>Novak</surname>
	</employee>
        ...
</employees>

In this case, the row tag is <employee>.

1. Row tag: Select repeating tag in XML structure. Check extracted content in the preview on the left.
2. Optionally, you can add custom columns repeatedly: Select items and/or attributes when XML structure is not straightforward.

Importing from ZIP

Importing data compressed as ZIP archive represents a effective way how to reduce imported file size and also upload times significantly. It can contain the following file formats:

• Plain text (CSV)
• Microsoft Excel (XLS, XLSX)
• XML

Please follow corresponding chapters above to continue importing Microsoft Excel or XML file formats.

Next Steps

• Import settings