Title: CSV Import
Last modified: August 31, 2016

---

# CSV Import

 *  Resolved [dson](https://wordpress.org/support/users/deannasonni/)
 * (@deannasonni)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/)
 * I copied and pasted the CSV headers straight from the example one, but upon import
   it is saying I’m missing the “business_name” header..which I’m not. The fields
   are filled out, nothing is missing. Not sure how to troubleshoot.
 * Thanks,
 * [https://wordpress.org/plugins/business-directory-plugin/](https://wordpress.org/plugins/business-directory-plugin/)
 * Link to view CSV file:
    [https://drive.google.com/file/d/0B-xU8gTd1nHFYlJpak94QVpaQ1U/view?usp=sharing](https://drive.google.com/file/d/0B-xU8gTd1nHFYlJpak94QVpaQ1U/view?usp=sharing)

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

 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094789)
 * Hi deannasonni,
 * Sorry that you ran into issues here!
 * In the past, when I’ve seen that error with others, it’s usually because whatever
   program you’re using to output the final CSV file adds some garbage to the first
   header column (something like ?>>) and this throws off BD.
 * If you’re using OpenOffice, which seems to be a common thread, save it in CSV
   format and then open it using a very simple text editor (like Notepad on Windows
   or TextEdit on Mac) and the delete that extraneous garbage in the file at the
   first column, re-save it, and then try the import.
 * If that doesn’t work, report back and we’ll take it from there!
 *  Thread Starter [dson](https://wordpress.org/support/users/deannasonni/)
 * (@deannasonni)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094906)
 * Thanks, but that didnt work. I’m using excel, saved as a CSV, and I opoened it
   in text editor and it looks exactly like the example one::
 * rating_average,business_name,category,short_business_description_110_characters_or_less,
   description,website,business_phone_number,business_hours,business_fax,contact_email,
   street_address,town,continent,state,Zip,Country,state,images,username,sequence_id,
   expires_on
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094915)
 * Hi deannasonni,
 * Hmmm. OK. Let’s try this.
 * Can you please post:
    – A link to the actual CSV file with a few lines in it –
   A link to a screenshot showing the field configuration as BD thinks it exists
   on your Directory Admin->CSV Import page? Use [http://imageshack.us](http://imageshack.us)
   if you have to.
 * That will help me understand the issue better.
 *  [CriterioNet](https://wordpress.org/support/users/criterionet/)
 * (@criterionet)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094973)
 * fields must be in quotes, you verified that?
 * ej:
    line 1: header1,header2,header3 line 2: “field1″,”field2″,”Field3”
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094975)
 * That’s a good point CriterioNet, but would depend on the data being used.
 * Quotes should be around fields that have separators you’re using inside of them,
   like commas.
 * If you have a long description field with a comma inside, you definitely need
   quotes around it. But you probably don’t need that on all fields, unless you 
   just want to be super careful.

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

The topic ‘CSV Import’ is closed to new replies.

 * ![](https://ps.w.org/business-directory-plugin/assets/icon-256x256.png?rev=2901888)
 * [Business Directory Plugin - Easy Listing Directories for WordPress](https://wordpress.org/plugins/business-directory-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/business-directory-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/business-directory-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/business-directory-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/business-directory-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/business-directory-plugin/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 5 replies
 * 3 participants
 * Last reply from: [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/csv-import-24/#post-7094975)
 * Status: resolved