{"id":2964,"date":"2014-11-20T20:12:51","date_gmt":"2014-11-20T20:12:51","guid":{"rendered":"https:\/\/help.fromdoppler.com\/?p=2964"},"modified":"2025-06-03T20:42:42","modified_gmt":"2025-06-03T20:42:42","slug":"consejos-para-trabajar-correctamente-con-excel-y-los-campos-personalizados","status":"publish","type":"post","link":"https:\/\/help.fromdoppler.com\/en\/how-to-operate-the-date-custom-fields\/","title":{"rendered":"How to operate the date Custom Fields"},"content":{"rendered":"

Do you want to know how to take full advantage of the information you have from your Subscribers as numeric format<\/strong>, such as dates? Then, read this article to work with Custom Fields!<\/p>\n

When you enter the data from your Subscribers in an Excel file<\/strong> to later import them into a new Doppler<\/a> List, you may have to complete date type fields<\/strong>; that\u2019s because you may want to base your communications on dates, anniversary, or subscription payment, among others.<\/p>\n

When you create your List and complete each row and column with the relevant data, be sure to correctly enter the date in question<\/strong>.<\/p>\n

\"NumericField\"<\/p>\n

Complete all cells of the file and when you save it to import into Doppler<\/a>, we recommend NOT doing it as an Excel file (.xls) but as CSV<\/strong> (comma-separated values) or text <\/strong>(.txt).<\/p>\n

\"numericField1\"<\/p>\n

This way you can be sure that using this Custom Field of type date<\/strong>, Doppler <\/a>will associate what Excel brings properly.<\/p>\n

Dates are often a critical part of the data analysis, so that Doppler<\/a> and Excel interpret them correctly, they should be written as specifically as possible<\/strong>. Another tip is to select the entire column<\/strong> with numerical information, and with the right mouse button<\/strong> edit the Format Cell<\/strong>.<\/p>\n

\"NumericField2\"<\/p>\n

In Category select Date and then choose your Type<\/strong>. You will see a preview of your form in the Sample box <\/strong>with the first date of your data. If you want to use the date format that is used in a particular country or area, select the language<\/strong> below the regional settings (location).<\/p>\n

Now you can import your .csv, .txt or .xls<\/strong> (format cell released at date) and Doppler<\/a> will read your data as you entered it into the Excel to make your Campaigns a success in custom content.<\/p>\n

Don’t have your Doppler account yet? What are you waiting for? Clicking here<\/a> you can register and start working with the Custom Fields of\u00a0dates to improve the results of your Campaigns.<\/p>\n