Using MS Excel to prepare data for import

 Top  Previous  Next

 

Microsoft Excel is an excellent tool for preparing data to be imported into Ovitec. Using MS Excel, you can import data from most common formats: DBase, Xml, text, Access, etc.

Once you have read the data using MS Excel, you must rearrange the columns and format according to the Ovitec filter specification.  Most Ovitec filters work  by importing the text format file, with ; as separator list. For example:

 

1. Open Microsoft Excel
2. Click Open and select the format of your data in File Type
3. Select the file and click Ok
4. If necessary, modify your sheet by hiding columns (click right button and Hide) or altering their order to get these columns, according to the Ovitec filter specifications.
5. Click File, Save As.
6. In Save As Type, select CSV (commas separated variables) (*.csv).
7. Enter a file name and click Save.

 

The file generated is text type, and can be modified with any editor like Notepad or similar. At this point you can open it to see the contents. It should look something like this:

FARM1;01/12/02;230;1;20.4;3.78;3.44;199
FARM1;01/12/02;244;1;30.3;3.68;3.12;281
IOWA;01/12/02;BLACK;1;22.1;3.16;369

 

Notice that each field is separated by a semi-colon (;).  If you do not see a semi-colon, you should replace the character using the corresponding editor option or modify the Regional Configuration of Windows, List Separator.