Ready to import a spreadsheet into a Module in eSalesTack? Great! But first, let’s make sure the spreadsheet is formatted correctly. Depending on where you get the spreadsheet from, you may need to do a little formatting to it. If it has any HTML formatting to it, (colors on the header, on lines on the grid, Hyperlinks on email or website), that will need to be reformatted.
To easily do this, click on a cell, click “Ctrl” and “A” at the same time to select all. Then click “Ctrl” and “C” at the same time to copy it all. Then Click the Windows Icon in the top left hand corner (or File if using older versions of Excel) and click “New” to open up a new sheet.
Click on cell “A1,” (the very first cell intersecting the First Column and Row). Once you are on cell A1, right click and click “Paste Special,” (please note it is Paste SPECIAL, not just normal Paste). Another Menu screen will pop up and click the bullet that says Values, then click “OK”.
Your data should know look like this:
You are now ready to import clean data.
Does your data look like this and you are still having problems? This may be caused Field Level formatting issues.
• Make sure your “Key Field” has data in it for every record. (Please see the Key Field help article if you require clarification on what the Key Field is. It is important you know what your Key Field is before you clean your data for import.)
• If you don’t have data for the Key Field, it is ok to just put “unknown,” or whatever phrase makes sense to you.
• Make sure that if you have email addresses or websites, that you do not have hyperlinks on them. (Should not look like firstname.lastname@example.org. Should look like email@example.com. )
• If you have a date, make sure it is formatted like 1/01/2011, (not Oct. 12 or 10/12).
• If you have a phone number field, make sure it does not have any text letters in it. It should only have numbers, “(),” and “-“.
• If you have an eFusion field, make sure that the two fields that are combined to make that field have the correct data in them. (If you have Full Name, which concatenates First Name and Last Name, make sure you have the correct data all three fields.
Finally, but most importantly, please make sure that your Excel Spread Sheet is saved as a “CSV” file or an “Excel 97-2003 Workbook.”
**Think some one-on-one training may help you better with this? Or would you just like eSalesTrack to do the clean up and import for you? Contact eSalesTrack Training at firstname.lastname@example.org for pricing.**