ContributionsMost RecentMost LikesSolutionsRe: QB says Not Unique; Excel and TextWrangler say UniqueI created a temporary QB table and manually imported the file. There were no errors. I did find 1 duplicate. The reason it wasn't caught in Excel or TextWrangler was because there was a space in the cell after the duplicate value. :/ Thank you for this quick and intelligent fix!Re: QB says Not Unique; Excel and TextWrangler say UniqueI deleted the QB table and my csv file from Google drive. I created a new table in QB and uploaded the same file linked in the problem. I still get the "non-unique values" error.QB says Not Unique; Excel and TextWrangler say UniqueI am attempting to add a table linked to a csv file in my Google Drive. The csv file has just two columns: Item, Cost. The Item is the unique ID used for Refresh and Key. When I refresh connection, I get "The error was: The source data includes non-unique key values, the column value(s) from the source query that correspond to the destination key column(s) must be unique." I have tried removing duplicates in Excel and it says no duplicates. I have made sure there are no additional blank rows at the end of the csv. I have formatted the Item column as Text in Excel before saving down to csv. I have opened the csv file in TextWrangler and searched for duplicates and found none. And yet, QB says non-unique values exist in this column every time. CSV file here.