Title: Date Problem With csv Import
Last modified: August 21, 2016

---

# Date Problem With csv Import

 *  Resolved [cmsnet](https://wordpress.org/support/users/cmsnet/)
 * (@cmsnet)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/date-problem-with-csv-import/)
 * Hi Tobias,
 * After testing Tablepress out, I set up a live site and mirrored the setup.
 * The problem I am having is: I copied and pasted some dates form an .xls spreadsheet
   and pasted them into a Tablepress column. I set up the European date formulas
   but for some reason when you click on the column to sort it nothing happens or
   if you remove the formula the data is all over the place.
 * I have tried exporting the data as HTML, pasting it as plain text into a new 
   spreadsheet, then importing it back into Tablepress as a csv file. I have also
   tried this by exporting as a csv file.
 * If I import the dummy data as a csv from the original test site all the date 
   sorting works fine.
 * Any ideas what might be going on?
 * Many thanks.
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 2 replies - 16 through 17 (of 17 total)

[←](https://wordpress.org/support/topic/date-problem-with-csv-import/?output_format=md)
[1](https://wordpress.org/support/topic/date-problem-with-csv-import/?output_format=md)
2

 *  Thread Starter [cmsnet](https://wordpress.org/support/users/cmsnet/)
 * (@cmsnet)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/date-problem-with-csv-import/page/2/#post-4786544)
 * I made the error of saving the Excel file as .xls instead of .csv
 * When I imported the table into Tablepress it messed up some of the formatting
   by swapping some of the dates to the US date system.
 * After re-saving the Excel file in the .csv format and importing it into Tablepress
   everything worked fine.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/date-problem-with-csv-import/page/2/#post-4786547)
 * Hi,
 * yes, that’s likely the reason then 🙂 Good to hear that the CSV format worked!
   The .xls import is not very sophisticated, so that it probably has trouble with
   different data formats.
 * Regards,
    Tobias

Viewing 2 replies - 16 through 17 (of 17 total)

[←](https://wordpress.org/support/topic/date-problem-with-csv-import/?output_format=md)
[1](https://wordpress.org/support/topic/date-problem-with-csv-import/?output_format=md)
2

The topic ‘Date Problem With csv Import’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

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

 * 17 replies
 * 3 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/date-problem-with-csv-import/page/2/#post-4786547)
 * Status: resolved