Populate a Joomla database with Excel (or CSV) File

Populate a Joomla database with data from an Excel or CSV file.

Overview

The user needed to import external spreadsheet data to initially fill a new Joomla site's database.
Use the MySQL Excel extension to connect to and import data directly into the Joomla database remotely.

Answered
kk kkurtz 27 Jul, 2017
I don't know if this is a CCv6 or CFv6 question, or maybe both.

I have a new Joomla site and I want to import data from Excel spreadsheets to initially populate the files. What is the best and easiest way to to do it?

I've read several posts, but they are a few years old. So I'm hoping that there is some capability in the new versions.

Thanks for your help.
Karen
Gr GreyHead 27 Jul, 2017
Answer
Hi Karen,

MySQL has an Excel extension that you can use to do this - provided that you can access your Joomla! database remotely this is one of the easiest ways to do it.

Bob
This topic is locked and no more replies can be posted.