MS Excel to Wordpress posts

Discussion in 'Blogging' started by AlexMed, Nov 12, 2014.

  1. AlexMed

    AlexMed Newbie

    Joined:
    Oct 26, 2014
    Messages:
    30
    Likes Received:
    5
    Hey, everyone,

    I am working on transitioning my newspaper's website to the wordpress platform. The CMS I'm using now costs too damn much per month ($325) and is too limited. Each morning I get arrest reports from some of the local PDs, and I'm trying to get them into posts. These are always sent in Excel format. I have not been able to get this to work in my current CMS and am trying to get it to work in WP. Converting to txt doesn't work without a lot of extra work put in getting the columns to work correctly. It can take an hour for each report, and I get reports from 5 different PDs.

    I was wondering if anyone has had any experience with a plugin, perhaps, that works for this sort of thing. I've been filtering through WP plugins but haven't found anything yet.

    Thank you so much,

    SG
     
  2. Conor

    Conor Elite Member

    Joined:
    Nov 7, 2012
    Messages:
    3,618
    Likes Received:
    6,078
    Gender:
    Male
    Location:
    South Africa
    Try this: https://wordpress.org/plugins/csv-2-post/faq/

    You'll probably have to format the spreadsheets first, but it should take a lot quicker than an hour once you get the hang of it, I think.
     
    • Thanks Thanks x 1
  3. AlexMed

    AlexMed Newbie

    Joined:
    Oct 26, 2014
    Messages:
    30
    Likes Received:
    5
    Disregard. I think I found one that will work. It's ugly but it gets the data in. In case someone else is looking for this, the plugin I found is called WP Excel CMS.

    Sorry to bother everyone.