[Closed] Excel import into custom fields

[Author]

Posts

[ericv-5]

Dear Toolset Support team,

Concerning: hidden link

I have an Excel file (500+ records) with the following columns:
- id
- name
- zip code areas (many, separated by commas)
- website
- phone number
Especially the 'zip code area field' contain many records (2000+)

How can I import this Excel file into the custom fields I created with Toolset?
These are the custom fields:
- name (required, singe line)
- zip code areas (repeatable field, required, single line)
- website (url)
- phone number (Phone)

Wat I did:
* I tried the free version of WP All Import. I did a test with 4 records.
Then I only get a title in; the rest not.
* I tried to use the Toolset Import function, but that did'nt work as I do not know how to create a XML file from Excel nor csv.

If you want admin access to the website to see for yourself, I can grant you access.

Thank you for your help,

Eric

[Minesh]

Hello. Thank you for contacting the Toolset support.

Here is the Doc that shows information how you can import the content:
- https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/

I suggest you should use the following doc:
- https://toolset.com/course-lesson/import-content-csv-importer-plugin/

Here is a sample file as well:
- https://toolset.com/course-lesson/import-content-csv-importer-plugin/#case-example