---
layout: post
status: publish
published: true
title: Convert Excel to Serif Webplus SDB format

wordpress_id: 246
wordpress_url: http://pro.grammatic.org/post-convert-excel-to-serif-webplus-sdb-format-56.aspx
date: !binary |-
  MjAwOC0xMC0wMyAwNToxMzowNiArMDIwMA==
date_gmt: !binary |-
  MjAwOC0xMC0wMyAwNToxMzowNiArMDIwMA==
categories:
- Technology
tags:
- Excel
- Serif Webplus
comments: []
---
<p>Just sharing something that might be of interest to anyone with a similar problem.</p>
<p>A non-technically minded friend is attempting to use Serif WebPlus to create an E-Commerce site with Paypal integration. The problem is that all his stock is in Excel format which, although Serif claims they can handle, throws an error dialog with the helpful information that the worksheet or database does not have the required fields. There is no indication as to what these fields should be, merely that they are required and not present!</p>
<p>Anyway, I figured I'd have more success with an export to CSV. Nope, exactly the same problem.</p>
<p>Finally, after actually opening an actual "SDB" file in notepad I noticed that the Serif Database file IS a CSV file. The only difference? It comes with quotation marks around each field. Hello, there -> "Hello", "there". Great.</p>