Import data with a custom Excel file
Follow this step-by-step guide to import multiple payers, recipients, and forms in a single Excel file to make the data available for printing and transmitting.
- File names
- Should not begin with a number
- Should not contain spaces or special characters, including hyphens
- Should not be the same as any other file names on the File Manager page
- Spreadsheets
- Only the first tab of your file will be imported. If you have data in multiple tabs, reorder or merge them so the data you want to import is in the first tab.
- Cells should be formatted as "Text"
- Dollar amounts should be formatted as "Number"
- Should not contain the following:
- Frozen panes
- Hidden columns, rows, or fields
- Formulas
- Column headers
- Should not be blank
- Should have no spaces
- Should be shorter than 50 characters
- Should not begin with a number (e.g. "1Box")
- Should not be the same as any other column headers
- Column headers/titles are case-sensitive. If you change the column headers, you must edit your existing map or create a new map.
