Importing data from Excel
How to import data into Modes from an Excel file

Importing data into Modes
If you look for information about importing data into Modes, you might find the Import function on the File menu. This allows you to import data you previously exported from another Modes data file, or data from a Modes backup file.
But this is most likely not what you’re looking for? My guess is that you want to import data into Modes from Excel?
Some ModesComplete users will remember using the CSV converter to carry out this job. But thanks to the new Import from Excel function, both Modes Complete and Modes Compact users can now import data directly from Excel, using a much easier process.
Upgrade to Version 1.6
You’ll need to upgrade to Version 1.6. If you are already using Version 1.6, make sure you have Version 1.6.57 or later (see which version of Modes are you using?).
Prepare the spreadsheet
You can import any spreadsheet into Modes. You don’t need to use the same column names as the elements you see in Modes – this will make no difference to the import.
But you do need to give every record a unique record number – Modes won’t accept records with duplicate numbers, or unnumbered records.
Prepare the template
Choose the template you want to use for the imported data.
ModesComplete users can edit their templates to add additional elements, if needed. But in ModesCompact the templates are fixed.
How does it work?
It would be wonderful if you could throw any spreadsheet at Modes, and Modes would sort it out automatically. But one big difference between Modes and Excel is that you can invent as many columns as you like in Excel, whilst Modes uses a standard field structure.
So there needs to be a stage where you map the columns in Excel to corresponding elements in Modes, and this can only be done manually.
For example, you might have a column in the spreadsheet called publication date. There is no corresponding publication date field in Modes. We represent this concept using the Date element in the Production section. So, you need to map the publication date column to the Date element in the Modes template.
It’s important to understand that this mapping is done between columns in the spreadsheet and elements in the Modes Editor panel, not columns in the Modes Grid panel.
- Select Import from Excel from the File menu.
- Select the spreadsheet, then select the template.
- Drag and drop each column in the spreadsheet to a corresponding element in the template.
- The data will be processed and imported into Modes.
Leave a Reply
You must be logged in to post a comment.