Semicolon separated text files with Microsoft® Excel®

Files can be created manually using Microsoft Excel, as follows:

Enter the data in the same sequence as described in this document for the import process. Make sure, in particular, that the first three elements are not separated. For example, if you are importing products, GBAP15 should appear in column A. If you want to enter GBAP15 in a number of rows in column A, select fields A1 and A2 and drag down.
When all data has been entered in the correct sequence (columns A, B, C, and so on), irrespective of whether the data has been entered manually or copied/imported from another program, select File - Save As from the menu bar. Save the file as a text file (.TXT or .CSV). Comma delimited means that the items in the file are separated by commas.
Close Excel and open the new file using Notepad or WordPad. Go into Windows Explorer; hold down the [Shift] key and right-click the file. This allows you to open the file using one of the programs mentioned. If the separator is not a semicolon, but a comma, for instance, this can be easily corrected. Select Edit from the menu bar, then Replace and you can search and replace all the commas with semicolons.

Note! You must ensure that there is a semicolon after the last field in each row. You can do this by creating an extra column in the spreadsheet after the other fields. Copy the text down into all the rows. When the file has been saved as a text file and opened in NotePad, this text can be removed by using the Replace Function so that only the semicolon remains.

Example with an Excel File

There are many ways to achieve a compatible import file for Mamut Import/Export.

Suggested method for saving an import compatible file from Excel

Register a few customers, suppliers, products, orders or journals in the normal manner in Mamut Business Software.
Export this data with Mamut Import/Export in order to create your own example files.
Example files are included with the installation of Mamut Business Software and are saved in the folder with the program files: “…\Mamut\ImportExport\ExampleFiles”.
Open the exported file in Excel and replace the different columns with your data. Be aware that you can use relevant standard values. You can export a list of these from the export menu in Mamut ImportExport. Read more in Default Values in Mamut Business Software.
Save the file as a semicolon separated text file (sdv/csv).

Check in Notepad that the punctuation is a semicolon.