Title: Import custom data to an array
Last modified: November 30, 2017

---

# Import custom data to an array

 *  [studioavanti](https://wordpress.org/support/users/studioavanti/)
 * (@studioavanti)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/import-custom-data-to-an-array/)
 * Hi,
 * I use WP Custom Area, a plugin that adds custom fields to users profile like “
   City”, “Zip code”…
    It seems those data are stored under a single meta key in
   WP database and each is part of an array. Is “Import users from CSV with meta”
   able to import such data? If yes, how to prepare them in the spreadsheet (CSV)?
 * Thanks for your informations!

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/import-custom-data-to-an-array/#post-9736414)
 * Good morning,
 * Yes, look at how the arrays are managed in the CSV in the “Documentation” tab.
 * You will get there the information.
 * If you need personal assist, tell me and we give you proffessional support.
 *  Thread Starter [studioavanti](https://wordpress.org/support/users/studioavanti/)
 * (@studioavanti)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/import-custom-data-to-an-array/#post-9736752)
 * Hello Javier,
 * Thanks for your answer.
    Sure i would need support, documentation won’t be enough
   for me to manage this, i’m a graphic / web designer, not a developper.
 * The question is: how to prepare my Excel spreadsheet to import **WP Customer 
   Area** plugin users custom fields using **Import users from CSV with meta**?
 * The WPCA users custom fields seem to be stored in an option table in the DB, 
   like this:
    —————————————————- **option_id** 3218
 * **option_name**
    cuar_owner_addresses|usr|2
 * **option_value**
    a:1:{s:12:”home_address”;a:10:{s:4:”name”;s:0:””;s:7:”company”;
   s:8:”testcuar”;s:10:”vat_number”;s:0:””;s:8:”logo_url”;s:0:””;s:5:”line1″;s:27:”
   25 boulevard de la Liberté”;s:5:”line2″;s:0:””;s:3:”zip”;s:5:”35000″;s:4:”city”;
   s:6:”Rennes”;s:7:”country”;s:2:”FR”;s:5:”state”;s:0:””;}} —————————————————-
 * I’d like to import fields like « line1, line2, zip, city, country… »
 * How would charge for this support please?
 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/import-custom-data-to-an-array/#post-9736759)
 * [@studioavanti](https://wordpress.org/support/users/studioavanti/),
 * This seems to be not so easy as a simple array. Maybe we would need to do a little
   addon.
 * Write me directly to [contacto@codection.com](https://wordpress.org/support/topic/import-custom-data-to-an-array/contacto@codection.com?output_format=md)
   and we see how it would be done.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Import custom data to an array’ is closed to new replies.

 * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png?
   rev=1174343)
 * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/)
 * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/)

## Tags

 * [array](https://wordpress.org/support/topic-tag/array/)
 * [meta key](https://wordpress.org/support/topic-tag/meta-key/)

 * 3 replies
 * 2 participants
 * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/import-custom-data-to-an-array/#post-9736759)
 * Status: not resolved