thread Trouble importing items in Archived Discussions (Read Only)

Trouble importing items

wwidmer — Wed, 22 Jun 2016 21:34:02 GMT

When I try to import my items, it tells me that I have an extra quotation in Row 1. I have gone through multiple times and I can't seem to solve the issue. I haven't changed row 1. I have made multiple spreadsheets and everytime I have the same issue. Anyone know how to solve this?

Re: Trouble importing items

EJ_ — Wed, 22 Jun 2016 21:33:31 GMT

Hi there!

Item Import can be a bit tricky.

Excel can read CSVs with quotation marks incorrectly sometimes. Check to make sure quotes haven’t separated a name into two different cells.

Also, when deleting an item, do not use Clear Contents. Always delete the cells. This removes any commas that may linger.

I hope this helps.