Forum Discussion

aussie123's avatar
aussie123
Copper Contributor
Jan 25, 2020

Problem Using Excel For Website

Hi. I am having trouble working out what is wrong with my excel products price list/spreadsheet sheet for my ecommerce website. I am using the 2019 Excel version. The product description shows in...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 27, 2020
I am guessing your "Excel file" is in fact uploaded to the website as a CSV file? If so, probably the delimiter of the CSV is not according to the website's expectations.
  • aussie123's avatar
    aussie123
    Copper Contributor
    Jan 27, 2020

    JKPieterse 

    I have the file in CSV and XLSX and they both do the same thing.

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jan 27, 2020
      What file format does your website need? Can you upload a sample file in both xlsx and csv to here which only contains som fictituous data (just 2 product rows would suffice)
      • aussie123's avatar
        aussie123
        Copper Contributor
        Jan 27, 2020

        JKPieterse 

        The bulk upload in my software uses both CSV and xlsx.

        I have attached a sample of both sheets and the problem columns are M in the CSV and O in the xlsx sheet.

        They are the Description columns.

        Thanks

        Lance

Resources