Importing from Google Sheets

This support ticket is created 4 years, 3 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 1 reply, has 2 voices.

Last updated by Luo Yang 4 years, 3 months ago.

Assisted by: Luo Yang.

Author

Posts

May 30, 2021 at 10:44 pm #2072105

charlesY-4

Hi, I believe that my issue is simply one that will be solved by upgrading to Pro, but I want to make sure before I move forward.

I am trying to import data from a Google Sheets database to create custom posts with Toolset. So far, I have done the following:

- Created a custom post type
- Created custom fields for that post type
- Have the data available both in Google Sheets and as a .csv file.

I have watched a tutorial and read your documentation, but am confused about the next step. It SEEMS like I need to export something using phpmyadmin before I can import the data from Sheets or the .csv, but I'm not very familiar with using that and didn't want to mess anything up. My hunch is I need to do something to tell WordPress what columns from my data align with what custom field, but am really at a bit of a loss.

Thanks

Charles Yeganian
hidden link

May 31, 2021 at 6:11 am #2072191

Luo Yang

Hello,

In order to import the csv file into WordPress, you need to install of of CSV import plugin in your website, and follow our document to import the data:
https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/