Author Topic: Importing from Excel  (Read 680 times)

Windtalker

  • Newbie
  • *
  • Posts: 1
    • View Profile
Importing from Excel
« on: February 21, 2017, 08:12:58 AM »
Hi,
I'm new to the forum, and am thinking about buying Kitbase. At the moment, my stash (850+ kits) is recorded in an Excel spreadsheet, and also in an Access database. Is it possible to import the data from either of these into Kitbase?

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 148
    • View Profile
    • Suisoft Website
Re: Importing from Excel
« Reply #1 on: February 21, 2017, 08:59:55 AM »
Hi Windtalker,

You can import from Excel or Access via a CSV file.

In Excel, you save your sheet as CSV.
From Access, you would export into CSV.

There are some step by step instructions here:
http://www.suisoft.co.uk/kitbase/ImportProcedure.htm

These are also available via the Help feature in KitBase.

Hope this makes sense.

Kind Regards,
Gary

DaltonP

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Importing from Excel
« Reply #2 on: February 11, 2018, 04:20:20 AM »
Hi Gary, is the same process applicable to google sheets too?

Admin Gary

  • Developer and Owner of Suisoft
  • Administrator
  • Full Member
  • *****
  • Posts: 148
    • View Profile
    • Suisoft Website
Re: Importing from Excel
« Reply #3 on: February 11, 2018, 08:09:01 AM »
Hi DaltonP,

You need to get the data into CSV format.

I'm not a Google Sheets user myself, however I did a quick Google search and found a few articles about exporting to CSV.

https://www.google.co.uk/search?q=google+sheets+export+csv

Hope this helps.

Gary