File layout

XLS or XLSX is the default format in which Microsoft Excel stores its files (spreadsheets consisting of columns and rows). These files cannot be imported into Adlib or exported to. However, if you need to import data from an XLS(X) file into Adlib, you can try to convert it to another format first. For example, if your spreadsheet is structured similar to the table below and when field repetitions do not occur, you can easily convert the file to a .csv file, ready to import into Adlib.

Field name 1

Field name 2

Field name 3

Field name 4

etc.

Value 1
(of record 1)

Value 2
(of record 1)

Value 3
(of record 1)

Value 4
(of record 1)

 

Value 1
(of record 2)

Value 2
(of record 2)

Value 3
(of record 2)

Value 4
(of record 2)

 

Value 1
(of record 3)

Value 2
(of record 3)

Value 3
(of record 3)

Value 4
(of record 3)

 

etc.

 

 

 

 

Conversion to .csv

1.Open the file in Microsoft Excel.
2.Save the file as a CSV (MS DOS) (*.csv) file.
3.Open the file in a text editor to check it. If the first line of your .csv file contains field names, then remove that line because you don't want to import those.
4.The resulting file is ready to import into Adlib. You'll find that double quotes (") in the data  have been doubled ("") and that data containing double quotes or the field separator (this may be a semi-colon or a comma, depending on your Windows regional settings) has been enclosed in double quotes, just the way Adlib requires the .csv file to be. Empty cells are represented correctly as well. If the file uses a semi-colon as field separator instead of the comma field separator expected by Adlib, you'll have to make sure you define the semi-colon field separator in your import job field mapping explicitly.