Freeware Import from Excel

Hello -- I am trying to import from an excel file with columns like:

Table Caption Name Data Type
adh.cm_dt_impressions user_id user_id STRING
adh.cm_dt_impressions event event RECORD
adh.cm_dt_impressions event. event_time event. event_time INT64
adh.cm_dt_impressions event. advertiser_id event. advertiser_id INT64
adh.cm_dt_impressions event. campaign_id event. campaign_id INT64

When I try to import it, however, it doesn't show any records in the 'name' or 'caption' fields in the pop-up box. And when I click import, it just shows 'finished', but nothing is created.

Not sure what I'm doing wrong.

Thanks.

Hello mike,

I think you are using your excel file.
However, Toad Data Modeler requires an excel file with a fixed format.

emptyExcelFile
Figure 1. Prepared excel file for import (empty model).

Solution:

  1. Create a new empty model.
  2. Export to Excel.
  3. Now, you received excel file with defined columns and sheets.
  4. You can insert your data to fields.
  5. Try import from excel.

Regards
Petr

Perfect. Thank you.

Hi, is there any URL to download spreadsheet template?

Hi kumardm,
there is no any url to download template, but you can create it by process above. You need only TDM and Excel on your machine.

Regards
Petr