The import module in the back-end of a Webanizr website can import data from Excel if it is saved in CSV format. This manual explains how to save an Excel sheet to CSV format.
Open the sheet within the Excel file you want to save in CSV format. In CSV you can only save one sheet at a time.
From the file menu, select the optiosn Save As.
Tip: you can also press F12 to open the Save As dialog.
In the Save As dialog you enter a name for your file. Next to the Save as type label you select the option "CSV (Comma delimited) (*.csv). Make sure you selected the folder you want to store the file in and click on Save.
After you clicked on Save, Excel will give you a warning that only the active sheet will be saved as CSV. Click OK in the dialog.
CSV is a very simple, text-only format. If you have used formula's or style in your Excel sheet Excel will show a warning that these will not be exported to CSV format. Click on Yes in this dialog. Your data is now saved to CSV format.
Log in with USB
Inloggen met vingerafdruk wordt binnenkort mogelijk.