- #EXCEL TEXT IMPORT WIZARD EXCLUDE DATA ALREADY IMPORTED PLUS#
- #EXCEL TEXT IMPORT WIZARD EXCLUDE DATA ALREADY IMPORTED FREE#
DONATION cannot do that conversion for you if you do not have Excel installed. Other spreadsheet programs (like OpenOffice Calc) may only have options to save files as CSV - that works too, although you will have to do that saving manually. If you specify to import an Excel file, DONATION will actually do that save to CSV for you, and then import the CSV file. If you currently have the data in a spreadsheet program such as Excel, you can easily export it to CSV with the File ⇒ Save As menu option, using the Save as type "CSV (comma delimited)" or "CSV UTF8 (comma delimited)" if your data might include accented characters, or characters that are not part of the English alphabet. If you currently have the data in a spreadsheet program such as Excel, you can easily export it to tab-separated text with the File ⇒ Save As menu option, using the Save as type "Text (Tab Delimited)" or "Unicode Text" if your data might include accented characters, or characters that are not part of the English alphabet.Ī comma-separated value (CSV) file is somewhat similar to a tab-separated text file, but a comma rather than a tab separates the fields on each line, and fields containing commas (or double quotes) are enclosed in double quotes. The file may optionally have one or two rows of column headers at the top. Fields may optionally be enclosed in quotation marks, but that is not necessary. If you select an Excel file to import, DONATION will have Excel invisibly save it to a comma-separated value (CSV) file (described below), and then actually import that CSV file.Ī tab-separated text file is a plain-text file where each donor is on its own line, and each field on the line (even optional fields that have no data for the current donor) is separated by one tab character. For this to work, each line would also have to contain a field that you can use as a unique identifier (also called unique ID) matching a field that you will import into DONATION, which will be either the Member/Envelope # field, or the Email Address. If your file to be imported contains both donor and donation information on the same line, it will probably be preferable to use the Database ⇒ Import ⇒ Donors and Donations menu option, which does all of the importing in one step.
The only fields that must be filled in are a field or fields for the donor's name, and for Canadian users, Addr1. They can contain any combination of the fields in DONATION's Donor table, in any order. With the Database ⇒ Import ⇒ Donors option, you can import Excel files, tab-separated text files, or comma-separated value (CSV) files.
#EXCEL TEXT IMPORT WIZARD EXCLUDE DATA ALREADY IMPORTED PLUS#
Converting Data from Membership Plus (See also below for further details.).There are special menu options for importing data from certain other programs, which should be used instead of this feature if you are switching from one of those programs.
#EXCEL TEXT IMPORT WIZARD EXCLUDE DATA ALREADY IMPORTED FREE#
Note: This option is not available with the free Lite version of DONATION. Most commonly that would be data exported from other programs. It is possible to import donors from Excel, text or CSV files into DONATION using the Database ⇒ Import ⇒ Donors menu option.