Brian, see attached. That file you posted isn't a 'real' Excel file, it's a text file with a xls extension added onto to it. When I opened it in Excel it had everything in one column. So I took the xls extension off and opened it again in Excel and it had everything separated into 6 columns. I suspect this is where having troubles. If you try to open a text file while telling Tableau it's an Excel file you're going to confuse T.
ZipCodes Q.twbx.zip 83.5 KB
A couple of things:
- Your data is not a CSV. It's a XLS.
- Because of that, what you have is a single column of values, such as in A1: "Country (Name),State,City,ZIPCode,Latitude,Longitude", not multiple columns.
- Solution: Text to Columns, delimited, commas. Then, save as CSV. Accept that there are features incompatible with this file type when the dialog pops up. Otherwise, it will save it as an excel file (XLS or XLSX).
- Alternative: Copy and paste into notepad, then save as CSV.
That should do it!
FixedZIPs_NR.zip 82.2 KB