Top
Follow

Budget Mailout - CSV Excel Tips

This User Guide outlines tips for formatting the CSV Excel template for budget mailouts.

 

For instructions on creating a Budget Mailout Announcement, refer to the User Guide below:

Budget Mailout Feature

 

Before using this template, verify you have the latest Excel version installed. Older Excel versions may not format the CSV file properly for our system.

 

1. Do not delete the default rows or columns in the CSV Excel template. Simply enter new data in each section as needed. 

mceclip0.png

If you delete a row or column, the system will not be able to translate the sequence. It will no longer distinguish between a unit number or a word. This is particularly important when you have a unique unit name such as “MGMT OFFICE” or “MGMT” listed in the unit file under the unit column. The system will still recognize those unique names as a unit if they are listed in the unit file as “unit number”.

mceclip1.png

 

2. Ensure the unit numbers you enter match the format in the unit file. If not, you will receive an error message stating the unit number is invalid.

Example: Unit File 0600, Excel 0600   
Example: Unit File 0600, Excel 600     X

mceclip3.png

 

3. When reviewing Column B, use the cell format labeled “TEXT”. Do not add in dollar signs $ or commas. Only use decimals.

Example:
1000.00     
1,000.00     X
$1,000.00   X

mceclip2.png

 

4. The Excel document MUST be saved as a CSV format. A Comma Separated Values (CSV) file is a plain text file that contains a list of data which can be read by our system. Any other format will not work.

mceclip1.png

Get Additional Help

Visit our Helpdesk for additional help and support.